How to connect to a database

Prerequisites: Please ensure a source connection has already been set up. This will be created in the eXate vault. Only then can you create a connection to a specified database.

1. Navigate to the Datagator menu and select database configuration

2. Click the plus sign to create a new database job definition

3. Select the database type. This could be Sql server, Oracle, Mysql and Snowflake.

4. Select the source connection. As shown, the source connection has already been set up in the eXate Vault.

5. Click connect and the database will appear, allowing you to select the tables you desire.