Send Olist Tiny data to reports, spreadsheets and ETL

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

shape Olist Tiny

Connect Olist Tiny to Power BI and Databases

Access comprehensive ERP data from your Olist Tiny system including financial records, sales orders, inventory levels, and customer relationship management data. Kondado enables you to extract detailed information from invoices, accounts payable and receivable, product catalogs, and CRM issue tracking. Replicate specific data points such as issue statuses, payment balances, stock quantities, and customer contact details directly into your preferred analytics environment. You can access granular transaction records, XML invoice formats, and detailed product grids to support comprehensive business intelligence initiatives.

Kondado offers 15 distinct pipelines from Olist Tiny covering 792 total fields, providing direct access to Accounts Payable, Accounts Receivable, Orders, Invoices, Products, Contacts, CRM Issues, and detailed transaction records without requiring custom API development.

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

Marketing teams can analyze customer behavior patterns using Contacts and Order Details pipelines to segment audiences and track purchase histories for targeted campaigns. Data analysts benefit from combining Invoice Details with Accounts Receivable data to monitor cash flow, identify payment trends, and forecast revenue streams. Operations managers leverage Product Stock and Orders pipelines to optimize inventory levels, prevent stockouts, and fulfill customer demands efficiently, while finance teams track outstanding liabilities and payment schedules through comprehensive Accounts Payable and Accounts Receivable Details data.

Available Olist Tiny Pipelines

The available Olist Tiny pipelines cover every aspect of your business operations, from customer relationship management to financial reconciliation. The CRM Issues and CRM Issues Details pipelines enable tracking of customer support stages through fields like assunto_data_acao and cliente_cidade, helping you identify service bottlenecks and regional demand patterns. Accounts Payable and Accounts Receivable pipelines provide visibility into cash flow with data_emissao and saldo fields, while Order Details and Product Stock pipelines reveal sales performance trends and inventory availability across your catalog. By connecting Invoice Details with Contacts data, you can analyze purchasing behaviors by customer segment, or combine Orders with Accounts Receivable to monitor payment status against sales volume. With automated updates on a configurable schedule ranging from every 5 minutes to daily, you can monitor critical KPIs like inventory turnover, days sales outstanding, and customer issue resolution times without manual data extraction.

Try out all the features for free for 14 days

Available Olist Tiny data

15
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 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.
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.

Try out all the features for free for 14 days

How to visualize Olist Tiny data in 3 steps

Connect Olist Tiny to dashboards, spreadsheets, or databases — no code required.

1
Add Olist Tiny data source

Connect your Olist Tiny ERP system to Kondado by entering your authentication credentials in the platform interface.

2
Select pipelines and destination

Choose from 15 available pipelines including Orders, Invoices, and CRM Issues, then send your data to Power BI, Looker Studio, Google Sheets, BigQuery, PostgreSQL, or other supported databases.

3
Analyze data across all platforms

View your replicated data in Power BI or Looker Studio dashboards, explore trends in Google Sheets or Excel spreadsheets, and query structured tables in BigQuery, PostgreSQL, MySQL, or Redshift databases.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Pick a Spreadsheet, Database, Data Warehouse or Data Lake to receive Olist Tiny data

Choose a tool to visualize your Olist Tiny data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Olist Tiny to dashboards, spreadsheets, and databases

What specific Olist Tiny data can I access through Kondado?
You can replicate 15 distinct pipelines including CRM Issues with assunto_id and status fields, Accounts Payable with data_vencimento and valor information, Product Stock balances, and detailed Invoice records with XML formatting options. This covers financial, operational, and customer management data from your ERP system.
How do I connect Olist Tiny to my existing BI tools?
Kondado provides direct integration to popular analytics platforms including Power BI, Looker Studio, and Google Sheets, plus database destinations like BigQuery, PostgreSQL, MySQL, and SQL Server. Simply authenticate your Olist Tiny account and select your destination during setup.
How frequently does Kondado update my Olist Tiny data?
You can configure automated updates to run on schedules ranging from every 5 minutes to once daily, depending on your business needs. This allows near-real-time monitoring of inventory levels and financial transactions without manual exports.
What pre-built dashboards are available for Olist Tiny analytics?
Kondado provides ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report, enabling immediate visualization of your ERP data. These templates cover financial performance, sales trends, and inventory management metrics.
Can I combine Olist Tiny data with other business systems?
Yes, you can create unified datasets by replicating Olist Tiny pipelines alongside data from other sources into your data warehouse. This enables cross-functional analysis such as correlating marketing campaign data with actual sales orders and revenue figures.
What analyses can I perform with Olist Tiny Order and Invoice data?
You can calculate average order values, track sales velocity by product category, monitor days sales outstanding through Accounts Receivable Details, and analyze payment patterns using Invoice Details with data_emissao and numero_doc fields.
Do I need technical skills to set up the Olist Tiny connection?
No coding is required to establish the connection. Kondado handles the API complexity, allowing you to authenticate your Olist Tiny account and select specific pipelines like Contacts or Products through an intuitive interface.

Try out all the features for free for 14 days