Valid server types in SQL statements
Server types indicate the kind of data source that the server definition represents.
Server types vary by vendor, purpose, and operating system. Supported values depend on the data source.
For most data sources,
you must specify a valid server type in the CREATE SERVER statement.
Data source | Server type |
---|---|
IBM® Db2® | DB2/LUW |
IBM Db2 for IBM i and AS/400 | DB2/ISERIES |
IBM Db2 for z/OS® | DB2/ZOS |
IBM Db2 for VM | DB2/VM |
Informix® | INFORMIX |
JDBC | JDBC (Required for JDBC data sources that are supported by JDBC drivers 3.0 and later.) |
Microsoft SQL Server | MSSQLSERVER (Required for data sources supported by the DataDirect Connect ODBC 4.2 (or later) driver or the Microsoft SQL Server ODBC 3.0 (or later) driver.) |
ODBC | ODBC (Required for ODBC data sources that are supported by the ODBC 3.x driver.) |
Oracle | ORACLE (Required for Oracle data sources supported by Oracle NET8 client software.) |
Sybase (CTLIB) | SYBASE |
Table-structured files | A server type is not required in the CREATE SERVER statement. |
Teradata | TERADATA |
For ODBC wrapper DSN-less connection, server type is
required in the CREATE SERVER statement
Data source | Server type |
---|---|
Microsoft AZURE SQL | AZURE |
database.com | DATABASE.COM |
force.com | FORCE.COM |
Pivotal Greenplum | GREENPLUM |
PivotalHAWQ | HAWQ |
Apache Hive™ data warehouse | HIVE |
Cloudera Impala | IMPALA |
Informix | INFORMIX_ODBC |
MongoDB | MONGODB |
Microsoft SQL Server | MSSQL_ODBC |
MySQL | MYSQL |
Netezza® | NETEZZA |
Progress OpenEdge | OPENEDGE |
Oracle Cloud | ORACLE_CLOUD |
Oracle | ORACLE_ODBC |
PostgreSQL | POSTGRESQL |
Amazon Redshift | REDSHIFT |
Saleforce | SALESFORCE |
Apache Spark SQL | SPARK_ODBC |
SAP Sybase IQ | SYBASEIQ |
Sybase ASE | SYBASE_ODBC |