How does the Tiny ERP to MySQL replication process work?

Kondado connects directly to your Tiny ERP account and extracts data from your selected pipelines on a configurable schedule. The platform automatically structures this information into your MySQL database, maintaining data relationships and field mappings without requiring any manual intervention or coding knowledge.

What specific Tiny ERP data can I replicate to MySQL?

You can access comprehensive business information including CRM Issues for customer service tracking, Accounts Payable and Receivable for financial management, Order Details for sales analysis, and Product Inventory for stock control. Each pipeline contains specific fields like cliente_nome, data_emissao, and valor_total that map directly to your MySQL schema, preserving the relationships between your ecommerce, financial, and operational records.

How often does Tiny ERP data update in MySQL?

You configure the update frequency based on your business needs, selecting intervals ranging from near-real-time updates to longer batch periods. This flexibility ensures your MySQL database reflects your ERP operations at the pace your analytics require without overwhelming your system resources.

Can I combine Tiny ERP data with other sources in MySQL?

Yes, you can replicate data from additional sources into the same MySQL database where your Tiny ERP pipelines land, enabling you to join ecommerce transactions with marketing analytics or logistics information. This cross-source analysis helps you calculate true customer acquisition costs and lifetime value by connecting order history with campaign performance data stored in your database.

Are there ready-made dashboards available for Tiny ERP data?

Yes, Kondado offers pre-built report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report that connect directly to your replicated data. These templates provide immediate visualizations of your sales performance, inventory levels, and financial health without requiring you to build charts from scratch.

What format does Tiny ERP data take in MySQL?

The data arrives as structured relational tables with preserved field names from your ERP system, such as assunto_id and data_vencimento, maintaining proper data types for dates, currency, and text. This standardized format allows you to immediately run SQL queries, create views, and build stored procedures using familiar database syntax.

Do I need technical skills to set up Tiny ERP replication to MySQL?

No coding is required to establish the connection, as Kondado provides a no-code interface for selecting your pipelines and configuring the destination. While basic SQL knowledge helps you analyze the data once it arrives in MySQL, the replication process itself is fully automated through the platform's visual setup wizard.

Send data from Tiny ERP to MySQL

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

Send Tiny ERP Data to MySQL Automatically

Sending Tiny ERP data to MySQL requires no coding when you use Kondado’s automated platform. Simply connect your Tiny ERP account as a data source, configure MySQL as your destination, and select which pipelines you want to replicate from the available options. The system handles the data transfer on your chosen schedule, whether every five minutes or daily, ensuring your database stays current with your ERP operations. You can consolidate sales transactions, customer information, and inventory data into a single analytical environment for comprehensive business intelligence and operational insights.

Kondado provides direct integration between Tiny ERP and MySQL, offering 15 pipelines with 792 fields including CRM Issues, Accounts Payable, and Order Details. The platform replicates your business data automatically on a configurable schedule, enabling you to analyze ecommerce operations, financial records, and inventory levels directly in your MySQL database without manual exports.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Available Tiny ERP Data in MySQL

Once your Tiny ERP data lands in MySQL, you can run complex SQL queries across the CRM Issues and Accounts Payable pipelines to identify bottlenecks in customer service workflows and optimize cash flow management. The Order Details and Product Inventory pipelines enable you to build automated stock alerts and analyze sales performance by channel, giving you complete visibility into your ecommerce operations without switching between systems. By joining these datasets with other business information already in your database, you create unified dashboards that track everything from lead conversion to fulfillment efficiency while maintaining full control over your analytical infrastructure.

Try out all the features for free for 14 days

Tiny ERP data available for MySQL

available pipelines

792

extractable fields

Available integrations

Integration	Description
CRM Issues	Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.
CRM Issues Details	Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.
Accounts Payable	Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.
Accounts Receivable	Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.
Contacts	Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.
Accounts Payable Details	Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.
Accounts Receivable Details	Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.
Invoice Details	Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.
Invoice Details: XML	Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.
Order Details	Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.
Product Inventory	Table provides information about inventory, including fields such as id, product name, and available quantity.
Invoices	Table contains details of invoices, featuring fields such as id, issue date, and customer name.
Orders	Table lists the orders placed, including fields such as order id, order date, and status.
Products	Table presents information about products, with fields such as id, name, and price.
Product Grid	Table provides a detailed grid of products, including fields such as id, description, and category.

CRM Issues

Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.

CRM Issues Details

Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.

Accounts Payable

Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.

Accounts Receivable

Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.

Contacts

Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.

Accounts Payable Details

Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.

Accounts Receivable Details

Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.

Invoice Details

Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.

Invoice Details: XML

Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.

Order Details

Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.

Product Inventory

Table provides information about inventory, including fields such as id, product name, and available quantity.

Invoices

Table contains details of invoices, featuring fields such as id, issue date, and customer name.

Orders

Table lists the orders placed, including fields such as order id, order date, and status.

Products

Table presents information about products, with fields such as id, name, and price.

Product Grid

Table provides a detailed grid of products, including fields such as id, description, and category.

See all available data →

Try out all the features for free for 14 days

How to send Tiny ERP data to MySQL

Sync data automatically — no code, no manual exports.

Connect Tiny ERP Account

Access the data sources section in Kondado and authenticate your Tiny ERP credentials to establish the initial connection. The platform will automatically detect available pipelines from your ERP instance.

Configure MySQL Destination

Enter your MySQL connection details including host, port, and database credentials to designate where your Tiny ERP data should land. Test the connection to ensure Kondado can write to your database schema before proceeding to pipeline selection.

Select Pipelines and Schedule

Choose from the 15 available pipelines such as Orders, Products, and CRM Issues, then set your preferred replication frequency. You can opt for near-real-time updates every five minutes or select longer intervals depending on your analytical requirements.

Try out all the features for free for 14 days