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.

Send data from Tiny ERP to BigQuery

Get started for free

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

or sign up with your email

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

Connect Tiny ERP to BigQuery for Analytics

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.

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.

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.

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

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

Tiny ERP data available for BigQuery

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.

See all available data →

Try out all the features for free for 14 days

How to send Tiny ERP data to BigQuery

Sync data automatically — no code, no manual exports.

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.

Configure BigQuery Destination

Enter your BigQuery project and dataset information to establish where your Tiny ERP data will be stored and organized.

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