What do I need to whitelist for MySQL (& MariaDB) IP address access?

You must whitelist Kondado's IP addresses on your database server firewall to allow incoming connections. This typically involves adding specific IP ranges to your security group or firewall rules in your hosting provider's control panel. Contact your database administrator or DevOps team to configure these network permissions before initiating the connection setup.

Can I choose specific tables or schemas to replicate from MySQL (& MariaDB)?

Yes, Kondado uses dynamic mapping that lets you select exactly which tables, schemas, or views you want to replicate rather than syncing entire databases automatically. You can pick individual transactional tables, reference data, or custom views you have created in your database. This selective approach ensures you only move relevant data to your destination while keeping pipeline execution efficient.

Does the MySQL (& MariaDB) data source support incremental updates?

The replication process can be configured to detect and sync only new or changed records based on datetime or timestamp columns in your tables. By identifying recent modifications through MariaDB timestamp fields or auto-incrementing primary keys, the pipeline minimizes data transfer volumes and processing time. This approach keeps your destination current while reducing load on your production database.

Which destinations can I send MySQL (& MariaDB) data to?

You can replicate your database data to BigQuery , PostgreSQL , Power BI , Looker Studio , Google Sheets , as well as Redshift, SQL Server, Amazon S3, Excel, and MySQL. This flexibility allows you to choose between data warehouses for large-scale analytics, BI tools for visualization, or spreadsheets for quick ad-hoc analysis.

How do I combine MySQL (& MariaDB) data with other platforms in Kondado?

After creating your database pipeline, you can build additional pipelines from sources like Salesforce, Google Ads, or Shopify to send data into the same destination. Kondado enables cross-platform analysis by allowing you to join your MariaDB records with marketing, sales, or operational data in your data warehouse or BI tool. This unified approach reveals correlations between database transactions and external business activities.

What types of database objects can I replicate from MySQL (& MariaDB)?

Kondado supports replication of standard tables and database views you have created in your MySQL or MariaDB instance. You can select base tables containing raw transactional data or choose views that present pre-aggregated or filtered datasets. This flexibility accommodates various data architectures, whether you prefer replicating source tables directly or curated views optimized for reporting.

Can I track changes in MariaDB logs using this data source?

While the pipeline replicates table and view data rather than system files directly, you can replicate tables that store application logs or audit trails maintained within your database. Many organizations design their applications to write event data, user actions, or system events into database tables with MariaDB datetime columns for temporal tracking. These log tables can be replicated just like any other data, enabling analysis of system behavior and user activity patterns.

Send MySQL (& MariaDB) data to reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

MySQL (& MariaDB) Data Source for Analytics

Centralize transactional records, customer databases, inventory systems, and application logs from your MySQL (& MariaDB) environments into your preferred analytics destination. Organizations using these open-source relational databases can replicate operational data, financial records, and user activity tracking to build comprehensive business intelligence. Whether you are managing e-commerce platforms, SaaS applications, or internal business systems, your MariaDB datetime fields and transactional timestamps become actionable insights through automated data replication.

Kondado connects to MySQL (& MariaDB) through a direct connection using dynamic mapping. Users provide their Host/Address, Port, Database name, Username, and Password to establish the connection, which requires IP whitelisting on the database server. Once connected, you select which specific tables, schemas, or views to replicate to your destination on a configurable schedule ranging from every five minutes to daily.

Data engineers and business analysts benefit immediately by eliminating manual export tasks and maintaining current datasets for decision-making. Marketing teams can analyze customer journey data stored in MariaDB timestamp columns to optimize conversion funnels, while operations managers monitor inventory levels and supply chain metrics through automatically updated dashboards. Finance professionals consolidate accounting records across multiple database instances to generate accurate revenue reports without writing complex SQL queries.

The Kondado platform takes care of refreshing MySQL (& MariaDB) data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing MySQL (& MariaDB) data in your report, spreadsheet, data warehouse, data lake, or database

Setting up your replication pipeline requires just your database credentials and a few minutes of configuration to unlock powerful analytics capabilities. Once your MySQL (& MariaDB) data flows into business intelligence tools, you can build executive dashboards tracking daily active users, monitor database performance through MariaDB logs analysis, and visualize sales trends using datetime fields for temporal segmentation. Operations teams create KPI reports showing inventory turnover rates and order fulfillment metrics, while product managers analyze user engagement patterns and feature adoption rates from application databases.

Combine your relational database records with CRM data, advertising platforms, or web analytics to create unified customer views and attribution models that span your entire technology stack. Your reports and analyses stay current automatically through scheduled updates that refresh on your chosen timeline, ensuring stakeholders always access the latest business metrics.

Try out all the features for free for 14 days

Dynamic data

Kondado automatically reads the schema of your MySQL (& MariaDB). All tables, views, and fields available in your account are extracted without manual configuration.

available pipeline

What Kondado extracts

Tabelas e Views

Kondado automatically maps all tables and views available in your database

Integration	Description
Tabelas e Views	Kondado automatically maps all tables and views available in your database

See all available data →

Try out all the features for free for 14 days

How to visualize MySQL (& MariaDB) data in 3 steps

Connect MySQL (& MariaDB) to dashboards, spreadsheets, or databases — no code required.

Configure MySQL (& MariaDB) credentials

Enter your Host/Address, Port, Database name, Username, and Password in Kondado's connection form, ensuring your database server has whitelisted Kondado's IP addresses to establish the direct connection.

Select tables and destination

Choose which tables, schemas, or views to replicate through dynamic mapping, then select your destination such as BigQuery, Power BI, or Google Sheets to receive your data.

Build reports and analyze data

Create dashboards in Looker Studio or Power BI, analyze trends in Google Sheets or Excel, or query your replicated tables directly in PostgreSQL, Redshift, or SQL Server to derive business insights.

Try out all the features for free for 14 days