From Tiny ERP to Redshift: managed, scheduled, no code.
Creating a pipeline that sends data from Tiny ERP to Redshift data warehouses takes only a few minutes with Kondado. And the whole integration from Tiny ERP to Redshift is managed and executed by our platform. With Kondado, you can focus on extracting value from Tiny ERP data and combining it with other data in your Redshift data warehouse
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.
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
Replicated to Redshift
Tiny ERP data available for Redshift
Tables Kondado writes into your Redshift, on a schedule you control.
15
available pipelines
792
extractable fields
Redshift
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 Tiny ERP Account
Authenticate your Tiny ERP instance in Kondado using your API credentials to establish the data source connection.
2
Configure Redshift Cluster
Enter your Amazon Redshift connection details including host, port, and database credentials to establish your destination warehouse.
3
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
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 Redshift automatically
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.
'%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)
