Connecting to MySQL

MySQL is a popular open source relational database management system. Use Analytics's data connector to import your organization's MySQL data.

Before you start

To connect to MySQL, you must gather the following:

• the database server's host name
• the correct connection port
• your username and password if using standard authentication
• read access for the schema and tables you want to connect to

For help gathering the connection prerequisites, contact the MySQL administrator in your organization. If your administrator cannot help you, you or your administrator should contact MySQL Support.

Create a MySQL connection

1. From the Analytics main menu, select Import > Database and application.
2. From the New Connections tab, in the ACL Connectors section, select MySQL.

   Tip

   You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

3. In the Data Connection Settings panel, enter the connection settings and at the bottom of the panel, click Save and Connect.

   You can accept the default Connection Name, or enter a new one.

The connection for MySQL is saved to the Existing Connections tab. In the future, you can reconnect to MySQL from the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from MySQL, see Import data using the Data Access window .