From Tiny ERP to BigQuery: managed, scheduled, no code.
Kondado provides a direct integration between Tiny ERP and BigQuery, replicating data from fifteen pipelines including Accounts Payable, Orders, and Product Inventory on a user-configured schedule ranging from five minutes to daily intervals.
Kondado enables businesses to replicate their Tiny ERP data directly into BigQuery without writing a single line of code. By selecting from fifteen available pipelines covering financial records, customer relationships, and inventory management, you can consolidate your operational data into Google’s serverless data warehouse. The platform updates your datasets on a configurable schedule, ensuring your analytics reflect current business conditions while eliminating manual data extraction tasks.
Once your data lands in BigQuery, you can build custom reports, join Tiny ERP information with other marketing or sales datasets, and run complex SQL queries to uncover operational insights. This automated workflow keeps your financial reports, inventory tracking, and sales analysis current for faster decision-making across your organization. Analysts can leverage BigQuery’s processing power to calculate margins, forecast demand, and segment customers using fresh ERP data.
The Accounts Receivable and Accounts Payable pipelines deliver comprehensive financial data that enables cash flow analysis and aging reports directly within BigQuery. By combining Order Details with Product Inventory information, you can calculate stock turnover rates and identify which SKUs drive the most revenue across your retail or manufacturing operations. These datasets support sophisticated queries that connect sales performance with customer management data from the Contacts pipeline, giving you a complete view of profitability by client segment while enabling demand forecasting, budget variance analysis, and automated financial reconciliation without manual spreadsheet work.
Try out all the features for free for 14 days
Replicated to BigQuery
Tiny ERP data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
15
available pipelines
792
extractable fields
BigQuery
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 Your Tiny ERP Account
Authenticate your Tiny ERP data source in Kondado by providing your API credentials, allowing the platform to access your financial and operational records.
2
Configure BigQuery Destination
Enter your BigQuery project and dataset information to establish where your Tiny ERP data will be stored and organized.
3
Select Pipelines and Set Schedule
Choose from fifteen available pipelines including Accounts Receivable, Orders, and Product Inventory, then define your update frequency to begin automated replication.
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 BigQuery automatically
How does Kondado replicate data from Tiny ERP to BigQuery?▼
Kondado connects directly to your Tiny ERP instance and extracts data through fifteen available pipelines, then loads it into your specified BigQuery dataset. The process runs automatically on your chosen schedule without requiring manual exports or technical configuration.
What specific Tiny ERP data can I replicate to BigQuery?▼
You can replicate financial records through Accounts Payable and Accounts Receivable pipelines, operational data via Orders and Product Inventory, and customer information through the Contacts pipeline. Each pipeline contains specific fields such as issue dates, balances, and product details that map directly to BigQuery columns.
How frequently can I update my Tiny ERP data in BigQuery?▼
Kondado supports automated updates on a configurable schedule ranging from every five minutes to daily intervals, depending on your operational requirements. This ensures your BigQuery datasets reflect recent transactions and inventory changes without manual intervention.
Can I combine Tiny ERP data with other marketing or sales platforms in BigQuery?▼
Yes, once your Tiny ERP data resides in BigQuery, you can join it with datasets from additional sources that you replicate to the same destination. This enables unified analysis across your financial, inventory, and marketing operations within a single data warehouse, creating comprehensive customer and profitability views.
Does Kondado offer ready reports for Tiny ERP BigQuery data?▼
Yes, Kondado provides ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report that connect directly to your BigQuery datasets. These templates visualize your financial and operational data immediately, or you can build custom reports in Looker Studio and Power BI using the replicated data.
What data structure does Tiny ERP use when stored in BigQuery?▼
Each Tiny ERP pipeline creates structured tables in BigQuery with typed columns matching the source fields, such as numeric values for balances and timestamps for transaction dates. The schema preserves relationships between entities like orders and customers, enabling complex SQL joins and aggregations for custom analytics.
Can I send Tiny ERP data to visualization tools besides BigQuery?▼
While BigQuery serves as the central data warehouse, you can connect business intelligence tools like Power BI, Looker Studio, and Google Sheets directly to your BigQuery datasets. This flexibility allows you to build reports in your preferred platform while maintaining Tiny ERP data in BigQuery for storage and processing.
'%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)
