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.
- 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:
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.
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. |
Comments
Log in or register to comment.