Create Database Connection

Database Connection may be created while creating new workspace or within an existing workspace.
Once you add Database Connection to the workspace, it appears on both left and right trees.

1. Right-click on Database Connections node
2. Use Add Database Connection
3. Specify database connection name. Using descriptive name will help you later to easily identify the database connection.
4. Optional - you can specify the database connection description
5. Click Next
6. Select if you want to use ODBC DSN or to create a connection string
   • Using an existing ODBC DSN
     1. From the combo box, select an existing registered ODBC DSN. (To create new ODBC DSN, click Create New DSN and ODBC Administrator application will open)
     2. Use Test Connection to check that the ODBC DSN was created properly and can be used
   • Using an ODBC connection string
     1. Write the ODBC connection string, according to your database specifications.
     2. Alternatively, click Build button and you will be guided through connection string creation. In the Build dialog, you can select Database Vendor and choose if you want the connection string to be created, based on an existing ODBC DSN, or if you just want to see the list of the database properties and fill in them these values (the connection string will be created according to pairs of parameter-value).
     3. Click Test Connection to check the connectivity, using newly created connection string
7. Select the Database Schema. Database schema parameter isn't used in general ODBC connection. Cross-Database workspace internal environment allows you to use this advanced connection information, in addition to general ODBC connection information
8. Schema owned by the current user All objects, created in the database by the user, specified in ODBC connection information, will be accessible for you via Database Connection.
9. Select authorized schemas – Recommended Using Set Schemas List button you can select the schemas, you want to work with, using Database Connection in Cross-Database Studio. The dialog shows you all the schemas authorized for the user defined in ODBC connection.
10. Custom schema This advanced option allows you to create "virtual" schema, which will exist only in Cross-Database software (and will not be shown in the backend database). Using this option, you simplify and shorten the work with the database. You may use this option, if your database contains a huge amount of tables in different schemas while for Comparison, Synchronization or Migration needs you will use several tables only. You can select these tables now, creating a virtual schema. It will simplify later connections and navigation through the tables.
    1. Click New Custom Schema to create the new virtual internal schema.
    2. Select tables from the list (use check-box near the table name).
11. Click Next
12. Review the summary of the database connection configuration
13. Press Finish to create the database connection

See also:

• Create Database Connection
• Import Database Connection
• Delete Database Connection
• Database Connection Properties
• Connect to the Database