Importing Column Values Through DB Scans

You can import reference data from a database to a reference table by connecting the database to the application. It involves adding columns to reference table and then importing column values from the database. For more information on adding columns to reference tables, refer to the Adding Columns to Reference Tables topic.

To import column values from databases, follow these steps:

  1. In the Workspace pane, click a reference table.

    2. Columns in the reference table appear.

  2. Click .
  3. Click .

    4. The DB Scan page appears.

  4. Enter appropriate values in the fields on the Quick Connection tab to establish a connection with a database. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

    5. Field Name

    Description

    DB Type

    Specifies the database type.

    For example, Sql Server.

    Driver Name

    Specifies the JDBC driver name for connecting to the database.

    For example, com.microsoft.sqlserver.jdbc.SQLServerDriver

    The field is autopopulated based on the DB Type.

    IP Address/Host Name

    Specifies the IP address or server host name of the database.

    For example, localhost.

    Port

    Specifies the port to connect with the database.

    For example: 1433 is the default port for a Sql Server database type.

    Database Name

    Specifies the database name being used to connect to the reference table.

    For example, ErwinDIS931.

    User Name

    Specifies the user name to connect with the database.

    For example, sa.

    Password

    Specifies the password to connect with the database.

    For example, goerwin@1.
  5. Click to test the connection.

    6. If the connection is established, the success message appears.

  6. Write a query in the Query Panel to pull the data from the database.
  7. Click to validate the query.
  8. Click to preview the data.

    9. The data is previewed.

  9. Double-click the Select Column to Import cell under the required column.

    10. A drop-down option appears displaying the reference columns.

  10. Choose an appropriate <Reference_Column_Name> from the drop-down.

    11. You can import multiple columns from the database.

  11. Click .

    12. The column values from the database are imported into the selected reference columns.