The MySQL Adapter enables you to create an integration in Oracle Integration Cloud Service.
The MySQL Database is an open-source relational database management system (RDBMS). The MySQL Database uses the Structured Query Language (SQL). SQL enables you to add, access, and manage content in the MySQL Database. The MySQL Database is a key part of many open source Hypertext Preprocessor (PHP) applications.
The MySQL Adapter provides the following benefits:
Support for integrations between Oracle Integration Cloud Service and an on-premises MySQL Database. The MySQL Adapter runs in an on-premises environment to achieve this integration.
Outbound (invoke) integration support for the following:
Execution of stored procedures based on database schemas. When you select a stored procedure in the Adapter Endpoint Configuration Wizard, the respective IN, OUT, and IN/OUT parameters are displayed.
Execution of SQL statements:
Enables you to directly enter SQL statements.
Supports data manipulation language (DML) create, read, update, and delete (CRUD) statements.
Supports validation of SQL queries.
Supports bind variables (for example, Employee_ID = #D).
For more information about integrating on-premises applications with Oracle Integration Cloud Service, see Using Oracle Integration Cloud Service.
The MySQL Adapter is one of many predefined adapters included with Oracle Integration Cloud Service. You can configure the MySQL Adapter as an invoke connection in an integration in Oracle Integration Cloud Service. For information about Oracle Integration Cloud Service, connections, and integrations, see the following sections: