This quickstart describes how to create a MySQL connection.

Create a connection to MySQL

To ingest data from MySQL using Upsolver, you must first create a connection that provides the appropriate credentials to access your database.

Your connection is persistent, so you won't need to re-create it for every job. The connection is also shared with other users in your organization.

Here’s the code for creating a connection to MySQL:

// Syntax
CREATE MYSQL CONNECTION <connection_identifier> 
    CONNECTION_STRING = '<connection_string>' 
    USER_NAME = '<user_name>'
    PASSWORD = '<password>'; 

// Example
    CONNECTION_STRING = 'jdbc:mysql://'
    USER_NAME = 'your_username'
    PASSWORD = 'your_password';

After you complete this step, you should see the my_mysql_connection connection in your navigation tree.

Learn more

Please see the SQL command reference for MySQL for the full list of connection options, and examples.

Last updated