WPS Engine for ODBC
Data Engine Modules
ODBC Database Connectivity
The WPS Engine for ODBC module provides connectivity to any database that has an ODBC driver available to connect to it.
| Type of Access | Supported? |
|---|---|
| Reading |  |
| Writing | |
| Updating | |
| Creating New Tables | |
| Implicit Pass Through Support | |
| Explicit Pass Through Support |
|
| Bulk Loading Only for SQL Server | |
Dependencies and Usage
The WPS Engine for ODBC can only be used on the supported platforms indicated in the table below.
| Platform | Supported? |
|---|---|
| AIX on IBM Power* | |
| Linux on ARM* | |
| Linux on IBM Power LE (Little Endian)* | |
| Linux on x86* | |
| macOS on x86** |
|
| Windows on x86*** |
|
| z/OS on an architecture 7 machine |
* For use on AIX on IBM Power, Linux on ARM, Linux on IBM Power LE (Little Endian) and Linux on x86 platforms, you will also need to obtain a third party ODBC driver and manager appropriate to your particular database and UNIX platform.
** For use on macOS, the operating system is supplied with an ODBC administrator. However, you will also need to obtain a third party ODBC driver appropriate to your particular database.
*** For use on Windows, the operating system is supplied with an ODBC administrator. However, you will also need to obtain a third party ODBC driver appropriate to your particular database.
Other data engine modules
WPS Engine for Actian Matrix
Library engine for accessing an Actian Matrix database
WPS Engine for DB Files
Library engines and procedures for accessing Access, Excel, SPSS and dBase files
WPS Engine for DB2
Library engines and procedures for accessing a DB2 database
WPS Engine for Greenplum
Library engines for accessing a Greenplum warehouse
WPS Engine for Hadoop
Library engines for accessing a Hadoop warehouse
WPS Engine for Informix
Library engines for accessing an Informix database
WPS Engine for Kognitio
Library engines for accessing a kognitio warehouse
WPS Engine for MySQL
Library engines for accessing a MySQL database
WPS Engine for MariaDB
Library engines for accessing a MariaDB database
WPS Engine for Netezza
Library engines for accessing a Netezza appliance
WPS Engine for ODBC
Library engines for accessing ODBC datasources
WPS Engine for OLEDB
Library engines for accessing OLEDB datasources
WPS Engine for Oracle
Library engines for accessing an Oracle database
WPS Engine for PostgreSQL
Library engine for accessing an PostgreSQL database
WPS Engine for SAND
Library engines for accessing a SAND database
WPS Engine for SQL Server
Library engines for accessing a SQL Server database
WPS Engine for Sybase
Library engines for accessing a Sybase database
WPS Engine for Sybase IQ
Library engines for accessing a Sybase database
WPS Engine for Teradata
Library engines for accessing a Teradata warehouse
WPS Engine for Vertica
Library engines for accessing a Vertica database
WPS Engine for XLSX
Library engines for accessing Microsoft Excel spreadsheets
Have a question?
Try or buy
Standard Edition
Academic Edition
Community Edition