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

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

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 federation_config.properties 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.