From Tiny ERP to Amazon S3: managed, scheduled, no code.
Creating a pipeline that sends data from Tiny ERP to Amazon S3 data lakes takes only a few minutes with Kondado. And the whole integration from Tiny ERP to Amazon S3 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 Amazon S3 data lake
How do you send Tiny ERP data to Amazon S3 without writing complex code or managing API connections manually? Kondado offers a direct connection that automatically replicates your business data from Tiny ERP to your Amazon S3 buckets on a configurable schedule. You simply authenticate your Tiny ERP account, set up your Amazon S3 destination, and choose which data pipelines to replicate. The platform handles the extraction and loading processes automatically, ensuring your data arrives in S3 ready for analysis with Athena, Presto, or Dremio.
Once your data lands in Amazon S3, you can leverage the separation of storage and compute to run cost-effective analytics, build data lakes, or feed information directly into business intelligence tools. This setup enables both technical teams and analysts to access standardized Tiny ERP data for comprehensive reporting and decision-making without impacting your production ERP system.
Kondado is a data replication platform that connects Tiny ERP to Amazon S3, automatically extracting data from 15 available pipelines including Orders, Product Inventory, Accounts Receivable, and CRM Issues on a schedule you configure, with no coding required.
With Kondado, you can replicate specific business-critical pipelines such as Accounts Payable, Product Inventory, and Order Details directly to your Amazon S3 environment. This enables finance teams to track cash flow and payment statuses using Athena queries, while operations managers can monitor stock levels and sales performance through Dremio or Presto without querying the live ERP system. By having this data available in S3, you can combine Tiny ERP information with other sources to create unified analytics, build historical archives for compliance, or feed cleaned datasets directly into machine learning workflows for demand forecasting and business intelligence applications.
Try out all the features for free for 14 days
Replicated to Amazon S3
Tiny ERP data available for Amazon S3
Tables Kondado writes into your Amazon S3, on a schedule you control.
15
available pipelines
792
extractable fields
Amazon S3
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. The platform will automatically detect available pipelines including Orders, Inventory, and Financial records.
2
Configure Amazon S3 Destination
Set up your Amazon S3 bucket as the destination, specifying your preferred file format and organization structure. This enables seamless compatibility with Athena, Presto, and Dremio for immediate querying capabilities.
3
Select Pipelines and Schedule
Choose which of the 15 available pipelines to replicate and set your update frequency to every 5 minutes, hourly, or daily. Kondado will automatically begin replicating your Tiny ERP data to Amazon S3 according to your configuration.
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 Amazon S3 automatically
How frequently can I update my Tiny ERP data in Amazon S3?▼
You can configure replication to run every 5 minutes, 15 minutes, hourly, or daily depending on your business needs. This automated scheduling ensures your S3 data lake stays current without manual intervention or API management.
What file format is used when Tiny ERP data lands in Amazon S3?▼
Data arrives in structured formats optimized for analytics engines like Athena, Presto, and Dremio. This allows you to query your Tiny ERP information directly in S3 using standard SQL without additional transformation layers or complex data preparation.
Can I combine Tiny ERP data in Amazon S3 with information from other platforms?▼
Yes, Kondado allows you to replicate data from multiple sources into the same Amazon S3 environment. You can join your Tiny ERP pipelines with other business data directly in S3 using Athena or Presto, or route specific datasets to BigQuery or Power BI for consolidated reporting.
What specific business data can I replicate from Tiny ERP to Amazon S3?▼
Kondado offers 15 distinct pipelines covering financial records, customer relationships, inventory management, and sales operations with 792 available fields total. Available pipelines include Accounts Receivable Details, Invoice Details, CRM Issues, Product Grid, Accounts Payable, and Order Details, enabling comprehensive ERP analytics in your data lake.
Do you offer pre-built dashboards for Tiny ERP data?▼
Yes, Kondado provides ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report. These templates allow you to visualize your replicated data immediately in Looker Studio or Power BI without building dashboards from scratch, though you can also use the raw data in Amazon S3 for custom analytics.
Can I send Tiny ERP data to other destinations besides Amazon S3?▼
Absolutely, Kondado supports replicating Tiny ERP data to multiple destinations including Google Sheets, BigQuery, Power BI, and PostgreSQL. You can configure different pipelines to route to different destinations based on your workflow requirements, or keep copies in both S3 and other platforms.
How does Kondado extract data from my Tiny ERP system?▼
Kondado connects directly to your Tiny ERP instance using your authentication credentials to extract data from the available pipelines. The platform handles all API communication, pagination, and data formatting automatically, delivering clean structured files to your Amazon S3 buckets on your chosen schedule.
'%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)
