Kondado enables you to replicate data from Olist Tiny directly into Looker Studio (formerly Data Studio) without complex configurations or intermediate databases. Business teams can access their ERP information through automated data flows that keep reports current on a configurable schedule, whether every 15 minutes or daily.
Kondado provides a direct “Via Kondado” connection that replicates Olist Tiny data to Data Studio on your chosen schedule, enabling non-technical teams to build visual reports for inventory, sales, and financial management without writing code or managing servers.
With 15 available pipelines covering CRM, orders, invoices, and accounts, you can create comprehensive dashboards that visualize cash flow, track customer issues, and monitor product stock levels. Marketing and operations teams gain immediate visibility into business performance through interactive charts and automated updates that eliminate manual data exports.
Each item below is automatically replicated by Kondado from Olist Tiny into Data Studio — no schema setup, no manual mapping.
15
available pipelines
792
extractable fields
∞
Auto-refresh
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.
Combining Olist Tiny with Data Studio transforms your ERP data into actionable business intelligence for daily decision-making. By replicating Accounts Receivable and Orders pipelines, finance teams can visualize cash flow trends and payment statuses while operations managers track fulfillment metrics through intuitive dashboards that update automatically.
Product Stock data completes the picture by enabling inventory level monitoring alongside sales performance, helping you identify fast-moving products and prevent stockouts before they impact revenue. These combined insights support smarter purchasing decisions and improved customer satisfaction through comprehensive data visualization that connects financial health with operational efficiency.
How to create Olist Tiny dashboards in Data Studio
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
Connect Olist Tiny to Kondado
Access your Kondado account and add Olist Tiny as a new data source by entering your ERP credentials to establish the connection.
2
Select Data Studio Destination
Choose Looker Studio (Data Studio) as your destination and select which pipelines to replicate, such as Orders, Accounts Receivable, or Product Stock.
3
Build Dashboards and Configure Refresh
Design your visual reports in Looker Studio using the replicated data and set your preferred update frequency to keep insights current on a configurable schedule.
Try out all the features for free for 14 days
Access Olist Tiny data in Data Studio and combine it with dozens of other data sources
If the source you want is not listed, drop us a chat message. We love to add new sources!
Answers about visualizing Olist Tiny data in Data Studio automatically
How do I connect Olist Tiny to Data Studio without technical setup?▼
Kondado provides a direct "Via Kondado" connection that links your Olist Tiny account to Looker Studio without requiring database configuration or API coding. Simply authenticate your Olist Tiny credentials in Kondado, select your desired pipelines, and choose Data Studio as your destination to begin replicating data immediately.
What business dashboards can I build with Olist Tiny data?▼
You can create comprehensive financial dashboards tracking Accounts Payable and Accounts Receivable, operational views monitoring Orders and Product Stock levels, and customer service reports analyzing CRM Issues. These visualizations help you manage cash flow, inventory turnover, and customer satisfaction metrics from a single interface.
How often does Olist Tiny data update in Data Studio?▼
Data replication occurs on a configurable schedule that you control, with options ranging from every 5 minutes to daily updates depending on your business needs. This automated refresh keeps your dashboards current without manual exports, ensuring your team always works with the latest sales, inventory, and financial information.
Which KPIs should I track using Olist Tiny and Data Studio?▼
Key metrics include days sales outstanding from Accounts Receivable, inventory turnover from Product Stock, order fulfillment rates from Orders, and issue resolution times from CRM Issues. Tracking these indicators helps optimize working capital, prevent stockouts, and improve customer service efficiency.
Are there ready-made report templates for Olist Tiny visualization?▼
Yes, Kondado offers pre-built solutions including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report, which provide immediate visualization of your most critical business metrics. These templates accelerate your analytics deployment by delivering ready-to-use dashboards for financial, operational, and sales data without requiring design work.
Can I share Olist Tiny dashboards with my team?▼
Once your data flows to Looker Studio, you can leverage the platform's native sharing capabilities to distribute reports across your organization. Team members can view dashboards, apply filters, and analyze Olist Tiny data according to their roles without needing direct ERP access or technical training.
Do I need a database to visualize Olist Tiny in Data Studio?▼
No intermediate database is required when using Kondado's direct connection, which replicates data straight from Olist Tiny to your visualization tool. This eliminates infrastructure costs and maintenance overhead while providing immediate access to your ERP information for reporting and analysis.
What Olist Tiny data can I visualize in Data Studio?▼
You can replicate 15 different pipelines including financial data from Accounts Payable and Accounts Receivable, sales information from Orders and Invoices, inventory details from Product Stock, and customer service records from CRM Issues. This comprehensive coverage enables complete business visibility across operations, finance, and customer relations.
'%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)