Create Generic ODBC Connections

You can create generic ODBC connections to databases and use the connections to access data sources. For example, to connect to databases and database versions that aren’t listed with the default connection types.

You can only use generic ODBC connections to connect on Windows systems.

  1. Create the new ODBC data source in Windows.
    1. In Windows, locate and open the ODBC Data Source Administrator dialog.
    2. Click the System DSN tab, and then click Add to display the Create New Data Source dialog.
    3. Select the driver appropriate for your data source, and then click Finish.
    4. The remaining configuration steps are specific to the data source you want to configure.

      Refer to the documentation for your data source.

  2. Create the generic ODBC data source.
    1. On the Data or Home page, click Create, then click Connection.
    2. In the Create Connection dialog, locate and click the ODBC icon.
    3. Enter the connection criteria. Note the following:
      • Name - Any name that uniquely identifies the connection.
      • DSN - The name of the system DSN that you set up on your computer.
    4. Click Save.
      You can now create datasets from the connection.