From ContaAzul to Redshift: managed, scheduled, no code.
Kondado enables businesses to replicate ContaAzul financial data including accounts payable, accounts receivable, sales transactions, and customer records to Amazon Redshift automatically on schedules ranging from every 5 minutes to daily, requiring no technical development or API programming.
How to send ContaAzul data to Redshift? Kondado provides a direct integration that replicates your financial data from ContaAzul to Amazon Redshift on a configurable schedule. Simply authenticate your ContaAzul account, configure your Redshift warehouse credentials, and select which data pipelines you want to replicate. The platform handles the data extraction and loading automatically, ensuring your analytics environment stays current without manual exports or complex coding.
Once your data arrives in Redshift, you can combine ContaAzul financial information with other business data sources to create comprehensive analytics. Run complex SQL queries across your accounting data, build custom financial models, or connect your preferred business intelligence tools to generate insights. This automated pipeline eliminates the need for manual CSV downloads and ensures your financial reports always reflect the latest transactions from your ContaAzul environment.
With the Accounts Payable and Accounts Receivable pipelines, finance teams can track cash flow trends, monitor payment aging, and identify collection bottlenecks directly within Redshift queries. The Sales and Sales Details pipelines enable granular revenue analysis, allowing you to correlate transaction data with inventory movements or marketing campaigns from other sources in your warehouse. By replicating People Registration data alongside Contracts information, you maintain updated customer records for segmentation analysis, credit risk assessment, and recurring revenue tracking, creating a complete financial picture that supports strategic decision-making.
Try out all the features for free for 14 days
Replicated to Redshift
ContaAzul data available for Redshift
Tables Kondado writes into your Redshift, on a schedule you control.
13
available pipelines
571
extractable fields
Redshift
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 by providing your API credentials through Kondado's interface, granting access to your financial records and accounting data.
2
Configure Redshift Destination
Enter your Amazon Redshift cluster details including host, port, database name, and user credentials to establish the destination warehouse where your ContaAzul data will be stored.
3
Select Pipelines and Schedule
Choose which of the 13 available ContaAzul pipelines to replicate and set your preferred update frequency, from every 5 minutes to daily, to keep your Redshift analytics current.
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 Redshift automatically
How does ContaAzul to Redshift replication work?▼
Kondado connects directly to the ContaAzul API to extract your financial data and load it into your Redshift cluster. You authenticate your ContaAzul account once, provide your Redshift connection details, and the platform handles the automated data transfer on your chosen schedule. The process requires no coding or technical setup beyond entering your credentials.
What ContaAzul data can I replicate to Redshift?▼
You can replicate 13 different data pipelines including Accounts Payable, Accounts Receivable, Sales transactions, Sales Details, Contracts, and People Registration. Each pipeline contains specific financial fields such as payment dates, reconciliation status, cost centers, and customer information, totaling 571 available fields across all datasets.
How often does ContaAzul data update in Redshift?▼
Kondado updates your Redshift data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. You select the frequency during setup based on your analytics needs, and the platform automatically refreshes your selected pipelines accordingly.
Can I combine ContaAzul data with other sources in Redshift?▼
Yes, once your ContaAzul data resides in Redshift, you can join it with data from your CRM, e-commerce platform, or marketing tools loaded through other Kondado pipelines. This enables comprehensive financial analysis that correlates accounting data with sales funnels, inventory systems, or customer behavior metrics stored in the same warehouse.
Does Kondado offer pre-built dashboards for ContaAzul data?▼
Yes, Kondado provides ready-made report templates including the Conta Azul Looker Studio Report and Conta Azul Power BI Report. These templates connect directly to your data destination and provide immediate visualizations of your financial metrics without requiring you to build charts from scratch. You can also send data to Looker Studio or Power BI through other destination options.
What format does ContaAzul data take in Redshift?▼
Each ContaAzul pipeline loads as structured data in your Redshift schema, with columns corresponding to the specific fields available in that dataset. The information arrives ready for SQL querying, with proper data types preserved for dates, currencies, and categorical fields like payment status or person type.
Can I send ContaAzul data to tools other than Redshift?▼
Absolutely, Kondado supports multiple destinations including BigQuery, PostgreSQL, Google Sheets, MySQL, and Amazon S3. You can create separate pipelines to send the same ContaAzul data to different destinations for various use cases across your organization.
Do I need technical skills to set up ContaAzul to Redshift?▼
No coding is required to establish the connection. The setup process involves authenticating your ContaAzul account through Kondado's interface and entering your Redshift cluster credentials. The platform manages the API connections and data schema creation automatically.
'%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)
