Connect In-DB Tool

The Connect In-DB tool creates an in-database connection in a workflow. Use the tool to connect to a new or existing connection.

In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, see In-Database Overview.

Configure the tool

  1. In the Configuration window, click the Connection Name drop-down arrow and selection an option:
    • Manage Connections: Create a new connection or use an existing connection.
    • Open File Connection: Browse to a saved database connection file.
  2. Once the connection is configured, Table or Query displays the name of the selected database table.
  3. (Optional) Click Query Builder to select tables and construct queries. See Choose Table or Specify Query Window.

See Manage In-DB Connections to learn how to manage In-DB connections.