Data source options
Which options you can specify when creating or altering a wrapper, server, user mapping, or nickname depends on the type of the data source.
| Data source | Type | Options |
|---|---|---|
| Apache Hive | HIVE | ODBC options |
| Cloudera Impala | IMPALA | ODBC options |
| IBM® BigInsights® | BIGSQL | IBM database options |
| IBM Db2® Warehouse on Cloud | DASHDB | IBM database options |
| IBM Db2 on Cloud | DASHDB | IBM database options |
| IBM Db2 Warehouse | DASHDB | IBM database options |
| IBM Db2 | DB2/LUW | IBM database options |
| IBM Db2 for z/OS® | DB2/ZOS | IBM database options |
| IBM Db2 for IBM i | DB2/ISERIES | IBM database options |
| IBM Db2 Server for VSE and VM | DB2/VM | IBM database options |
| IBM Db2 Hosted | DB2/LUW | IBM database options |
| IBM PureData® System for Analytics (formerly Netezza®) | PDA | ODBC options |
| IBM PureData System for Operational Analytics | PDOA | IBM database options |
| IBM PureData System for Transactions | PDTX | IBM database options |
| JDBC | JDBC | JDBC options |
| Microsoft SQL Server (with ODBC wrapper) | MSSQL_ODBC | ODBC options |
| ODBC | ODBC | ODBC options |
| Oracle (with ODBC wrapper) | ORACLE_ODBC | ODBC options |
| Oracle Cloud | ORACLE_CLOUD | ODBC options |