What is the Infoveave MySQL connector?

The MySQL connector connects Infoveave to MySQL databases so you can query tables, automate reporting, and optionally write transformed data back.

Can I use custom SQL?

Yes. Configure the connector, retrieve tables or custom queries, and feed results into Infoboards and workflows.

Can Infoveave update MySQL?

Yes. Processed or transformed data can be synchronized back into MySQL operational systems.

How is MySQL different from MariaDB here?

They are separate database connectors. Use the one that matches the engine you run.

Can refreshes be scheduled?

Yes. Scheduled refreshes support near-real-time decision-making on relational data.

Where is setup documented?

Help: MySQL database connection plus introducing datasources / toolbar.

Databases

MySQL

Go to connector docs Start Free Trial

About MySQL

MySQL is a widely adopted open-source relational database that powers numerous applications, ranging from enterprise platforms to web applications. It offers reliability, scalability, and flexibility in data management. Infoveave integrates seamlessly with MySQL, enabling you to analyze, automate, and synchronize structured data across business functions with ease.

Using MySQL in Infoveave

In a well-structured relational database, data is organised into tables with defined relationships, primary keys, and foreign keys — ensuring every record is uniquely identifiable and every relationship between entities is enforced at the database level. MySQL is built on exactly these principles, making it one of the most reliable foundations for business analytics. Infoveave's MySQL connector enables you to connect directly to your relational data stored in MySQL. You can query structured data, create dashboards, and run automated workflows without complex data pipelines. With seamless query execution and secure authentication, Infoveave ensures MySQL serves as a trusted, governed data source for analytics and reporting.

Data ingestion from MySQL into Infoveave is straightforward and efficient. By configuring the MySQL connector, you can establish connections to your databases, retrieve tables or custom queries, and feed the data into Infoveave. This process supports real-time or scheduled refreshes, ensuring that the data in Infoveave always reflects the latest information in your MySQL environment. In addition, users can join MySQL datasets with other sources for unified reporting.

Infoveave also supports synchronizing processed or transformed data back into MySQL databases. This allows you to not only analyze and automate workflows using Infoveave but also update operational systems with refined data. Synchronization ensures business processes remain aligned with analytics outputs, creating a closed-loop system where insights directly improve database operations. This bi-directional integration makes MySQL a central component of an intelligent, automated data ecosystem.

Create interactive dashboards from MySQL relational data.
Automate reporting workflows by querying MySQL databases.
Combine MySQL data with cloud applications for unified analysis.
Enable real-time decision-making with scheduled data refreshes.
Synchronize transformed datasets back into MySQL for operational use.
Support advanced analytics by integrating MySQL with machine learning models.

How to connect MySQL

Authenticate. Create a secure MySQL database connection in Infoveave.
Query datasets. Retrieve tables or custom queries from the MySQL instance.
Refresh. Schedule extracts so Infoboards stay current without manual dumps.
Analyze or write back. Synchronize transformed datasets back into MySQL for operations.