Send Omie data to reports, spreadsheets and ETL
Get started for free
No credit card required | 14 days | 10 million records | 30 pipelines
or sign up with your email
By signing up, you agree to Kondado’s Terms of service and Privacy policy
Connect Omie Data to Power BI and Databases
Access comprehensive Omie data including financial movements, sales orders, inventory stock levels, and accounts payable transactions directly through Kondado. Extract detailed information from your ERP covering clients and suppliers, purchase requisitions, tax coupons, and production orders without writing code. Replicate critical business metrics from stock adjustments to service contracts, enabling complete visibility into your Brazilian business operations. Whether you need product family classifications or DRE account structures, all your operational data becomes available for external analysis and strategic planning.
Kondado offers 77 pipelines with 2201 fields available from Omie, covering every aspect of your business management platform from banking and tax classifications to sales opportunities and cash budgets.
Finance teams can monitor cash flow by analyzing current accounts daily balance alongside accounts receivable transactions to optimize working capital and predict liquidity needs. Operations managers track inventory health through stock movements and product shipments while sales leaders analyze opportunities and pre-sales data to forecast revenue accurately and identify pipeline bottlenecks. Data analysts combine purchase orders with incoming notes to uncover procurement patterns and cost optimization opportunities across departments. Marketing teams leverage telemarketing and competitor data to refine outreach strategies and market positioning against rival businesses.
The Kondado platform takes care of refreshing Omie data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Omie data in your report, spreadsheet, data warehouse, data lake, or database
Ready-to-use and customizable reports for Omie
Below you will find the complete list of Omie pipelines available for replication, each representing a distinct data endpoint you can sync to your preferred destination. Extract insights from the Accounts Receivable Transactions pipeline to track payment delays and customer creditworthiness, or analyze Sales Orders stages to identify bottlenecks in your conversion funnel. The Stock Movement pipeline reveals inventory turnover patterns while Financial Movements provides cash flow visibility, and combining Clients and Suppliers data with Opportunities helps you understand which relationships drive the most revenue. By joining Purchase Orders with Incoming Notes, you can perform three-way matching analysis to detect discrepancies between ordered and received goods, or correlate Production Orders with Product Shipments to measure fulfillment efficiency across your supply chain. With automated updates running on a configurable schedule from every five minutes to daily, your KPIs in Power BI or Looker Studio dashboards remain current for timely decision-making.
Try out all the features for free for 14 days
Available Omie data
77
available pipelines
2201
extractable fields
Available integrations
| Integration | Description |
|---|---|
| Stock Adjustments | Adjustment movements include fields like id_ajuste, quantity, and value, allowing tracking of product entries and exits in stock. |
| Banks | The list of configured banks features fields like codigo, name, and type, essential for financial operations on the platform. |
| Categories | Financial categories include fields like codigo, description, and codigo_dre, used to control revenues and expenses. |
| Cenários de impostos | |
| Cenários de impostos: detalhes | |
| Clients and Suppliers | The clients and suppliers table features fields like name, email, and status, facilitating the management of business relationships. |
| Clients and Suppliers: Characteristics | Characteristics of clients and suppliers include fields detailing additional information, such as contact type and preferences. |
| Clients and Suppliers: Subscriber Type | Subscriber type for clients and suppliers is defined by fields that categorize business relationships and their characteristics. |
| Buyers | The buyers table includes fields like id_buyer, name, and status, allowing effective tracking of transactions. |
| Purchases: Stock | Purchase movements in stock are recorded with fields like id_purchase, product, and quantity, facilitating inventory management. |
| Purchases: Payment Methods | Table presenting payment methods used in purchases, including fields such as payment_method_id, description, and type. |
| Competitors | Table listing competitors with fields such as competitor_id, name, and market. |
| Accounts | Table containing information about accounts, including fields such as account_id, description, and account type. |
| DRE Accounts | Table presenting DRE accounts with fields such as dre_code, description, and revenue_account. |
| Accounts Payable: Transactions | Table detailing accounts payable transactions, including fields such as transaction_id, amount, and due_date. |
| Accounts Receivable: Transactions | Table presenting accounts receivable transactions, with fields such as transaction_id, amount, and receipt_date. |
| Current Accounts | Table listing current accounts with fields such as current_account_id, balance, and account_type. |
| Current Accounts: Transactions | Table detailing transactions in current accounts, including fields such as transaction_id, amount, and date. |
| Current Accounts: Daily Balance | Table presenting the daily balance of current accounts, with fields such as current_account_id, date, and balance. |
| Contacts | Table containing contact information, including fields such as contact_id, name, and email. |
| Tax Coupons | Table containing information about tax coupons, including fields such as code, issue date, and total amount. |
| Tax Coupon Items | Table detailing items associated with tax coupons, with fields such as product code, quantity, and unit price. |
| Tax Coupon Payments | Table presenting information about payments for tax coupons, including fields such as payment method, amount, and payment date. |
| My Company Data | Table with company information, including fields such as name, CNPJ, address, and phone number. |
| Departments | Table listing the company's departments, with fields such as code, name, and description. |
| Product Families | Table categorizing products into families, including fields such as code, name, and family description. |
| Phases | Table describing the phases of a process, with fields such as code, name, and phase description. |
| Taxes: CEST | Table listing CEST codes for tax classification, including fields such as code and description. |
| Taxes: CFOP | Table containing CFOP codes used in taxation, with fields such as code and description. |
| Taxes: CNAE | Table listing CNAE codes for economic activities, including fields such as code and activity description. |
| Taxes: COFINS - CST | Table provides information on COFINS classification, including fields such as code, description, and rate. |
| Taxes: ICMS - CSOSN | Table presents data on ICMS classification, with fields such as code, description, and applicable rate. |
| Taxes: ICMS - CST | Table includes information on ICMS classification, with fields such as code, description, and rate. |
| Taxes: ICMS - origin of goods | Table provides data on the origin of goods for ICMS, including fields such as code, description, and type of origin. |
| Taxes: IPI - CST | Table contains information on IPI classification, with fields such as code, description, and rate. |
| Taxes: IPI - classification | Table presents data on IPI classification, including fields such as code, description, and type of classification. |
| Taxes: PIS - CST | Table includes information on PIS classification, with fields such as code, description, and rate. |
| Taxes: Calculation type | Table provides data on tax calculation types, including fields such as code, description, and calculation method. |
| Items of price tables | Table contains information on price items, including fields such as product code, description, and value. |
| Stock Locations | Table presents data on stock locations, including fields such as code, name, and address of the location. |
| Reasons | Table contains information about reasons for stock adjustments, including fields such as id_reason, description, and type. |
| Stock Movement | Table details stock movements, with fields such as id_movement, stock_location_code, and quantity. |
| Financial Movements | Table presents financial movements, including fields such as id_movement, type, value, and date. |
| Incoming Notes | Table records incoming notes, with fields such as id_note, supplier, date, and total value. |
| Invoices: Receipt | Table contains information about receipt invoices, including fields such as id_invoice, supplier, and value. |
| Opportunities | Table lists sales opportunities, with fields such as id_opportunity, client, status, and potential value. |
| Production Orders | Table details production orders, including fields such as id_order, product, quantity, and start date. |
| Origins | Table presents sales origins, with fields such as id_origin, description, and origin type. |
| Cash Budget | Table contains information about cash budget, including fields such as id_budget, date, and planned value. |
| Partners | Table lists business partners, with fields such as id_partner, name, type, and status. |
| Purchase Order | Contains information about purchase orders, including fields such as order_id, date, supplier, and status. |
| Sales Orders | Records details of sales orders, with fields such as order_id, customer, date, and total. |
| Sales Orders: To Invoice | Lists sales orders pending invoicing, including fields such as order_id, customer, and total value. |
| Sales Orders: Stages | Presents the stages of sales orders, with fields such as order_id, status, and stage date. |
| Products | Includes information about products, with fields such as product_code, name, category, and price. |
| Products: Characteristics | Details product characteristics, including fields such as product_id, attribute, and value. |
| Products: Structure | Describes the structure of products, with fields such as product_id, type, and components. |
| Projects | Contains information about projects, including fields such as project_id, name, status, and start date. |
| Pre-Sales | Records information about pre-sales, including fields such as pre_sale_id, customer, and date. |
| Product List by Supplier | Presents the list of products by supplier, with fields such as supplier_id, product_code, and product name. |
| Product Shipments | Includes information on shipment ID, product code, and quantity shipped, allowing tracking of inventory movements. |
| Purchase Requisitions | Contains data on requisition ID, requested product, and quantity, facilitating the management of purchase orders. |
| Services: NFSe | Presents information on service ID, description, and value, essential for issuing service invoices. |
| Services: Service Classification | Includes data on classification code, description, and service category, aiding in the organization of provided services. |
| Services: Service Contracts | Provides information on contract ID, client, and value, enabling effective management of service contracts. |
| Services: Service Contracts in Billing | Includes details on contract ID, billing status, and total value, essential for financial control. |
| Services: Service Orders | Presents information on order ID, service description, and status, facilitating the tracking of requests. |
| Services: Service Orders in Billing | Includes data on order ID, billing status, and value, essential for financial management. |
| Solutions | Contains information on solution ID, description, and category, helping in the organization of offered solutions. |
| Status | Includes data on status ID, description, and category, allowing tracking of process progress. |
| Tasks | Table containing information about tasks, including fields such as task_id, description, and status. |
| Task Types | Table classifying task types, featuring fields such as type_id, description, and priority. |
| Telemarketing | Table containing telemarketing data, including fields such as telemarketing_id, client, and result. |
| Delivery Type | Table describing delivery types, with fields such as delivery_type_id, description, and deadline. |
| Types | Table listing different types, including fields such as type_id and description. |
| Types of My Company's Activity | Table categorizing company activities, featuring fields such as activity_id and description. |
| Types of Current Accounts | Table classifying types of current accounts, including fields such as account_type_id and description. |
Stock Adjustments
Adjustment movements include fields like id_ajuste, quantity, and value, allowing tracking of product entries and exits in stock.
Banks
The list of configured banks features fields like codigo, name, and type, essential for financial operations on the platform.
Categories
Financial categories include fields like codigo, description, and codigo_dre, used to control revenues and expenses.
Cenários de impostos
Cenários de impostos: detalhes
Clients and Suppliers
The clients and suppliers table features fields like name, email, and status, facilitating the management of business relationships.
Clients and Suppliers: Characteristics
Characteristics of clients and suppliers include fields detailing additional information, such as contact type and preferences.
Clients and Suppliers: Subscriber Type
Subscriber type for clients and suppliers is defined by fields that categorize business relationships and their characteristics.
Buyers
The buyers table includes fields like id_buyer, name, and status, allowing effective tracking of transactions.
Purchases: Stock
Purchase movements in stock are recorded with fields like id_purchase, product, and quantity, facilitating inventory management.
Purchases: Payment Methods
Table presenting payment methods used in purchases, including fields such as payment_method_id, description, and type.
Competitors
Table listing competitors with fields such as competitor_id, name, and market.
Accounts
Table containing information about accounts, including fields such as account_id, description, and account type.
DRE Accounts
Table presenting DRE accounts with fields such as dre_code, description, and revenue_account.
Accounts Payable: Transactions
Table detailing accounts payable transactions, including fields such as transaction_id, amount, and due_date.
Accounts Receivable: Transactions
Table presenting accounts receivable transactions, with fields such as transaction_id, amount, and receipt_date.
Current Accounts
Table listing current accounts with fields such as current_account_id, balance, and account_type.
Current Accounts: Transactions
Table detailing transactions in current accounts, including fields such as transaction_id, amount, and date.
Current Accounts: Daily Balance
Table presenting the daily balance of current accounts, with fields such as current_account_id, date, and balance.
Contacts
Table containing contact information, including fields such as contact_id, name, and email.
Tax Coupons
Table containing information about tax coupons, including fields such as code, issue date, and total amount.
Tax Coupon Items
Table detailing items associated with tax coupons, with fields such as product code, quantity, and unit price.
Tax Coupon Payments
Table presenting information about payments for tax coupons, including fields such as payment method, amount, and payment date.
My Company Data
Table with company information, including fields such as name, CNPJ, address, and phone number.
Departments
Table listing the company's departments, with fields such as code, name, and description.
Product Families
Table categorizing products into families, including fields such as code, name, and family description.
Phases
Table describing the phases of a process, with fields such as code, name, and phase description.
Taxes: CEST
Table listing CEST codes for tax classification, including fields such as code and description.
Taxes: CFOP
Table containing CFOP codes used in taxation, with fields such as code and description.
Taxes: CNAE
Table listing CNAE codes for economic activities, including fields such as code and activity description.
Taxes: COFINS - CST
Table provides information on COFINS classification, including fields such as code, description, and rate.
Taxes: ICMS - CSOSN
Table presents data on ICMS classification, with fields such as code, description, and applicable rate.
Taxes: ICMS - CST
Table includes information on ICMS classification, with fields such as code, description, and rate.
Taxes: ICMS - origin of goods
Table provides data on the origin of goods for ICMS, including fields such as code, description, and type of origin.
Taxes: IPI - CST
Table contains information on IPI classification, with fields such as code, description, and rate.
Taxes: IPI - classification
Table presents data on IPI classification, including fields such as code, description, and type of classification.
Taxes: PIS - CST
Table includes information on PIS classification, with fields such as code, description, and rate.
Taxes: Calculation type
Table provides data on tax calculation types, including fields such as code, description, and calculation method.
Items of price tables
Table contains information on price items, including fields such as product code, description, and value.
Stock Locations
Table presents data on stock locations, including fields such as code, name, and address of the location.
Reasons
Table contains information about reasons for stock adjustments, including fields such as id_reason, description, and type.
Stock Movement
Table details stock movements, with fields such as id_movement, stock_location_code, and quantity.
Financial Movements
Table presents financial movements, including fields such as id_movement, type, value, and date.
Incoming Notes
Table records incoming notes, with fields such as id_note, supplier, date, and total value.
Invoices: Receipt
Table contains information about receipt invoices, including fields such as id_invoice, supplier, and value.
Opportunities
Table lists sales opportunities, with fields such as id_opportunity, client, status, and potential value.
Production Orders
Table details production orders, including fields such as id_order, product, quantity, and start date.
Origins
Table presents sales origins, with fields such as id_origin, description, and origin type.
Cash Budget
Table contains information about cash budget, including fields such as id_budget, date, and planned value.
Partners
Table lists business partners, with fields such as id_partner, name, type, and status.
Purchase Order
Contains information about purchase orders, including fields such as order_id, date, supplier, and status.
Sales Orders
Records details of sales orders, with fields such as order_id, customer, date, and total.
Sales Orders: To Invoice
Lists sales orders pending invoicing, including fields such as order_id, customer, and total value.
Sales Orders: Stages
Presents the stages of sales orders, with fields such as order_id, status, and stage date.
Products
Includes information about products, with fields such as product_code, name, category, and price.
Products: Characteristics
Details product characteristics, including fields such as product_id, attribute, and value.
Products: Structure
Describes the structure of products, with fields such as product_id, type, and components.
Projects
Contains information about projects, including fields such as project_id, name, status, and start date.
Pre-Sales
Records information about pre-sales, including fields such as pre_sale_id, customer, and date.
Product List by Supplier
Presents the list of products by supplier, with fields such as supplier_id, product_code, and product name.
Product Shipments
Includes information on shipment ID, product code, and quantity shipped, allowing tracking of inventory movements.
Purchase Requisitions
Contains data on requisition ID, requested product, and quantity, facilitating the management of purchase orders.
Services: NFSe
Presents information on service ID, description, and value, essential for issuing service invoices.
Services: Service Classification
Includes data on classification code, description, and service category, aiding in the organization of provided services.
Services: Service Contracts
Provides information on contract ID, client, and value, enabling effective management of service contracts.
Services: Service Contracts in Billing
Includes details on contract ID, billing status, and total value, essential for financial control.
Services: Service Orders
Presents information on order ID, service description, and status, facilitating the tracking of requests.
Services: Service Orders in Billing
Includes data on order ID, billing status, and value, essential for financial management.
Solutions
Contains information on solution ID, description, and category, helping in the organization of offered solutions.
Status
Includes data on status ID, description, and category, allowing tracking of process progress.
Tasks
Table containing information about tasks, including fields such as task_id, description, and status.
Task Types
Table classifying task types, featuring fields such as type_id, description, and priority.
Telemarketing
Table containing telemarketing data, including fields such as telemarketing_id, client, and result.
Delivery Type
Table describing delivery types, with fields such as delivery_type_id, description, and deadline.
Types
Table listing different types, including fields such as type_id and description.
Types of My Company's Activity
Table categorizing company activities, featuring fields such as activity_id and description.
Types of Current Accounts
Table classifying types of current accounts, including fields such as account_type_id and description.
Try out all the features for free for 14 days
How to visualize Omie data in 3 steps
Connect Omie to dashboards, spreadsheets, or databases — no code required.
1
Add Omie as data source
Log into Kondado and add Omie from our data source catalog, then authenticate with your API credentials to establish the connection.
2
Select pipelines and destination
Choose from 77 available pipelines like Accounts Receivable or Stock Movements, then select where to send your data such as Power BI, Google Sheets, or BigQuery.
3
Visualize and analyze your data
Build reports in Looker Studio or Power BI, analyze in Excel or Google Sheets spreadsheets, or query your data in PostgreSQL, MySQL, or BigQuery database tables to uncover business insights.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
'%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)
