WPS Engine for OLEDB

Data Engine Modules

Home 5 Products 5 Information 5 SAS language 5 Data engine modules 5 WPS Engine for OLEDB

OLEDB Database Connectivity

The WPS Engine for OLEDB module provides connectivity to any data source that has an OLEDB provider 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

Dependencies and Usage

This engine can only be used on the Windows platform.

The WPS Engine for OLEDB is supported in 32-bit and 64-bit mode. In either mode you will need an appropriate 32 or 64 bit OLEDB driver for the database you are connecting to.

Other data engine modules

WPS Engine for Actian Matrix

Library engine for accessing an Actian Matrix database

WPS Engine for DB Files

Library engine and procedures for accessing Access, Excel, SPSS and dBase files

WPS Engine for DB2

Library engine and procedures for accessing a DB2 database

WPS Engine for Greenplum

Library engine for accessing a Greenplum warehouse

WPS Engine for Hadoop

Library engine for accessing a Hadoop warehouse

WPS Engine for Informix

Library engine for accessing an Informix database

WPS Engine for Kognitio

Library engine for accessing a kognitio warehouse

WPS Engine for MySQL

Library engine for accessing a MySQL database

WPS Engine for MariaDB

Library engine for accessing a MariaDB database

WPS Engine for Netezza

Library engine for accessing a Netezza appliance

WPS Engine for ODBC

Library engine for accessing ODBC datasources