Database

Contents

Store

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.

The Wizard button will display a dialog containing all the properties of the selected driver, please refer to the specific driver information to know the meaning of each property.

Warning

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.

Warning

System DSN does not support authentication and will perform connection under local service authority. If authentication is required please use the Wizard and the database driver.

Warning

Windows authentication is strongly discouraged because Scanshare is running under system services authorities.

Query
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.

Info

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

Info

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

Parameters may contains quotes.

Info

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.

Warning

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.

Info

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.

Wizard

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.

Warning

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

Properties
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

Djuma