Use PostgreSQL

To use PostgreSQL with Xalt | Integration, install the PostgreSQL ODBC Driver.

SHARED Tip Go to https://odbc.postgresql.org to install the PostgeSQL ODBC driver

Then, configure the ODBC Data Source using the ODBC Data Source Administrator tool as shown in the images below.

In an Xalt | Integration system using the DBReader component, configure the ODBC connection using the following connection string pattern:

DBReader Connection string

Driver={PostgreSQL ODBC Driver(ANSI)};Server=localhost;Port=5432;Database=postgres; Uid=postgres;Pwd=;

Replace the values shown above for the following parameters with values that match your specific configuration:

  • Server=
  • Port=
  • Database=
  • Uid=
  • Pwd=

Example Select:

select a.base, a.local, a.rota, a.mapa, a.situacao from int_locais_rotas a

Open the ODBC Data Source Administrator :

To open the ODBC Data Source Administrator in Windows 10

  • In the Search box, type ODBC Data Sources. The ODBC Data Source Administrator dialog box appears.

    SHARED Tip Follow the on-screen instructions shown in the images below to proceed further.

ODBC1

ODBC2