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.
Table 1. Supported data sources and valid server types of native
wrappers
| Data source |
Server type |
| IBM® Big SQL |
BIGSQL |
| IBM
Db2® |
DB2®/LUW, DB2/CS, DB2/UDB, DB2/SUN,
DB2/AIX, DB2/PE, DB2/LINUX, DB2/EEE, DB2/2, dashDB, PDOA, PDTX |
| IBM
Db2 for IBM i |
DB2/ISERIES, DB2/400 |
| IBM
Db2 for z/OS® |
DB2/ZOS, DB2/MVS, DB2/390 |
| IBM
Db2 for
VM |
DB2/VM, DB2/VSE, SQL/DS |
| Informix® |
INFORMIX |
| Microsoft SQL Server |
MSSQLSERVER |
| Oracle |
ORACLE |
| Sybase |
SYBASE |
| Teradata |
TERADATA |
Table 2. Supported data sources and valid server types of ODBC wrapper
| Data source |
Server type |
| Microsoft AZURE SQL |
AZURE |
| Pivotal Greenplum |
GREENPLUM |
| SAP HANA |
HANA |
| Apache Hive™ data warehouse |
HIVE |
| Cloudera Impala |
IMPALA |
| Microsoft SQL Server |
MSSQL_ODBC |
| MySQL Enterprise Edition |
MYSQL |
| MySQL Community Edition |
MYSQL_CE |
| Netezza® |
NETEZZA |
| Oracle |
ORACLE_ODBC |
| PostgreSQL |
POSTGRESQL |
| Saleforce |
SALESFORCE |
| Apache Spark SQL |
SPARK_ODBC |
| Other ODBC data sources |
ODBC |
Table 3. Supported data sources and valid server types of NoSQL
wrapper
| Data source |
Server type |
| CouchDB |
COUCHDB |
| MongoDB |
MONGODBREST, MONGODRIVER, RESTHEART |
| Parquet on Hadoop |
HDFSPARQUET |
Table 4. Supported data sources and valid server types of JDBC
wrapper
| Data source |
Server type |
| Derby |
QPLEX |
| MySQL Community Edition |
MYSQL_CE |
| Other JDBC data sources |
JDBC |