From ContaAzul to PostgreSQL: managed, scheduled, no code.
Kondado enables direct replication of 13 ContaAzul data pipelines to PostgreSQL, including Accounts Payable, Accounts Receivable, Sales, and People Registration with 571 fields total.
Sending ContaAzul data to PostgreSQL requires no coding or complex manual configuration. With Kondado, you connect ContaAzul to PostgreSQL by authenticating your account as the data source and configuring your database as the destination, then select which financial pipelines to replicate. The platform handles the data extraction and loading processes automatically on your chosen schedule, whether every 5 minutes or daily, ensuring your financial records remain current for analysis.
The automated process keeps your database updated with Brazilian accounting data, enabling SQL-based analysis of invoices, expenses, and financial reports without manual CSV exports or API maintenance.
Once your Accounts Payable and Accounts Receivable pipelines arrive in PostgreSQL, you can build comprehensive cash flow projections using SQL queries that join expected payment dates with collection statuses and cost center allocations. The Sales and Sales Details pipelines enable deep margin analysis by connecting transaction IDs with product quantities, unit prices, and contract associations, while People Registration data allows you to segment financial metrics by customer type, geographic location, or active status using standard database joins and WHERE clauses for precise business intelligence.
Try out all the features for free for 14 days
Replicated to PostgreSQL
ContaAzul data available for PostgreSQL
Tables Kondado writes into your PostgreSQL, on a schedule you control.
13
available pipelines
571
extractable fields
PostgreSQL
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 credentials in Kondado to establish the data source connection and grant access to your financial records.
2
Configure PostgreSQL Destination
Enter your PostgreSQL connection details including host, database name, and credentials to establish where your ContaAzul pipelines will load.
3
Select Pipelines and Schedule
Choose from 13 available pipelines such as Accounts Payable and Sales, then set your preferred update frequency from every 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 ContaAzul data to PostgreSQL automatically
How does ContaAzul to PostgreSQL replication work on Kondado?▼
Kondado connects directly to your ContaAzul account using your credentials, extracts data from the selected pipelines, and loads it into your PostgreSQL instance on a configurable schedule. The process requires no manual CSV exports or API coding, with automated schema creation that maps ContaAzul's Brazilian accounting fields to appropriate PostgreSQL data types.
What ContaAzul data can I replicate to PostgreSQL?▼
You can replicate 13 distinct pipelines covering People Registration with contact details, Accounts Payable and Receivable with cost center categorization, Contracts with party information, and Sales with item-level details. Each pipeline contains specific fields such as document numbers, expected payment dates, and reconciliation statuses that become queryable columns in your database.
How often does ContaAzul data update in my PostgreSQL database?▼
Update frequency is fully configurable based on your business needs, ranging from every 5 minutes for near-real-time financial monitoring to hourly, daily, or custom intervals. The automated schedule ensures your PostgreSQL tables reflect the latest invoices, payments, and accounting entries without manual intervention.
Can I combine ContaAzul data with other sources in PostgreSQL?▼
Yes, you can send data from additional sources like Google Sheets, BigQuery, or other ERP systems to the same PostgreSQL database. This enables unified SQL analysis that joins ContaAzul financial data with CRM records, inventory systems, or marketing analytics in a single query environment.
What format does ContaAzul data take in PostgreSQL tables?▼
ContaAzul data arrives in PostgreSQL as structured relational tables where each pipeline becomes a separate table with appropriately typed columns. Fields like UUIDs, monetary amounts, dates, and categorical statuses maintain their integrity, allowing complex joins between Accounts Payable categories and cost centers or Sales headers with line items.
Does Kondado offer pre-built dashboards for ContaAzul data?▼
Kondado provides ready-made report templates including the Conta Azul Looker Studio Report and Conta Azul Power BI Report that connect directly to your replicated data. While your data lives in PostgreSQL, you can also send the same pipelines to Looker Studio or Power BI for immediate visualization without building dashboards from scratch.
Which ContaAzul financial records are available as data pipelines?▼
Available pipelines include Accounts Payable with financial obligations and reconciliation data, Accounts Receivable with collection tracking, Sales with transaction totals, and People Registration with individual and legal entity details. Each pipeline extracts specific Brazilian accounting fields such as DRE cost indicators and state registration information directly into your database schema.
'%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)
