World Programming Limited (WPL) develop and sell the World Programming System (WPS), an interpreter for the language of SAS. A great alternative - Request a free evaluation of WPS.
WPS
Engine ModuleWPS 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 |  |
| 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 pSeries (Power) * | |
| Linux on x86 * | |
| Mac OS X on x86 ** | |
| Solaris on SPARC * | |
| Solaris on x86 * | |
| Windows on x86 *** | |
| Linux on System z | |
| z/OS on System z |
*For use on the indicated UNIX 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 MAC OS X, 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.
