Creating a Data Source Name on Windows

Typically, after installing the Starburst ODBC Driver, you need to create a Data Source Name (DSN).

Alternatively, for information about DSN-less connections, see Using a Connection String.

To create a Data Source Name on Windows:

  1. From the Start menu, go to ODBC Data Sources.

    2. Note:

    Make sure to select the ODBC Data Source Administrator that has the same bitness as the client application that you are using to connect to Starburst.

  2. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the appears in the alphabetical list of ODBC drivers that are installed on your system.
  3. Choose one:
    • To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
    • Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.

    Note:

    It is recommended that you create a System DSN instead of a User DSN. Some applications load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.

  4. Click Add.
  5. In the Create New Data Source dialog box, select and then click Finish. The DSN Setup dialog box opens.
  6. In the Data Source Name field, type a name for your DSN.
  1. If the database that you are connecting to requires authentication, then use the options in the Authentication area to configure authentication as needed. For more information, see Configuring Authentication on Windows.
  2. In the Host field, type the IP address or host name of the Starburst Enterprise server.
  3. In the Port field, type the number of the TCP port that the Starburst Enterprise server uses to listen for client connections.

    4. Note:

    The default port number used by Starburst is 8080.

  4. In the Catalog field, type the name of the synthetic catalog under which all of the schemas/databases are organized.
  5. In the Schema field, type the name of the schema for the connector to use.
  6. Optionally, in the Time Zone ID field, type the name of the time zone for the connector to use, in tz database format. For a list of time zones in tz database format, see https://en.wikipedia.org/wiki/List_of_tz_database_time_zones.

    7. If a time zone is not specified, the connector uses the system time zone.

  7. To configure client-server verification over SSL, click SSL Options. For more information, see Configuring SSL Verification on Windows.
  8. To configure advanced connector options, click Advanced Options. For more information, see Configuring Advanced Options on Windows.
  9. To configure a connection to a datasource through a proxy server, click Proxy Options. For more information, see Configuring a Proxy Connection on Windows.
  10. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options on Windows.
  11. To test the connection, click Test. Review the results as needed, and then click OK.

    12. Note:

    If the connection fails, then confirm that the settings in the Starburst Starburst ODBC Driver DSN Setup dialog box are correct. Contact your Starburst Enterprise server administrator as needed.

  12. To save your settings and close the Starburst Starburst ODBC Driver DSN Setup dialog box, click OK.
  13. To close the ODBC Data Source Administrator, click OK.