Creating a Data Source Name (DSN) - discovery - 23.1

Spectrum Discovery Guide

Product type
Product family
Spectrum > Discovery
Product name
Spectrum Discovery
Spectrum Discovery Guide
Topic type
How Do I
First publish date

These instructions are specific to Windows platforms.

Attention: Ensure you have logged in to the client machine with administrative rights.
  1. From the Start menu, go to Control Panel > Administrative Tools.
  2. Double-click Data Sources (ODBC).
    The ODBC Data Source Administrator window opens.
  3. Click either the User DSN tab or the System DSN tab, depending on the type of DSN you wish to create.
  4. Click Add.
  5. From the list of installed drivers on the machine, select PostgreSQL ANSI, and click Finish.
    The PostgreSQL ANSI ODBC Driver (psqlODBC) Setup dialog box opens.
    Attention: Select PostgreSQL ANSI or PostgreSQL Unicode, based on the client application through which the ODBC connection is to be used.
  6. Enter the following details to map this DSN to the desired model store:
    1. In the Data Source field, enter the name you wish to assign to the DSN.
    2. In the Database field, enter the name of the model store to which you wish to connect through this DSN.
    3. In the Server field, enter the name of the machine on which the Spectrum Technology Platform server is running.
    4. In the Port field, enter the value of the property edf.odbc.socket.port, as configured in the file. See Common Configuration Properties.
      By default, the port is 32751.
    5. In the User Name field, enter the user name of the Spectrum Technology Platform server.
    6. In the Password field, enter the password of the Spectrum Technology Platform server.
    7. Click Datasource in the Options section.
      The Advanced Options (PostgreSQL30) dialog box opens.
    8. On Page 1, configure the options as below:

    9. Click Page 2, and configure the options as below:

    10. Click OK to close the Advanced Options (PostgreSQL30) dialog box.
    11. Click Test to check if the created DSN connects to the configured model store successfully.
      Important: Ensure the model store is deployed to test the DSN successfully.
    12. Click Save.
The created DSN allows you to connect to the configured model store using applications like MS Excel, MS Access.