Connect to a Repository via ODBC

Keyboard Shortcuts

Ctrl+O

Other

: Open Project

Start Page : Manage Projects

1

In the 'Open Project' dialog, click on the Connect to Server button drop-down arrow and select the 'ODBC Connection Wizard' option. The 'Data Link Properties' dialog displays.

2

Select 'Microsoft OLE DB Provider for ODBC Drivers' from the list.

3

Click on the Next>> button.

The 'Connection' tab displays.

4

Click on the 'Use data source name' radio button and, in the data field, click on the down arrow. From the list, select the ODBC driver you have set up to connect to your database repository.

5

If required, type in a user name and password.

If required (for MariaDB, MySQL), in the 'Enter initial catalog to use' field, click on the down arrow and provide an initial catalog name.

6

Click on the Test Connection button to confirm that the details are correct.

7

If the test does not succeed, revise your settings.

If the test succeeds, click on the OK button.

If appropriate (Oracle) the database prompts you for the password - type in the password.

8

The 'Connection Name and Type' dialog displays.

9

Give the connection a suitable Name so that you can recognize it in the 'Recent Projects' panel on the 'Open Project' dialog.

10

If you want to hide the connection details from anyone reviewing the connection string, select the 'Encrypt Connection String' checkbox.  This option is most useful when sharing a connection string with other users but you don't want them knowing the exact details.

11

Click on the OK button to complete the configuration and open the repository.

This also adds the Name (defined at step 9) to the 'Recent' list on the Start Page; from now on, you can open the project again just by clicking on this Name.