Dashboards in minutes

Connect Omie to Alteryx: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Omie to Alteryx

Kondado enables you to replicate your Omie financial and operational data directly into Alteryx without complex configurations or intermediate databases. By connecting Omie as your data source, you can access sales orders, inventory movements, and financial transactions to build comprehensive visualizations that support daily business decisions. The connection works on a configurable schedule that delivers your information at your chosen frequency, ensuring your analysis always reflects current business conditions. You choose how often your data refreshes, from every five minutes to daily updates, depending on your reporting needs.

77
available pipelines
2201
extractable fields
  • No code, no spreadsheets
  • Auto-refreshed data
  • 14-day free trial

Try out all the features for free for 14 days

Business teams use this connection to monitor cash flow, track inventory levels, and analyze sales performance without waiting for IT support or manual exports. The automated data flow means your Alteryx reports stay current automatically, allowing you to focus on insights rather than data preparation. Whether you manage finances, operations, or sales, having your Omie data readily available in Alteryx helps you respond faster to market changes and identify growth opportunities.

Kondado provides a Via Kondado direct integration between Omie and Alteryx with 77 available pipelines covering 2,201 fields including Accounts Payable Transactions, Sales Orders, and Stock Movements, requiring no technical setup or coding knowledge.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Omie data available in Alteryx

Each item below is automatically replicated by Kondado from Omie into Alteryx — no schema setup, no manual mapping.

77
available pipelines
2201
extractable fields
Auto-refresh

Available integrations

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

With Alteryx, you can combine Omie data from multiple areas of your business to uncover actionable insights. Analyzing your Sales Orders alongside Accounts Receivable Transactions helps you identify which clients generate the most revenue and track payment patterns effectively. You can also cross-reference Stock Movements with Purchases to optimize inventory levels and prevent stockouts before they impact sales performance. These visualizations enable marketing teams to measure campaign ROI using financial data, while operations teams monitor delivery performance through integrated sales and inventory metrics, creating a complete view of business health.

Try out all the features for free for 14 days

How to create Omie dashboards in Alteryx

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Omie as data source

Log into Kondado and add Omie as your data source by entering your API credentials. Select the specific pipelines you need, such as Sales Orders or Financial Movements, to begin replicating your business data.

2
Select Alteryx destination

Choose Alteryx from the available destinations and configure how you want your Omie data structured for analysis. The system prepares your information for immediate use in Alteryx visualizations without requiring intermediate storage.

3
Configure refresh and build reports

Set your preferred update schedule ranging from five minutes to daily, then start building reports in Alteryx using your replicated Omie data. Your dashboards will stay current automatically based on the frequency you selected.

Access Omie data in Alteryx and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Omie data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Omie data in Alteryx automatically

How do I set up the Omie connection to Alteryx using Kondado?
Start by adding Omie as a data source in your Kondado account and authenticate with your Omie credentials. Then select Alteryx as your destination and choose which pipelines you want to replicate, such as Financial Movements or Products. The setup requires no coding and typically takes less than ten minutes to complete.
What types of dashboards can I build with Omie data in Alteryx?
You can create financial dashboards tracking Accounts Payable and Receivable, operational reports monitoring Stock Movements and Purchase Orders, or sales analysis visualizing Opportunities and Sales Orders. Many users build cash flow projections by combining Current Accounts data with historical financial trends to predict future liquidity needs.
How frequently does Omie data update in Alteryx?
Kondado offers a configurable schedule that lets you choose update intervals ranging from every five minutes to daily refreshes. You select the frequency based on your business needs, ensuring your Alteryx reports reflect recent transactions without overwhelming your system with unnecessary updates.
Which specific KPIs should I track using Omie data in Alteryx?
Monitor days sales outstanding using Accounts Receivable Transactions, inventory turnover through Stock Movements, and gross margin by comparing Sales Orders with product cost data. Tracking these metrics helps identify cash flow bottlenecks and optimize your working capital efficiently.
Are there pre-built dashboard templates available for Omie data?
Yes, Kondado offers ready-made report templates including the Omie Looker Studio Report and Omie Power BI Report that you can use immediately. While these templates are designed for other visualization tools, they provide excellent starting points that you can adapt for Alteryx analysis or use alongside your Alteryx workflows.
Can I share Omie dashboards built in Alteryx with my team?
Alteryx allows you to publish and share reports through various formats including PDF, Excel, or interactive web applications. You can distribute automated reports to stakeholders on a schedule, ensuring everyone from finance to sales has access to the same current Omie data insights.
Do I need technical skills to connect Omie to Alteryx?
No technical expertise is required to establish the connection through Kondado. The platform handles the data replication automatically after you select your desired pipelines, making it accessible for business users, marketing teams, and operations managers without IT involvement.
Can I send Omie data to other tools besides Alteryx?
Absolutely, Kondado supports multiple destinations including Power BI, Looker Studio, Google Sheets, BigQuery, and PostgreSQL. You can replicate the same Omie data to several destinations simultaneously to serve different team needs.

Try out all the features for free for 14 days