Configuring The Database Lookup Tool - Infiniworx - Foundation 23.1 - Foundation 23.1 - AnyDoc - external - AnyDoc/Infiniworx/Foundation-23.1/Infiniworx/Infiniworx-Tools/Data-Collection-Tools/Database-Lookup/Configuring-The-Database-Lookup-Tool - 2023-11-17

Infiniworx
Platform
AnyDoc
Product
Infiniworx
Release
Foundation 23.1
License
ft:locale
en-US

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

  1. To define the connection string, click Define in the WHERE Clause field.
  2. The WHERE Clause window is displayed.
  3. Click Configure Connection String. The Choose Connection String dialog box is displayed.
  4. Select one of the following options from the drop-down list:

    • Use Connection String

    • Use UDL File

  5. 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.
  6. On the Choose Connection String dialog box, select the Data Source from the drop-down list.
  7. Select a database provider from the OLE DB Provider drop-down list.
  8. Enter a server or file name in the Server or file name field.
  9. 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.

  10. Click Test Connection to validate the database.
  11. After the database is selected and tested, click OK to close the Choose Connection String dialog box.
  12. Enter the table name from the database.
  13. Select Define next to the WHERE Clause. The WHERE Clause window is displayed.
  14. Type in the rest of the where clause, specifying the Column Name to Data Field name.
  15. Click OK.
  16. Click Define next to the Translations option. The Column Translation window opens. It allows mapping data from certain columns in the database to the data fields previously created.
  17. Click OK.