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 | |
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) * | |
| Linux on ARM * | |
| Linux on System p (POWER) * | |
| Linux on x86 * | |
| macOS on x86 ** | |
| Solaris on SPARC * | |
| Solaris on x86 * | |
| Windows on x86 *** | |
| Linux on Mainframe System z |  |
| z/OS on System z | |
* 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 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.
