How does the Tiny ERP to Redshift pipeline work?

Kondado connects directly to your Tiny ERP instance using API credentials to extract data from selected pipelines. The platform then transforms and loads this information into your Redshift cluster automatically on your chosen schedule, maintaining data consistency without manual intervention.

What Tiny ERP data can I replicate to Redshift?

You can replicate 15 different pipelines including CRM Issues, Accounts Payable, Accounts Receivable, Contacts, Invoices, Orders, and Product Inventory. These pipelines contain 792 fields total, covering financial records, customer data, sales transactions, and inventory management.

How often does Tiny ERP data update in Redshift?

Kondado updates your Redshift data on a configurable schedule that you control, with options ranging from every 5 minutes to hourly or daily intervals. This ensures your analytics reflect recent business activity without overwhelming your source system.

What format does Tiny ERP data take in Redshift?

Data arrives in Redshift as structured tables mirroring your Tiny ERP entities, ready for SQL querying and joining with other datasets. Each pipeline becomes a separate table with properly typed columns corresponding to the 792 available fields from your ERP system.

Can I combine Tiny ERP data with other sources in Redshift?

Yes, once replicated to Redshift, your Tiny ERP tables can be joined with data from other sources like ecommerce platforms or marketing tools. This allows you to create unified analytics across your entire business operation within your existing warehouse environment.

Are there pre-built dashboards for Tiny ERP data?

Yes, Kondado offers ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report. These templates connect directly to your Redshift data, providing immediate visibility into sales, inventory, and financial metrics without building visualizations from scratch.

Can I send Tiny ERP data to other destinations besides Redshift?

Yes, Kondado supports multiple destinations so you can replicate your Tiny ERP data to BigQuery , PostgreSQL , Power BI , Looker Studio , or Google Sheets simultaneously. This flexibility allows different teams to access the same ERP data in their preferred analytics tools.

Do I need coding skills to set up Tiny ERP replication?

No coding is required to configure the connection between Tiny ERP and Redshift. The platform provides a visual interface where you authenticate your accounts, select your pipelines, and define your update schedule through point-and-click configuration.

Send data from Tiny ERP to Redshift

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

Send Tiny ERP Data to Redshift Automatically

Kondado provides a direct integration between Tiny ERP and Amazon Redshift, allowing you to replicate your ERP data without writing code. Simply connect your Tiny ERP account as a data source, configure your Redshift cluster as the destination, and select which pipelines you want to replicate. The platform handles the data extraction and loading automatically on a configurable schedule you define, whether every 5 minutes or daily.

Kondado replicates data from Tiny ERP to Amazon Redshift through 15 available pipelines including CRM Issues, Accounts Payable, Orders, and Products, running on a configurable schedule from 5 minutes to daily intervals, with 792 total fields available for analysis.

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

Once your data arrives in Redshift, you can analyze Accounts Receivable and Accounts Payable pipelines to optimize cash flow and track outstanding balances across your business units. The Orders and Order Details pipelines enable deep dive analysis into sales performance and customer purchasing patterns, while Product Inventory data helps you maintain optimal stock levels. Combine these datasets with other sources in your Redshift warehouse to build comprehensive financial reports and operational dashboards that update automatically.

Try out all the features for free for 14 days

Tiny ERP data available for Redshift

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 Redshift

Sync data automatically — no code, no manual exports.

Connect Tiny ERP Account

Authenticate your Tiny ERP instance in Kondado using your API credentials to establish the data source connection.

Configure Redshift Cluster

Enter your Amazon Redshift connection details including host, port, and database credentials to establish your destination warehouse.

Select Data and Schedule

Choose from 15 available pipelines such as Orders and Accounts Payable, then configure your update frequency from 5 minutes to daily for automated replication.

Try out all the features for free for 14 days