There are three methods to specify this clause in the configuration. ĭriver=/scratch/aime1/work/mw3108/bi/modules/oracle.bi.datadirect.odbc/7.1.6/ARimpala27.soĭescription=Oracle 7.1 Cloudera Impala Wire Protocol The following example shows the Driver parameter set to the DataDirect Connect driver, and the Impala_DB data source name. The HostName parameter uses the fully qualified host name, or the IP address as the HostName parameter and the PortNumber parameter. The Driver parameter is set to the file path of the DataDirect Connect driver for Cloudera Impala. The ODBC connection name is identical to the data source name specified in the connection pool defined in the repository. You can use the fully qualified host name or the IP address as the HostName parameter, and the PortNumber parameter. The following example shows the Driver parameter set to the DataDirect connect driver, and SybaseASE_DB as the data source name.ĭriver=/scratch/aime1/work/mw3108/bi/modules/oracle.bi.datadirect.odbc/7.1.6ĭescription=DataDirect 7.1 Sybase Wire Protocol For the NetworkAddress provide the IP address or fully qualified host name and the port number. Set the Driver parameter to the file name and location of the DataDirect Connect driver for Sybase ASE Database. LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order to use the DataDirect Connect for ODBC for MySQL Enterprise driver with MySQL software. ĭriver=/refresh/home/oracle/middleware/oracle_home/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/ARmysql27.soĭescription=Oracle 7.1 MySQL Wire Protocol In the following example, the Driver parameter is set to the DataDirect Connect driver, and the data source name is MySQL_DB. For the NetworkAddress use the IP address or fully qualified host name and the port number. Set the Driver parameter to the file name and location of the DataDirect Connect driver for MySQL Database. #Location applies to z/OS and iSeries only #Collection applies to z/OS and iSeries only

In the following example, the Driver parameter is set to the DataDirect Connect driver, and the data source name is ABCDEF. Set the Driver parameter to the file name and location of the DataDirect Connect driver for DB2 Database. Use the same ODBC connection name to the data source name specified in the connection pool defined in the repository.

Datadirect odbc