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 |
|---|---|---|
| Amazon Redshift | REDSHIFT | ODBC options |
| Apache Hive | HIVE | ODBC options |
| Apache Spark | SPARK | JDBC options |
| Apache Spark SQL | SPARK_ODBC | ODBC options |
| Cloudera Impala | IMPALA | ODBC options |
| database.com | DATABASE.COM | ODBC options |
| force.com | FORCE.COM | ODBC options |
| IBM® BigInsights® | BIGSQL | IBM database options |
| IBM Db2® Warehouse on Cloud | DASHDB | IBM database options |
| IBM Db2 as a Service | 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 |
| Informix® (with INFORMIX wrapper) | INFORMIX | INFORMIX |
| Informix (with ODBC wrapper) | INFORMIX_ODBC | ODBC options |
| JDBC | JDBC | JDBC options |
| Microsoft Azure | AZURE | ODBC options |
| Microsoft SQL Server (with MSSQLODBC3 wrapper) | MSSQLSERVER | Microsoft SQL Server options |
| Microsoft SQL Server (with ODBC wrapper) | MSSQL_ODBC | ODBC options |
| ODBC | ODBC | ODBC options |
| Oracle (with NET8 wrapper) | ORACLE | Oracle options |
| Oracle (with ODBC wrapper) | ORACLE_ODBC | ODBC options |
| Oracle Cloud | ORACLE_CLOUD | ODBC options |
| Oracle MySQL | MYSQL | ODBC options |
| Pivotal Greenplum | GREENPLUM | ODBC options |
| Pivotal HAWQ | HAWQ | ODBC options |
| PostgreSQL | POSTGRESQL | ODBC options |
| Progress OpenEdge | OPENEDGE | ODBC options |
| Salesforce | SALESFORCE | ODBC options |
| SAP Sybase | SYBASE | Sybase options |
| SAP Sybase IQ | SYBASEIQ | ODBC options |
| SAP Sybase ASE | SYBASE_ODBC | ODBC |
| Teradata (with TERADATA wrapper) | TERADATA | Teradata options |
| Teradata (with ODBC wrapper) | TERADATA_ODBC | ODBC options |