From Tiny ERP to MySQL: managed, scheduled, no code.
Creating a pipeline that sends data from Tiny ERP to MySQL databases takes only a few minutes with Kondado. And the whole integration from Tiny ERP to MySQL is managed and executed by our platform. With Kondado, you can focus on extracting value from Tiny ERP data and combining it with other data in your MySQL database
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.
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
Replicated to MySQL
Tiny ERP data available for MySQL
Tables Kondado writes into your MySQL, on a schedule you control.
15
available pipelines
792
extractable fields
MySQL
Destination
Available integrations
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.
Sync data automatically — no code, no manual exports.
1
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.
2
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.
3
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
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Tiny ERP data to MySQL automatically
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.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
