Creating a Data Source Name

Typically, after installing the Simba PostgreSQL ODBC Connector, 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:

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

    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 PostgreSQL.

  2. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the Simba PostgreSQL ODBC Driver appears in the alphabetical list of ODBC connectors 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 Simba PostgreSQL ODBC Driver and then click Finish. The Simba PostgreSQL ODBC Driver DSN Setup dialog box opens.
  6. In the Data Source Name field, type a name for your DSN.
  1. In the Server field, type a comma-delimited list of endpoint servers you want to connect to.
  2. In the Port field, type the number of the TCP port that the server uses to listen for client connections.

    Note: The default port used by PostgreSQL is 5432.

  3. In the Database field, type the name of the database that you want to access.
  4. In the Authentication area, do one of the following:
    • To authenticate the connection using standard user name and password authentication, do the following:
      1. From the Auth Type drop-down list, select Standard.
      2. In the User field, type your user name for accessing the PostgreSQL database.
      3. In the Password field, type the password corresponding to the user name you typed.
      4. To encrypt your credentials, select one of the following:
        • If the credentials are used only by the current Windows user, select Current User Only.
        • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.
    • Or, to authenticate the connection using the Kerberos protocol, do the following:
      1. From the Auth Type drop-down list, select Kerberos.
      2. In the User field, type your user name for accessing the PostgreSQL database.
      3. In the Service Name field, type the Kerberos service principal name of the PostgreSQL server.
  5. To configure client-server verification over SSL, click SSL Options. For more information, see Configuring SSL Verification.
  6. To configure advanced connector options, click Additional Options. For more information, see Configuring Additional Options.
  7. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  8. To configure how the connector returns and displays data, click Data Type Options. For more information, see Configuring Data Type Options.
  9. To test the connection, click Test. Review the results as needed, and then click OK.

    Note:

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

  10. To save your settings and close the Simba PostgreSQL ODBC Driver DSN Setup dialog box, click OK.
  11. To close the ODBC Data Source Administrator, click OK.