From ContaAzul to MySQL: managed, scheduled, no code.
Kondado provides a direct integration between ContaAzul and MySQL, replicating 13 data pipelines including Accounts Payable, Accounts Receivable, Sales, and People Registration on a configurable schedule ranging from every 5 minutes to daily.
Kondado enables you to replicate your ContaAzul financial data directly into MySQL without writing any code. Simply authenticate your ContaAzul account as a data source, configure MySQL as your destination, and select the specific pipelines you need from the available accounting and sales endpoints. The platform handles the automated data transfer on your chosen schedule, ensuring your database stays current with the latest invoices, expenses, and customer information.
Once your data lands in MySQL, you can build custom financial dashboards, automate reporting workflows, and combine ContaAzul information with other business data sources for comprehensive analysis. This setup eliminates manual CSV exports while giving your technical team immediate SQL access to query invoices, track expense categories, and analyze sales performance using standard database tools.
The available pipelines cover critical financial operations, from the Accounts Payable pipeline tracking expected payment dates and reconciliation status to the Accounts Receivable pipeline monitoring collection statuses. You can also access the Sales pipeline containing transaction totals and dates for comprehensive revenue tracking.
With this data in MySQL, finance teams can create automated cash flow projections by joining payable and receivable records, while analysts can correlate transaction totals with detailed item information for profitability analysis. The People Registration pipeline further enables customer segmentation by connecting contact information to transaction histories, allowing you to identify top clients and optimize collection strategies directly within your database environment.
Try out all the features for free for 14 days
Replicated to MySQL
ContaAzul data available for MySQL
Tables Kondado writes into your MySQL, on a schedule you control.
13
available pipelines
571
extractable fields
MySQL
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 ContaAzul Account
Authenticate your ContaAzul credentials in Kondado to establish the data source connection and enable access to your financial pipelines.
2
Configure MySQL Destination
Enter your MySQL host, database name, and authentication details to establish the destination where your replicated data will be stored.
3
Select Data and Schedule
Choose from the 13 available pipelines including Accounts Payable and Sales, then configure your automated update schedule ranging from every 5 minutes to daily.
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 MySQL automatically
How does Kondado replicate ContaAzul data to MySQL?▼
Kondado uses a direct integration to extract data from your ContaAzul account and load it into your MySQL database. You authenticate your ContaAzul credentials as a data source, provide your MySQL connection details, and the platform automatically handles the data replication on your configured schedule without requiring manual exports or API programming.
What ContaAzul data can I replicate to MySQL?▼
You can replicate 13 different pipelines covering financial and operational data including Accounts Payable, Accounts Receivable, Sales transactions, Sales Details, Contracts, and People Registration. Each pipeline contains specific fields such as payment dates, collection statuses, product quantities, and customer contact information totaling 571 available data points.
How often does ContaAzul data update in MySQL?▼
Kondado updates your MySQL database on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This ensures your financial reports and analyses reflect recent transactions without overwhelming your database with constant updates during low-activity periods.
Can I combine ContaAzul data with other sources in MySQL?▼
Yes, MySQL serves as a central repository where you can join ContaAzul financial data with information from additional platforms. You can replicate data from Google Sheets, BigQuery, or PostgreSQL into the same database to create unified reports connecting accounting records with marketing metrics or inventory systems.
What format does ContaAzul data take in MySQL?▼
Each ContaAzul pipeline creates structured tables in MySQL with standardized column names and appropriate data types for financial information. Fields such as UUIDs, dates, currency amounts, and status indicators arrive ready for SQL querying, allowing immediate use in stored procedures, views, and analytical queries without additional data cleaning.
Are there pre-built dashboards available for ContaAzul data?▼
Yes, Kondado offers ready-made report templates including the Conta Azul Looker Studio Report and Conta Azul Power BI Report that connect directly to your replicated data. You can also send data to Looker Studio or Power BI alongside MySQL to create visualizations while maintaining your database as the primary data warehouse.
Do I need technical skills to set up the ContaAzul to MySQL pipeline?▼
No coding is required to establish the connection between ContaAzul and MySQL. The platform provides a no-code interface where you simply authenticate your ContaAzul account, enter your MySQL connection parameters, and select your desired pipelines from the available list of 13 data endpoints.
Can I send ContaAzul data to other destinations besides MySQL?▼
Absolutely, you can simultaneously replicate your ContaAzul data to multiple destinations including Power BI, Looker Studio, Google Sheets, BigQuery, and PostgreSQL while maintaining your MySQL database as the primary storage for complex SQL analysis.
'%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)
