[mysql]
Description = General ODBC for MySQL
Driver      = /usr/lib64/libmyodbc5.so
Setup       = /usr/lib64/libodbcmyS.so 
FileUsage   = 1

[TEST_MYSQL]                                                     
Description = MySQL database 1                                   
Driver  = mysql                                                  
Port = 3306                                                      
Server = 127.0.0.1                                               
                                                                 
[TEST_MYSQL_FILLED_CRED]                       
Description = MySQL database 2                 
Driver  = mysql                                
User = root                                    
Port = 3306                                    
Password = Qwestions                           
Database = zbx_206                             
Server = 127.0.0.1                             

[TEST_MYSQL_FILLED_CRED_SOCK]                  
Description = MySQL database 3                 
Driver  = mysql                                
User = root                                    
Password = Qwestions                           
Socket = /var/run/mysqld/mysqld.sock           
Database = zbx_206

[postgresql]
Description = General ODBC for PostgreSQL
Driver      = /usr/lib64/libodbcpsql.so
Setup       = /usr/lib64/libodbcpsqlS.so
FileUsage   = 1
# Since 1.6 if the driver manager was built with thread support you may add another entry to each driver entry.
# This entry alters the default thread serialization level.
Threading   = 2

[TEST_PSQL]
Description = PostgreSQL database 1
Driver  = postgresql
#CommLog = /tmp/sql.log
Username = zbx_test
Password = password
# Name of Server. 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.
ReadOnly = No
# PostgreSQL backend protocol
# Note that when using SSL connections this setting is ignored.
# 7.4+: Use the 7.4(V3) protocol. This is only compatible with 7.4 and higher backends.
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.
# It also speeds the update process since every single column does not need to be specified in the where clause to update a row.
RowVersioning = No
# Show SystemTables
# The driver will treat system tables as regular tables in SQLTables. This is good for Access so you can see system tables.
ShowSystemTables = No
# If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache.
Fetch = Yes
# Bools as Char
# Bools are mapped to SQL_CHAR, otherwise to SQL_BIT.
BoolsAsChar = Yes
# SSL mode
SSLmode = Yes
# Send tobackend on connection
ConnSettings =

# yum -y install freetds unixODBC unixODBC-devel

$ vi /etc/odbcinst.ini
[FreeTDS]
Driver = /usr/lib64/libtdsodbc.so.0

$ vi /etc/odbc.ini
[sql1]
Driver = FreeTDS
Server = <SQL server 1 IP>
PORT = 1433
TDS_Version = 8.0

[sql2]
Driver = FreeTDS
Server = <SQL server 2 IP>
PORT = 1433
TDS_Version = 8.0

# yum -y install freetds unixODBC unixODBC-devel

$ vi /etc/odbcinst.ini
[Sybase]
# Sybase ODBC Driver
Driver = /usr/lib64/libsybdrvodb.so # sybase driver
# Driver = /usr/lib64/libtdsodbc.so.0 # freetds driver

$ vi /etc/odbc.ini
[sybase1]
Driver = Sybase
Server = <ASE server 1 IP>
PORT = 5000

[sybase2]
Driver = Sybase
Server = <ASE server 2 IP>
PORT = 5000