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 IBM PowerYes
Linux on ARMYes
Linux on IBM Power LE (Little Endian)Yes
Linux on x86Yes
macOS on x86Yes
Windows on x86Yes
z/OS on an architecture 7 machineNo

Other data engine modules