World Programming Limited 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
ModulesWPS Engine for ODBC
ODBC Database Connectivity
The WPS Engine for ODBC integrated 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 but 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 and driver. However your particular database may require/advise you to also obtain an appropriate third party ODBC driver.
