How to Connect to a Database
Prerequisite: a source connection must already be set up in the eXate Vault before you can create a connection to a specific database.
- Navigate to the Datagator menu and select Database Configuration
- Click the "+" button to create a new database job definition
- Select the database type (SQL Server, Oracle, MySQL, or Snowflake)
- Select the source connection, already set up in the eXate Vault
- Click Connect, the database will appear, letting you select the tables you want