This documentation supports the 9.1 to 9.1 Service Pack 3 version and its patches of BMC Atrium Core. The documentation for version 9.1.04 and its patches is available here.

To view the latest version, select the version from the Product version menu.

Exploring a database connection in Atrium Integrator Spoon

You can explore configured database connections in Atrium Integrator Spoon.

To explore a database connection

  1. Open your transformation in Atrium Integrator Spoon. For more information, see Opening Atrium Integrator job or transformation.
  2. Click .
    The Make your selection dialog box appears.
  3. Select the database connection that you want to explore, and click OK.
    The Database explorer on connection dialog box appears with a list of all the schemas, tables, and views in the selected connection.
  4. Select the table that you want to explore.The Action menu to the right provides quick access to the following features for the selected table:

Button

What it does

Preview first 100 rows

Returns the first 100 rows from the selected table.

Preview first ... rows of...

Allows you to specify the number of rows to return from the selected table.

Number of rows

Returns the total number of rows that the selected table contains.

Show Layout

Displays a list of column names, data types, and so on from the selected table.

Generate DDL

Generates the DDL to create the selected table based on the current connection type.

Generate DDL for other connection

Prompts you to select another connection, then generates the DDL to create the selected table based on the selected connection type.

Open SQL

Launches the Simple SQL Editor for the selected table.

Truncate table

Generates a TRUNCATE table statement for the current table.

Note

For MSQL datastore connection with Window Authentication, you must update the Domain parameter inside the Database Connection > Options tab. Then add Windows user's credentials and test the MSQL connection.

Was this page helpful? Yes No Submitting... Thank you

Comments