Exploring a database connection in Atrium Integrator Spoon

To explore a database connection

1. Open your transformation in Atrium Integrator Spoon. 
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:

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.