Data connector for MySQL
The connector for MySQL enables you to directly import a MySQL dataset to InfoSum Platform.
Before starting, you will need the following information to hand:
- Database address, including a port number. If the port number is omitted then the default port for MySQL, 3306, will be used.
- Database name.
- Table name.
To configure a connection, login to the Platform if you haven't already and either create a dataset or access the bunker of an existing dataset. Once you're in the bunker, select Import a dataset or use the Import tab, and locate the MySQL connector as shown below.
Click Connect and enter the credentials.
Next, specify the database name and what will be imported - either by table name (e.g.
drone1) or with a custom SQL query.
A preview of the data will appear, then you can perform some minor manipulations as this point, such as selecting which columns to import, renaming columns and excluding row
When you're happy with the preview, accept the settings and select an import configuration, then you'll be taken to the Import Wizard. This will show how our Platform has understood your dataset and mapped columns into our Global Schema.
If this looks correct, accept the Wizard Settings, otherwise untick the boxes so they can be correctly mapped during the later normalisation phase.
Learn how to normalise the dataset into our Global Schema using data mappings and transformations.