Exploring a database connection in Atrium Integrator Spoon
You can explore configured database connections in Atrium Integrator Spoon.
To explore a database connection
- Open your transformation in Atrium Integrator Spoon. For more information, see Opening Atrium Integrator job or transformation.
- Click
.
The Make your selection dialog box appears. - 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. - 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.
Comments