MySQL

Creating MySql Connection

MySQL connection helps to connect a MySQL database for accessing and managing your relational data directly from Infoveave.

Adding a MySQL Connection

To create a new MySQL connection:

1. Go to Administration > Connections
2. Click New Connection and select MySQL from the available connectors
3. In the New MySQL Connection form, provide the required configuration details

Connection Parameters

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

Field	Description
Name	A unique name to identify your MySQL connection
Server	The MySQL Server host address or instance name
Port	The MySQL Server port (default: 3306)
Username	Your MySQL authentication username
Password	Your MySQL authentication password
Database	The specific database name to connect to
Schema	The database schema (optional)

Steps to Validate and Save

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

Example Use Cases

With a MySQL connection configured, you can:

• Query and analyze relational data directly from MySQL databases
• Create real-time dashboards with data from multiple MySQL tables
• Build automated workflows that trigger on database changes
• Perform complex data joins and transformations using SQL queries
• Schedule regular data extracts from MySQL for reporting and analytics
• Integrate MySQL data with other data sources in Infoveave
• Monitor database performance metrics and query optimization
• Set up data synchronization between MySQL and other systems
• Create advanced analytics using MySQL views and stored procedures
• Generate business intelligence reports from web application data
• Analyze e-commerce data stored in MySQL databases
• Process and visualize content management system data