Fetch = Yes # Bools as Char # Bools are mapped to SQL_CHAR, otherwise to SQL_BIT. Install the PostgreSQL ODBC drivers on the machine that hosts the PowerCenter Integration Service. You must download the 32-bit or 64-bit driver based on your Linux system. ShowSystemTables = No # If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache. Perform the following steps to configure an ODBC connection on Linux: Download the PostgreSQL ODBC drivers from the PostgreSQL website. This is good for Access so you can see system tables. RowVersioning = No # Show SystemTables # The driver will treat system tables as regular tables in SQLTables. # It also speeds the update process since every single column does not need to be specified in the where clause to update a row. Protocol = 7.4+ # Includes the OID in SQLColumns ShowOidColumn = No # Fakes a unique index on OID FakeOidIndex = No # Row Versioning # Allows applications to detect whether data has been modified by other users # while you are attempting to update a row. There is one version for the driver manager unixODBC. This is only compatible with 7.4 and higher backends. The Denodo Platform provides an ODBC driver for Linux, which is based on the ODBC PostgreSQL driver. ReadOnly = No # PostgreSQL backend protocol # Note that when using SSL connections this setting is ignored. IP or DNS Servername = 127.0.0.1 # Database name Database = zabbix # Postmaster listening port Port = 5432 # Database is read only # Whether the datasource will allow updates. Description = PostgreSQL database 1 Driver = postgresql #CommLog = /tmp/sql.log Username = zbx_test Password = zabbix # Name of Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |