-- MonetDB -- Install ODBC client: sudo apt-get install libmonetdb-client-odbc (or --enable-odbc) odbcinst.ini [MonetDB] Description = MonetDB Driver Driver = /usr/lib/libMonetODBC.so Setup = /usr/lib/libMonetODBCs.so odbcinst -i -d -f odbcinst.ini odbc.ini [MonetDB] Description = Connection for MonetDB Driver = MonetDB Database = database Servername = localhost User = monetdb Password = monetdb Port = 50000 odbcinst -i -s -f odbc.ini isql MonetDB -- Postgres -- sudo apt-get install odbc-postgresql odbcinst.ini [PostgreSQL] Description = PostgreSQL Driver Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so odbc.ini [PostgreSQL] Description = Connection for PostgreSQL Driver = PostgreSQL Database = user Servername = localhost User = user Password = user Port = 5432 -- MySQL -- MySQL ODBC Connector: https://dev.mysql.com/downloads/connector/odbc/2.50.html odbcinst.ini [MySQL] Description = MySQL Driver Driver = /home/user/odbc/mysql-odbc/lib/libmyodbc5a.so Setup = /home/user/odbc/mysql-odbc/lib/libmyodbc5S.so odbc.ini [MySQL] Driver = MySQL Description = Connection for MySQL Database = user Server = 127.0.0.1 User = user Uid = user Password = Port = 3306 -- DB2 -- {{sqllib/cfg/db2cli.ini}} [DB2_SAMPLE] Database = DB Protocol=TCPIP Port=50000 Hostname=localhost UID=user PWD=user odbcinst.ini [DB2] Description = IBM DB2 Adapter Driver = /home/user/sqllib/lib/libdb2.so FileUsage = 1 DontDLClose = 1 odbc.ini [DB2_SAMPLE] Description = Connection for DB2 Driver = DB2 export DB2INSTANCE=user isql DB2_SAMPLE -d, user user -- Oracle -- export ORACLE_SID=XE export TWO_TASK=$ORACLE_SID export TNS_ADMIN=/home/user/odbc/tnsnames.ora export ORACLE_BASE=/usr/lib/oracle export ORACLE_HOME=/usr/lib/oracle/12.1/client64 -- tnsnames.ora -- (HAS TO BE IN: $ORACLE_HOME/network/admin/tnsnames.ora) XE2 = (DESCRIPTION = (ADDRESS= (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT=49161)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) [Oracle] Description = Oracle ODBC driver for Oracle 12c Driver = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1 Setup = /usr/lib/x86_64-linux-gnu/odbc/liboraodbcS.so FileUsage = CPTimeout = CPReuse = [Oracle] Application Attributes = T Attributes = W BatchAutocommitMode = IfAllSuccessful CloseCursor = F DisableDPM = F DisableMTS = T Driver = Oracle EXECSchemaOpt = EXECSyntax = T Failover = T FailoverDelay = 10 FailoverRetryCount = 10 FetchBufferSize = 64000 ForceWCHAR = F Lobs = T Longs = T MetadataIdDefault = F QueryTimeout = T ResultSets = T ServerName = //127.0.0.1:49161/XE SQLGetData extensions = F Translation DLL = Translation Option = 0 User = system Uid = system UserID = system Password = oracle sudo odbcinst -i -d -f odbcinst.ini && odbcinst -i -s -f odbc.ini echo "SELECT * FROM lineitem LIMIT 100" | isql MySQL -d, > /dev/null