Configuring The Database Update Tool - Infiniworx - Foundation 23.1 - Foundation 23.1 - AnyDoc - external

Infiniworx

Platform
AnyDoc
Product
Infiniworx
Release
Foundation 23.1
License

This tool's icon has a red X indicator until all parts are configured correctly.

  1. Select Map Columns. The Map Update Columns to Values window is displayed.
  2. Select one of the following options from the drop-down list:
    • Use Connection String

    • Use UDL File

  3. Depending on the option you selected in step 2, either select the Browse option in the Connection String field, or enter a UDL File location in the UDL File field. If you select the Browse option for the connection string, the Choose Connection String dialog box is displayed.
  4. On the Choose Connection String dialog box, select the Data Source from the drop-down list.
  5. Select a database provider from the OLE DB Provider drop-down list.
  6. Enter a server or file name in the Server or file name field.
  7. Enter the information required to log into the database.
    Note:

    Set up and login to a database varies depending on the type of database being configured.

  8. Click Test Connection to validate the database.
  9. After the database is selected and tested, click OK to close the Choose Connection String dialog box.
  10. When the table columns appear, map the correct column to the correct system data field variable.
  11. Click OK.
  12. Select Where Clause.
  13. Manually insert single quotes around all string values in the WHERE clause.
    Note:

    The database connection must be configured and columns mapped before configuring the WHERE clause. If a WHERE clause is not specified, all mapped columns will be updated in every row in the table.

  14. Click OK. The connection string and table are now displayed.
  15. For one record per job, select Yes from the drop down.