Connect Tiny ERP to Looker: Dashboards in Minutes

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

Tiny ERP
Looker

Visualize Tiny ERP Data in Looker

How to visualize Tiny ERP data in Looker? Kondado offers a direct connection that replicates your ERP information into Looker without complex technical setup. You simply connect your Tiny ERP account, select the pipelines you need, and your data flows into Looker where you can build comprehensive dashboards. Business teams can track sales performance, monitor inventory levels, and analyze financial metrics using familiar visualization tools that turn raw numbers into actionable insights.

With Kondado, you avoid the technical complexity traditionally associated with business intelligence projects. The platform handles the data replication process automatically, ensuring your reports reflect current business conditions without manual exports or spreadsheet manipulation. Marketing teams can analyze campaign ROI, operations managers can oversee supply chain movements, and financial controllers can maintain cash flow visibility, all within Looker’s intuitive interface.

Kondado connects Tiny ERP to Looker through a Via Kondado connection, eliminating the need for intermediate databases or manual data preparation while updating information on a configurable schedule.

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

Combining Tiny ERP with Looker unlocks powerful business intelligence for online retailers and service providers. By replicating your Orders and Product Inventory pipelines into Looker, you gain immediate visibility into stock levels versus sales velocity, helping prevent stockouts during peak periods. The Accounts Receivable pipeline enables finance teams to monitor outstanding payments and cash flow trends through automated dashboards that refresh on your preferred schedule.

Operations managers can blend CRM Issues data with order information to identify service bottlenecks affecting customer satisfaction. These combined insights enable data-driven decisions about inventory purchases, payment collection priorities, and resource allocation without requiring technical expertise or database management. Looker transforms your ERP records into visual stories that guide daily business decisions.

Try out all the features for free for 14 days

Tiny ERP data available in Looker

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

Try out all the features for free for 14 days

How to create Tiny ERP dashboards in Looker

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Tiny ERP as data source

Log into Kondado and add Tiny ERP as a new data source by entering your ERP credentials to establish the initial connection.

2
Select Looker destination

Choose Looker from the available destinations and configure which pipelines you want to replicate, such as Orders or Product Inventory, to define your data flow.

3
Configure refresh and build dashboards

Set your preferred update frequency in Kondado to keep data current, then access the replicated information in Looker to create visualizations and share reports with stakeholders.

Access Tiny ERP data in Looker 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!

Visualize Tiny ERP data in other BI tools

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

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

Frequently Asked Questions (FAQ)

Answers about visualizing Tiny ERP data in Looker automatically

How do I connect Tiny ERP to Looker using Kondado?
Start by adding Tiny ERP as a data source in your Kondado account and authenticate with your ERP credentials. Then select Looker as your destination and choose which pipelines to replicate, such as Orders or Accounts Receivable. The connection establishes immediately without requiring database configuration or technical assistance.
What dashboards can I build with Tiny ERP data in Looker?
You can create comprehensive financial dashboards tracking cash flow through Accounts Payable and Accounts Receivable pipelines, or operational views combining Product Inventory with Order Details to optimize stock levels. Many users also build customer service dashboards using CRM Issues data to monitor resolution times and satisfaction trends.
How often does my Tiny ERP data update in Looker?
Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily refreshes. This ensures your Looker reports reflect recent business activity without manual intervention, keeping decision-makers informed with current metrics.
Which KPIs should I track when visualizing Tiny ERP in Looker?
Essential metrics include inventory turnover from Product Inventory, days sales outstanding from Accounts Receivable Details, and order fulfillment rates from Order Details. Tracking these KPIs helps identify cash flow gaps, stock shortages, and operational inefficiencies before they impact your business.
Are there pre-built report templates available for Tiny ERP?
Yes, Kondado offers ready-made report templates to accelerate your analytics setup, including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report. While these templates are designed for Looker Studio and Power BI, they provide excellent starting points that can be adapted for Looker or used as inspiration for your custom dashboard design.
Can I share Tiny ERP dashboards with my team in Looker?
Once your data flows into Looker, you can leverage Looker's built-in sharing capabilities to distribute reports across departments. Team members can access dashboards viewing replicated data from pipelines like Contacts and Invoices without needing direct ERP access or Kondado login credentials.
Do I need technical skills to set up the Tiny ERP to Looker connection?
No coding or database expertise is required to connect Tiny ERP to Looker through Kondado. The guided setup process handles the technical aspects of data replication, allowing business users to focus on configuring which pipelines to include and how often to refresh the data.
Can I send Tiny ERP data to other tools besides Looker?
Absolutely, Kondado supports multiple destinations including Power BI, Google Sheets, BigQuery, and PostgreSQL. You can replicate your ERP data to several platforms simultaneously to serve different team preferences and analytical needs.

Try out all the features for free for 14 days