Use these steps to create the ODBC data sources required to access datastore databases.
There are a number of different driver managers that you can use to configure an ODBC data source. These instructions are carried out using unixODBC. If you are using a different driver manager, consult the vendor instructions for creating data sources.
(This may differ depending on the version of PostgreSQL you are running.)
[PostgreSQL] Description=ODBC for PostgreSQL Driver64=/usr/pgsql-10/lib/psqlodbcw.so Setup64=/usr/lib64/libodbcpsqlS.so FileUsage=1
[<datasource-name>] Driver = <driver-name> Server = <server-name> Port = <port-no> Database = postgres
[<datasource-name>] Driver = <driver-name> Server = <server-name> Port = <port-no> Database = MicroFocus$SEE$Files$<datastore-name>
The following is an example of an .odbc.ini configuration file contains data sources for a local PostgreSQL database instance with two datastores. It also includes the mandatory data source for the postgres database.
[PG.POSTGRES] Driver = PostgreSQL Server = localhost Port = 5432 Database = postgres [PG.VSAM] Driver = PostgreSQL Server = localhost Port = 5432 Database = MicroFocus$SEE$Files$VSAM [PG.SEQFILES] Driver = PostgreSQL Server = localhost Port = 5432 Database = MicroFocus$SEE$Files$SEQ