MySQL data source
Learn how to set up a MySQL data source and then move its data to one of the data destinations supported by Coupler.io.
2 steps to complete the setup
1. Set up your data source
1.1 Select an application: MySQL
1.2. Define your MySQL server and credentials
Click "Connect".
Define your MySQL server and user credentials:
> Host - your host on which the MySQL server is running. The value can be a host name, IPv4 address, or IPv6 address.
> Port - specify the port. The default port number is 3306.
> User - user name of the MySQL account to use for connecting to the server.
> Password - corresponding password of the MySQL account used for connecting to the server.
- Click "Save.
1.3. Setup Basic Settings
- Enter Database name - the name of the MySQL database you want to export.
- Enter Table / View name - table or view you want to export.
Note: you’ll need to allowlist Coupler.io IP addresses if your organization only allows access from “selected networks”. Those IP addresses are:
- 34.123.243.115
- 34.170.96.92
2. Set up your data destination
Continue setting up the integration depending on the system you want to import data to. Select your tool from the list of supported data destinations and follow the relevant setup guide.
Note: data representation in the destination can be different depending on column data type:
- if the data has type bit (single bit) -> it is converted to boolean type
- If the data has one of the following types: blob, spatial data types, bytes, bit with size -> it is encoded to base64 string (so images, which can be stored in the database will be available, after base64 decode).