Connector
MySQL Connector
Read and write MySQL tables without writing code, on a Windows or Linux server, through your own network or straight over the internet.
Rapidi connects to MySQL through RapidiConnector, a small Windows service with the MySQL ODBC driver installed, or straight from the central Rapidi service when your server is reachable from the internet. It reads and writes the tables of the database you name. MySQL Server 4.0, 5.0, 5.1 and later are supported, on Windows or Linux.
- What it connects to
- MySQL Server 4.0, 5.0, 5.1 and later, running on Windows or Linux.
- Which way the data moves
- Both ways. Most data types are read and written. Bigint is read only, and Blob types are not supported.
- What you need
- A MySQL user granted access, and either RapidiConnector with the MySQL ODBC driver, or a server Rapidi can reach over the internet.
What does this connector actually do?
The short version: Rapidi signs in to MySQL with a user you grant access to, reads the layout of the database you name, and moves rows in and out of its tables on the schedule you set.
| Records it moves | Rows in the tables of the database you name on the connection. Read Design loads the tables and fields so you can map them. |
|---|---|
| Direction | Both ways. Every supported data type is read and written, except Bigint, which is read only. |
| Data types | Tinyint, smallint, mediumint, int and their unsigned forms, bigint (read only), float, double, decimal, char, varchar, tinytext, text, mediumtext, longtext, date, datetime, timestamp, time, year, enum and set. Blob types are not supported. |
| Versions supported | MySQL Server 4.0, and MySQL Server 5.0 and 5.1 or later. |
| Where it can run | MySQL on Windows or Linux. RapidiConnector itself runs on a Windows computer. |
| How it signs in | A MySQL user ID and password, with access granted to that user in MySQL. |
| How often it runs | On a schedule you set. The shortest interval depends on your plan, from one hour on Entry down to one minute on Unlimited. |
| What you set up once | Install the MySQL ODBC driver next to RapidiConnector, or remove RapidiConnector for a server on the internet. Enter the server, port and database in MyRapidi, then press Test and Read Design. |
How does Rapidi reach your MySQL server?
There are two routes, and the choice depends on where your MySQL server sits. Nothing is installed inside MySQL itself in either case.
| What you are comparing | Through RapidiConnector | Straight over the internet |
|---|---|---|
| When it fits | MySQL sits inside your own network | MySQL is reachable from the internet |
| Installed on your side | RapidiConnector on a Windows computer, plus MyODBC 3.51.x or Connector/ODBC 5.1 on the same machine | Nothing. You remove RapidiConnector from the connection with the trashcan icon in MyRapidi |
| Who connects to MySQL | RapidiConnector, from inside your network | The central Rapidi service, over the internet |
| Ports opened to the internet | None. RapidiConnector calls out to the Rapidi service and keeps that connection open | MySQL has to be reachable from the internet, on port 3306 unless you have changed it |
On the RapidiConnector route, grant the Rapidi user access in MySQL from the IP address of the RapidiConnector computer. Set the tables up as InnoDB or BDB, so transactions are enabled. If the server does not use the default port 3306, enter its port on the connection.
Rapidi picks the MySQL ODBC driver it finds automatically. To use a specific driver, or to add connection parameters such as SSL certificate and key files, enter them in the Server Connect field.
Where does MySQL show up in a Rapidi integration?
MySQL is usually one end of a transfer, with an ERP, a CRM or another database at the other end.
Platform
The Rapidi iPaaS
How Rapidi joins business applications and databases, in the cloud and on premises, on one service.
Platform
Use case
Data Migration
Moving records from one system to another with the relationships between them intact.
Use case
Connector
Oracle Database
Another database connector in this category, reached through RapidiConnector and the Oracle Client.
Database connector
Where do you go next?
Connectors
Every system Rapidi connects to
The full list, A to Z, with versions and how each one connects.
All connectors
Connector
Microsoft SQL Server
The SQL Server connector, reached through RapidiConnector and the SQL Server client.
Database connector
Pricing
What Rapidi costs
Four plans, priced per subscription rather than per connector. Adding MySQL does not change the licence.
Plans
Your setup
Ask about your own database
Tell us which MySQL version you run and what it has to connect to, and we will say plainly how Rapidi covers it.
Talk to a consultant
Frequently asked questions
Can Rapidi connect to MySQL?
Yes. MySQL has its own connection type in MyRapidi. You name the server and the database, test the connection and read the design, and the transfers are then configured on screen rather than written as code.
Which MySQL versions are supported?
MySQL Server 4.0, and MySQL Server 5.0 and 5.1 or later, on Windows or Linux. If you run a specific newer release, tell us which one and we will confirm it.
Can Rapidi write into MySQL, or only read from it?
Both. Every supported data type is read and written, except Bigint, which is read only. Blob types are not supported.
Does anything have to be installed on our side?
Only if MySQL sits inside your network. Then RapidiConnector goes on a Windows computer that can see the server, with the MySQL ODBC driver next to it. If MySQL is reachable from the internet, you remove RapidiConnector and the central Rapidi service connects directly.
Which ODBC driver does Rapidi need?
MyODBC 3.51.x or Connector/ODBC 5.1, installed on the computer where RapidiConnector runs. Rapidi uses the first MySQL ODBC driver it finds, unless you name one in the Server Connect field.
What access does the MySQL user need?
On the RapidiConnector route, the user Rapidi signs in with needs access granted from the IP address of the RapidiConnector computer. The tables should be InnoDB or BDB, so transactions are enabled.
Can the connection to MySQL use SSL?
Yes, through the driver. You add the SSL parameters, such as the certificate and key files, after the driver name in the Server Connect field.
What does the MySQL connector cost?
Nothing on its own. Rapidi is priced per subscription plan rather than per connector, so adding MySQL does not change the licence.
Is MySQL one of your systems?
Tell us where your MySQL server runs and what it has to connect to, and we will tell you plainly which route fits and what the setup involves.