Search Knowledge Base by Keyword

Oracle MySQL

< Back

Overview

MySQL is the open-source relational database now owned by Oracle. In an enterprise estate it is rarely the system of record for finance or HR, and it is very often the back end of everything else: internal web applications, wikis and portals, open-source monitoring and ticketing platforms, and the embedded database inside network, storage and security appliances. When a team says “the data is in the app’s database”, on a Linux estate it is frequently a MySQL instance they mean.

The ReadyWorks connector connects directly to a MySQL server over the network using the mysql.php driver and a username and password. A job carries a SQL statement in its Data Selection field, ReadyWorks runs that statement, and the result set is written to the destination staging table with one column per selected column. There is no intermediate file and no export step.

This matters when the data you need has no API in front of it. An application that tracks licences, seat assignments or approvals in its own tables can be read directly, joined to device and identity data in the data fabric, and used to drive the same workflows as any API-sourced feed. Because the job runs arbitrary SQL, you can shape the extract at the source with joins and a WHERE clause instead of staging the whole table and filtering later.

The connector is inbound only. It reads query results and writes staging tables, and it issues no writes to the source database.

NOTE: Give ReadyWorks a dedicated database account with read access only to the tables it needs. The job runs whatever SQL the Data Selection field contains, under whatever privileges that account holds.

Connector Properties

Property Value
Identifier MYSQL
Name Oracle MySQL
Description Connector for accessing MySQL database tables.
Job Types Inbound Only
Order 210
Enabled Yes
Locked Yes
Block Update No
Single Authentication No
Windows Only No
Connector Version 2025-03-12
Hooks None
Additional Job Fields None
Image

Authentication Methods

One method ships: a direct network connection with a database username and password.

Method Identifier Base Method Script Order Enabled Config Fields
Username / Password MYSQL_user MYSQL_user mysql.php 10 Yes 5

NOTE: The connection form has no field for TLS, certificate verification or a CA bundle. Place the ReadyWorks server and the MySQL server on a network path you trust, or front the connection with a tunnel.

Method 1: Username / Password (MYSQL_user)

Connect to a MySQL Server

Username / Password connects to the MySQL server named in Source Server on the port given in Source Server Port (the default is 3306), authenticates with the supplied credentials, and selects the database named in Source DB Name. All five fields are required. The password is stored encrypted.

Connection Configuration Fields (5)

Order Label Type Required Default Max Len Tooltip
10 Source Server text Yes 255 Enter name of the source server
20 Source Server Port text Yes 3306 5 Enter port number of the source server
30 Source DB Name text Yes 255 Enter name of the source database
40 Username text Yes 1024 Enter username of the database account
50 Password password Yes 64000 Enter password of the database account

No authentication recipe is stored. The driver script authenticates natively using the fields above.

Inbound Job Fields Enabled (13)

These are the job-level settings exposed for a MySQL extract. Data Selection holds the SQL statement.

Order Label Type Required Default Tooltip
10 Job Description text Yes Enter description of the Job
20 Job Schedule lookup Yes Daily Select frequency Job should run
30 Enabled radio Yes Yes Choose if Job is enabled
60 Allow Empty Table radio Yes Yes Choose if an empty table is allowed
70 Destination Table text Yes Enter name of the destination table
80 Data Identity text No Enter identity of the Job
90 Data Selection textarea No Enter connector specific data selection command of the Job
120 Append New Data to Existing Tables radio No No Choose if new data will append to the existing destination table, or will create a new destination table
130 Fields to Index text No Enter fields to index
150 Request Unique Key Field text No Enter request unique field key of the Job
160 Request Sort By Field text No Enter field to sort by
290 Request Limit text No Enter request limit of the Job
560 Order text Yes Enter order of the Job

Inbound Job Templates (1)

One inbound template ships as a worked example. It arrives disabled and carries a placeholder query, so it is a pattern to copy rather than a job to enable.

# Job Description Destination Table API End Point Enabled What It Pulls
1 MySQL Table Data mysql_data Not set No A skeleton job carrying the statement SELECT * FROM {tablename} and writing to the mysql_data staging table. Replace the statement, the destination table and the data identity with your own.

Job Template Configuration

Settings

Setting Value
Order 10
Enabled No
Job Schedule Daily (15 1 * * *)
Destination Table mysql_data
Data Identity mysql_data
Allow Empty Table Yes
Append Files to Same Destination Table No
Append New Data to Existing Tables No
Use Unparsed Data No
Convert UUID-Keyed Objects to Rows No
Ignore XML Attributes No
Log Raw API Calls No
Method Type GET
Body Data Sending Method JSON Encoded Data

Job Parameters and Enumeration

MySQL Table Data

Data Selection: SELECT * FROM {tablename}

Outbound Job Templates (0)

This connector ships no outbound templates and does not support outbound jobs.

Tags: