Connection string
Enter a connection string for the target database, or click on the Variables button on the right, to select a variable which will contain the connection string.

You can either use the Get DSN button to list available system configured DSN or use the Wizard button to generate a new connection string.


Only 64bits system DSN are listed under the Get DSN function. Make sure to configure the DSN as a system DSN (not user) and under the 64bits ODBC Data Source Windows panel.

Enter a target query to execute on the configured database, or click on the Variables button on the right, to select a variable which will contain the query or use variables dynamically inside the query.


The query will be passed directly to the used provider, make sure to use SQL syntax which is valid for the selected provider.


Parametrized variables can be inserted by using the @ symbol in front of the standard variable notation.

Parameters may contains quotes.


To insert the processed document as BLOB inside a specific column use the notation @BLOB as parameter for that column.

An example of a query is:

INSERT into files (filename, contents) values (‘@DBFILENAME’, @BLOB)

Where @DBFILENAME will be replaced with the content of the variable %DBFILENAME% while the notation @BLOB will be replaced with the binary contents of the processed document as BLOB type. The filename will be inserted inside the column named filename while the binary BLOB inside the column named contents, assuming the columns are of their target type.


The query syntax is not always the same for all database types, syntax may be different based on the target database SQL language.

Create insert
Use this button to create a standard default INSERT SQL query placeholder clause.

Create update
Use this button to create a standard default UPDATE SQL query placeholder clause.


Placeholder queries created via the Create Insert and Create Update buttons may not have the right syntax for all providers being defaulted, make sure the correct the syntax according the selected provider.


Select here the provider (driver) to use to generate the target connection string. Drivers installed on the same Scanshare server are listed, by selecting an entry from the list the Properties section will be automatically populated with the specific driver properties.


Only 64bits drivers are listed in this list. Make sure to have the correct driver version installed.

Here all the specific selected driver properties will be listed, configure the needed properties according the type of connection to establish. For further information on the meaning of each property please refer to the selected driver documentation.

Previous Article

Data Output

Next Article