From ContaAzul to Amazon S3: managed, scheduled, no code.
Kondado automatically replicates ContaAzul accounting and financial data to Amazon S3 on schedules ranging from every 5 minutes to daily, delivering 571 fields across 13 pipelines including Accounts Payable, Accounts Receivable, and Sales to support analytics with Athena, Presto, and Dremio.
Connect ContaAzul to Amazon S3 for Automated Data Replication
Kondado enables businesses to replicate their financial data from ContaAzul directly into Amazon S3 without writing any code. By establishing a connection between your Brazilian accounting system and scalable cloud storage, you can automate the extraction of invoices, payments, customer records, and sales transactions on a configurable schedule. Simply authenticate your ContaAzul account, configure your S3 bucket as the destination, and select which data pipelines you want to replicate.
Once your data lands in Amazon S3, you can query it directly using SQL engines like Athena or load it into downstream business intelligence tools for comprehensive financial analysis and reporting. This automated workflow eliminates manual CSV exports and ensures your S3 data lake stays current with the latest transactions from your ContaAzul environment, enabling better cash flow visibility.
With Kondado’s ContaAzul data source, you can replicate specific business objects like Accounts Payable, Accounts Receivable Collections, and Sales Details pipelines directly into your S3 buckets. This enables finance teams to build custom cash flow models in Athena by joining payment due dates with collection statuses, or analyze profitability by correlating Sales Items data with cost center allocations. Having this granular financial information stored in Amazon S3 makes it immediately available for complex SQL queries, allowing you to combine ContaAzul transactions with external datasets in your data virtualization layer using Presto or Dremio.
Try out all the features for free for 14 days
Replicated to Amazon S3
ContaAzul data available for Amazon S3
Tables Kondado writes into your Amazon S3, on a schedule you control.
13
available pipelines
571
extractable fields
Amazon S3
Destination
Available integrations
People Registration: Details
Includes fields such as uuid, name, and email, along with information on active status and person type, either INDIVIDUAL or LEGAL.
People Registration
Contains data such as document, phone, and address, including details like neighborhood, city, and state, along with active status.
Accounts Payable
Presents information on financial obligations, including id, expected payment date, and reconciliation status.
Accounts Payable: Categories
Includes financial categories with fields such as id, name, and type, along with information on whether they should be considered as cost in the DRE.
Accounts Payable: Cost Centers
Provides data on cost centers, including id, name, and active status, along with a custom code for internal organization.
Accounts Receivable
Contains information on amounts receivable, including id, due date, and collection status, along with financial details.
Accounts Receivable: Categories
Includes accounts receivable categories with fields such as id, name, and type, along with information on whether they are considered revenue.
Accounts Receivable: Cost Centers
Provides data on cost centers related to accounts receivable, including id and name, along with active status.
Accounts Receivable: Collections
Includes information on collections, with fields such as id, status, and due date, along with relevant financial details.
Contracts
Contains data on contracts, including id, contracting party name, and status, along with associated financial information.
Sales
Data on sales transactions, including fields such as id, sale date, and total amount.
Sales Details
Detailed information on each sale, such as sale id, product, quantity, and unit price.
Sales Items
List of sold items, including fields such as item id, description, quantity, and value.
Sync data automatically — no code, no manual exports.
1
Connect Your ContaAzul Account
Authenticate your ContaAzul data source in Kondado by providing your API credentials, allowing the platform to access your financial records and accounting data.
2
Configure Amazon S3 Destination
Set up your Amazon S3 bucket as the target location, specifying the folder structure and file format preferences for your replicated ContaAzul pipelines.
3
Select Pipelines and Schedule
Choose from the 13 available ContaAzul pipelines such as Accounts Payable and Sales, then configure your preferred update frequency from every 5 minutes to daily intervals.
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 ContaAzul data to Amazon S3 automatically
How does ContaAzul data replication to Amazon S3 work?▼
Kondado connects to your ContaAzul account via API and automatically extracts your financial records on your chosen schedule. The platform pushes this data directly to your specified Amazon S3 bucket in a structured format, maintaining data consistency without requiring manual exports or custom scripts.
What specific financial data from ContaAzul can I store in Amazon S3?▼
You can replicate 13 different pipelines covering People Registration, Accounts Payable categories and cost centers, Accounts Receivable with collections data, Contracts, and comprehensive Sales information including item-level details. This gives you access to 571 fields ranging from customer contact information to transaction-level financial metrics.
How frequently can I update ContaAzul data in my Amazon S3 bucket?▼
Kondado offers flexible scheduling options that let you choose update intervals from as frequent as every 5 minutes to daily, hourly, or custom schedules. This ensures your S3 data lake reflects your current financial position without overwhelming your storage with unnecessary API calls.
In what file format does ContaAzul data arrive in Amazon S3?▼
Data is delivered in optimized formats compatible with AWS analytics services, typically Parquet or JSON, making it immediately queryable through Amazon Athena. This structure eliminates the need for additional transformation steps before running SQL queries in your data virtualization layer.
Can I merge ContaAzul data with other business systems in Amazon S3?▼
Absolutely, once your accounting data resides in S3, you can combine it with information from your CRM, inventory systems, or other business platforms that also send data to Amazon S3. You can also join this data with information replicated to BigQuery or PostgreSQL for comprehensive cross-platform financial analysis.
Are there pre-built dashboards available for analyzing ContaAzul data?▼
Yes, Kondado provides ready-made report templates including the Conta Azul Looker Studio Report and Conta Azul Power BI Report, which connect directly to your data destination. These templates save hours of dashboard configuration while delivering immediate insights into cash flow, sales performance, and financial health.
'%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)
