Fetch = Yes # Bools as Char # Bools are mapped to SQL_CHAR, otherwise to SQL_BIT. ShowSystemTables = No # If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache. 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. ODBC Driver for PostgreSQL is a high-performance connectivity solution with enterprise-level features for accessing PostgreSQL databases from ODBC-compliant BI, ETL, reporting, and analytics tools on both 32-bit and 64-bit Windows, macOS, and Linux. This is only compatible with 7.4 and higher backends. ![]() 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. If you use Surround SCM Linux and will use PostgreSQL for the database, make sure your Linux servers. ![]() Description = PostgreSQL database 1 Driver = postgresql #CommLog = /tmp/sql.log Username = zbx_test Password = zabbix # Name of Server. You can use the 'Databases - Using Compute Node to Insert Data into a DB2 Database via ODBC' tutorial available in the Toolkit Tutorials as a template and adapt it for our Postgres example. Configuring a Helix ALM License Server connection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |