WPS Engine for ODBC

Data Engine Modules

WPS Engine for ODBC

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 Yes
Writing Yes
Updating Yes
Creating New Tables Yes
Implicit Pass Through Support Yes
Explicit Pass Through Support Yes
Bulk Loading Only For SQL Server Yes

The WPS engine for ODBC connects to any database that has an ODBC driver available to connect to it using the ODBC API.

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 System p (POWER) * Yes
Linux on ARM * Yes
Linux on System p (POWER) * Yes
Linux on x86 * Yes
macOS on x86 ** Yes
Solaris on SPARC * Yes
Solaris on x86 * Yes
Windows on x86 *** Yes
Linux on Mainframe System zNo
z/OS on System zNo
* For use on AIX on System p (POWER), Linux on ARM, Linux on System p (POWER), Linux on x86, Solaris on x86 and Solaris on SPARC 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 need to also 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 need to also obtain a third party ODBC driver appropriate to your particular database.

Other data engine modules