Daasity Knowledge Base
Ask or search…
K

Postgres Database

Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Integration Details

Daasity connects to Postgres databases via an ODBC connector. Some key notes on the Daasity method for data replication:
  • A user will be needed that has read permissions in the Postgres database. This user will access via ODBC and execute the data replication
  • Data replication is performed by running SQL queries against the Postgres database
  • The DDL is read at time of initial setup and sets the definitions for all the tables. If tables are added, deleted or modified please contact Daasity Support