From Olist Tiny to MySQL: managed, scheduled, no code.
Kondado automatically replicates Olist Tiny CRM Issues, Accounts Payable, Accounts Receivable, Orders, Invoices, Products, and 8 additional pipelines directly into your MySQL database on a configurable schedule ranging from every 5 minutes to daily, creating a centralized repository for analytics and reporting.
Kondado provides a direct integration between Olist Tiny and MySQL, allowing you to replicate your ERP data automatically without writing complex extraction scripts. Simply connect your Olist Tiny account as a data source, configure MySQL as your destination, and select which pipelines you want to replicate from the available 15 options. The platform handles all data extraction and loading on a configurable schedule, ensuring your database stays current with your latest ecommerce transactions, financial records, and operational data while eliminating manual CSV exports and data entry tasks.
Once your data arrives in MySQL, you can run complex SQL queries, build custom dashboards, or combine Olist Tiny information with other business systems to generate comprehensive insights about your retail operations, inventory turnover, and financial performance across multiple channels.
With the CRM Issues and CRM Issues Details pipelines in your MySQL database, support teams can analyze ticket resolution times and customer satisfaction trends using SQL queries to identify bottlenecks in service delivery. Finance teams benefit from the Accounts Payable and Accounts Receivable pipelines, enabling cash flow forecasting by joining payment data with historical trends directly within MySQL. Additionally, the Order Details and Product Stock pipelines allow inventory managers to build automated alerts when stock levels drop below thresholds, ensuring your online store never misses a sales opportunity due to unavailable products.
Try out all the features for free for 14 days
Replicated to MySQL
Olist Tiny 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 in the CRM.
CRM Issues Details
Presents detailed information such as cliente_codigo, cliente_nome, and cliente_cidade, providing a comprehensive view of issues and their respective clients.
Accounts Payable
Contains data such as id, data_emissao, and valor, allowing effective management of accounts payable and their respective statuses.
Accounts Receivable
Includes information on receivables such as id, data_emissao, and saldo, facilitating the tracking of revenues to be received.
Contacts
Presents data such as cliente_id_cliente, cliente_nome, and cliente_email, allowing effective management of contacts and their information.
Accounts Payable Details
Includes fields such as id, data_vencimento, and historico, providing a detailed view of accounts payable and their conditions.
Accounts Receivable Details
Presents information such as id, data_vencimento, and saldo, allowing detailed control of accounts receivable.
Invoice Details
Includes fields such as id, numero_doc, and data_emissao, providing a detailed view of issued invoices.
Invoice Details: XML
Presents information in XML format, including fields such as id and xml_data, allowing technical analysis of invoices.
Order Details
Includes fields such as id, data_pedido, and valor_total, providing a comprehensive view of orders placed.
Product Stock
Contains information about the available quantity of products, including fields such as id, product name, and stock balance.
Invoices
Records details of issued invoices, including fields such as id, issue date, and customer name.
Orders
Includes information about placed orders, with fields such as id, order date, and order status.
Products
Presents data about registered products, including id, name, and selling price.
Products: grid
Provides a grid view of products, with fields such as id, name, and category.
Sync data automatically — no code, no manual exports.
1
Connect Olist Tiny Account
Authenticate your Olist Tiny ERP system by entering your API credentials in Kondado's data source configuration panel to establish the initial connection.
2
Configure MySQL Destination
Enter your MySQL database host, port, username, and password in the destination settings to create the target location where your Olist Tiny pipelines will be stored.
3
Select Pipelines and Schedule
Choose which of the 15 available Olist Tiny pipelines you want to replicate and set your preferred update frequency, ranging from every 5 minutes to daily, to automate the data flow.
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 Olist Tiny data to MySQL automatically
How does the Olist Tiny to MySQL replication process work technically?▼
Kondado connects directly to your Olist Tiny account using your API credentials to extract data from selected pipelines. The platform then automatically loads this information into your MySQL database on your chosen schedule, maintaining data consistency without requiring manual exports or file transfers.
What specific Olist Tiny data can I replicate to MySQL?▼
You can replicate 15 different pipelines including CRM Issues, Accounts Payable, Accounts Receivable, Orders, Invoices, Products, and Contacts. Each pipeline contains specific fields such as issue tracking details, payment histories, order information, and inventory levels, totaling 792 available fields for analysis.
How frequently does Olist Tiny data update in MySQL?▼
Kondado updates your MySQL data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This ensures your database reflects recent Olist Tiny activity according to your business needs without overwhelming your systems with constant requests.
Can I combine Olist Tiny data with other business sources in the same MySQL database?▼
Yes, you can combine Olist Tiny data with information from over 80 other data sources available on Kondado within the same MySQL instance. This allows you to create unified views of your business by joining ERP data with marketing platforms, payment processors, or other operational tools.
What format does Olist Tiny data take once it reaches MySQL?▼
Olist Tiny data arrives in MySQL as structured relational tables with preserved data types, where each pipeline becomes a separate table. Fields such as data_emissao, valor_total, and cliente_nome maintain their original formats, enabling immediate SQL analysis and reporting.
Are there pre-built dashboards available for Olist Tiny data?▼
Yes, Kondado offers pre-built report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report. These ready-made dashboards connect directly to your data, providing immediate visualizations of your sales, inventory, and financial metrics without requiring you to build charts from scratch.
Can I send Olist Tiny data to destinations other than MySQL?▼
Absolutely, you can send Olist Tiny data to multiple destinations simultaneously. In addition to MySQL, you can replicate the same pipelines to BigQuery, PostgreSQL, Google Sheets, or Power BI for different analytical needs across your organization.
Do I need programming skills to set up the Olist Tiny MySQL connection?▼
No coding is required to establish the connection between Olist Tiny and MySQL. The platform provides a no-code interface where you authenticate your Olist Tiny account, enter your MySQL connection details, and select pipelines through a visual menu.
'%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)
