Connecting to a Data Store

If you are not already connected to a data store when you try to sample data or open a schema definition from a data store, the Schema Editor prompts you to provide your connection information and connect to the data store.

To connect to a data store through ODBC:

  1. In the connection prompt, do one of the following:
    • Select DSN List and then select a DSN from the drop-down list.
    • Or, select Connection String and then type an ODBC connection string in the field.

    Note:

    For more information about connection string syntax, see the Installation and Configuration Guide for your connector.

  2. Click Connect.

To connect to a data store through JDBC:

  1. In the connection prompt, in the Connection URI field, type a JDBC connection URL.

    2. Note:

    For more information about connection URL syntax, see the Installation and Configuration Guide for your connector.

  2. Click Connect.

Related topics