Breadcrumbs

Configure ODBC Driver

This section explains how to create an ODBC data source that allows Metadata Server to connect to a metadata database stored in SQL Server.

  1. Go to the Windows Control Panel and select System and Security > Administrative Tools > Data Sources (ODBC).

    The ODBC Data Source Administrator window displays.

  2. Select the System DSN tab.

    It is important to create a system data source, rather than a user data source, as this will allow you to run the Metadata Server as a Windows Service.

  3. Click Add.

    ODBC-DSA.png

    The Create New Data Source window displays.

  4. Follow the steps below that apply to your RDBMS.

SQL Server

  1. Select SQL Server and click Finish.

    ODBC-Create-SQL-Server.png

    The Create a New Data Source to SQL Server window displays.

  2. Give your new data source a Name and Description.

    Make a note of the name as you will need this to configure Metadata Server.

  3. From the Server drop-down list, select your SQL Server instance and click Next.

    ODBC-Details.png

    You are prompted to enter the login details.

  4. Enter the login details for your SQL Server and click Next.

    ODBC-Connect-Credentials.png

    You are prompted to select the default database.

  5. Select your metadata database from the drop-down list at the top, then click Next (leave the rest of the settings on this screen unchanged).

    ODBC-Select-Metadata-Database.png

  6. Leave the values on the next screen unchanged and click Finish.

    ODBC-lang-settings.png

    A summary screen displays.

  7. Use the Test Data Source button to verify the settings are correct (make sure that the result is TESTS COMPLETED SUCCESSFULLY).

    ODBC-Summary.png

  8. When you are happy with the settings, click OK to close the ODBC Microsoft SQL Server Setup window and create the data source.

  9. Verify that your new data source appears in the list:

    ODBC-User-Data-Sources.png

Oracle

  1. Select Oracle and click Finish.

    ODBC-Oracle-1.png

  2. Give your data source a Name and Description. Make a note of the name as you will need this to configure the Metadata Server.

  3. Enter the service name and the details of the user you want to use to connect to the Oracle database.

    ODBC-Oracle-2.png

  4. Click Test Connection to verify the credentials.

  5. Once you have verified that the credentials are correct, click OK to create and save your data source.

MySQL

  1. Select the MySQL Unicode Driver and click Finish.

    ODBC-MySQL-1.png

  2. Give your data source a Name and Description. Make a note of the name as you will need this to configure the Metadata Server.

  3. Enter the server details, the login credentials, and select the database from the drop-down list.

  4. Click Test to verify the credentials.

    ODBC-MySQL-2.png

  5. Once you have verified that the credentials are correct, click OK to create and save your data source.