WPS Engine for MySQL

Data Engine Modules

WPS Engine for MySQL

MySQL Database Connectivity

The WPS Engine for MySQL module provides connectivity to version 5 (and upwards) of the MySQL database.

Type of Access Supported?
Reading Yes
Writing Yes
Updating Yes
Creating New Tables Yes
Implicit Pass Through Support Yes
Explicit Pass Through Support Yes
Bulk Loading Yes

The WPS engine for MySQL connects to a MySQL database using the Connector/C API.

Dependencies and Usage

You can only do update and delete processing on MySQL tables that have a primary key defined.

The WPS Engine for MySQL can only be used on the supported platforms indicated in the table below.

Platform Supported?
AIX on System p (POWER)Yes
Linux on ARMYes
Linux on System p (POWER)Yes
Linux on x86Yes
macOS on x86Yes
Solaris on SPARCYes
Solaris on x86Yes
Windows on x86Yes
Linux on Mainframe System zYes
z/OS on System zNo

Other data engine modules