Scan to Database
The Scan to Database function in Scan2x allows for the definition of a job that will write output directly into a Microsoft SQL or Oracle database. This is true for both metadata and the actual document.
Note: When saving a document in a database table, it is saved as Byte() or Base64String depending on the datatype of the column that it is being saved into.
To configure this, one must connect to the database server, then to the database and finally to the table to be written into. The remainder of this example will describe the process for connecting to Microsoft SQL, but Oracle is similar in nature.
Scan2x detects and lists all visible MS SQL servers and pre-populates the Server dropdown. Select the server you wish to connect to from this list.
Then select the Authentication method you wish to use, and if you have chosen SQL Server Authentication, enter the username and password that Scan2x will use to connect to the server.
Press the Database dropdown refresh button (see button outlined in red on the screenshot below) – this will attempt to connect to the server and access the database.
Select the Table Name using the dropdown – press the refresh button alongside it if necessary.
Click the Connect to Database Table button.
If the connection is successful, the columns of the selected database table will appear in the central grid.
•In the IsPrimary column, job administrators can identify one or more fields to act as the primary key/s of the database table.
•In the Encrypted column, job administrators can select which table column to be encrypted.
•In the Value column, select the dropdown to define what document metadata goes into each table column, as shown in the screenshot below.