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
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.

* 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?

Get in touch with our sales team

Try or buy

Standard Edition
Academic Edition
Community Edition