MySQL

MySQL connection helps you connect to a MySQL database and run queries directly from Infoveave.

Adding a MySQL Connection

To create a new MySQL connection:

1. Go to the Database section.
2. Select MySQL from the available connectors.
3. Fill in the required connection details in the New MySQL Connection form.

Connection Parameters

When setting up a MySQL connection, you need to provide the following details:

Field	Description
Name	A unique name to identify your connection.
Port	Port number for MySQL (default is 3306).
Server	The MySQL server endpoint.
Username	Your MySQL username.
Password	The corresponding password for the username.
Database	The MySQL database you want to connect to.
Schema	The schema inside the database to be used (optional).

Steps to Validate and Save

1. After filling in the details, click Validate to verify the connection.
2. If validation succeeds, click Save to store the connection.
3. You can now use MySQL as a datasource in your Infoveave workspace.

Example Use Case

With a MySQL connection configured, you can:

• Query and manage relational data stored in MySQL.
• Use MySQL SQL syntax for data analysis and reporting.
• Integrate MySQL data into Infoveave Infoboards for dashboards, reports, and insights.