Windows: Create Datastore Data Sources for PostrgreSQL

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

Use these steps to create the ODBC data sources required to access datastore databases.

  1. Open the ODBC Data Source Administrator.
    Tip: On most newer Windows versions, click the Start Menu button, type ODBC, and then select the appropriate desktop app.
  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
  3. Add the mandatory data sources:
    Note: In order to create or query databases, you must have an active data source connection to the postgres database - one of the default databases created with any PostgreSQL server. If this connection already exists, you can skip this step:
    1. Click Add.
    2. Select the appropriate ODBC driver for your database (for example, PostgreSQL ODBC Driver (ANSI) is a common one for PostgreSQL), and click Finish.
      Note: If you are planning to run both 32-bit and 64-bit applications, you are required to install an ODBC driver for each bitism.

      The PostgreSQL setup dialog box appears.

    3. In the Data Source and Description fields, enter a name and description for the data source.
      Tip: Make a note of the name, as you will need it later when configuring the database configuration file.
    4. In the Database field, type postgres.
    5. In the Server and Port fields, enter the server name and port.
    6. In the User Name and Password fields, enter a set of valid user credentials.
    7. Click Test.

      The connection should be successful; if not, it indicates that you have a problem with your PostgreSQL installation, and should consult the vendor instructions to troubleshoot before proceeding any further.

    8. Click Save.
  4. Add a new data source for each required datastore:
    1. Click Add.
    2. Select the appropriate ODBC driver for your database (for example, PostgreSQL ODBC Driver (ANSI) is a common one for PostgreSQL), and click Finish.
      Note: If you are planning to run both 32-bit and 64-bit applications, you are required to install an ODBC driver for each bitism.

      The PostgreSQL setup dialog box appears.

    3. In the Data Source and Description fields, enter a name and description for the data source.
      Tip: Make a note of the name, as you will need it later when configuring the database configuration file.
    4. In the Database field, using the datastore-specific notation, enter a database name:
      MicroFocus$SEE$Files$<datastore-name>

      where <datastore-name> is the name of the datastore that you want to create.

    5. In the Server and Port fields, enter the server name and port.
    6. In the User Name and Password fields, enter a set of valid user credentials.

      The database has yet to be created, and so do not click Test.

    7. Click Save. The ODBC Data Source Administrator appears again.
    8. Repeat these sub-steps for each additional datastore you require.
  5. Click OK.

    The data sources for the datastores are configured.

Next, you must create or edit a configuration file, so that it contains entries to each of your datastore data sources.