Dashboards in minutes

Connect Omie to Microstrategy: Dashboards in Minutes

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 to Microstrategy

Omie

Microstrategy

Kondado enables you to replicate your Omie financial and operational data directly into Microstrategy without any technical setup or database management. Simply select Omie as your data source and Microstrategy as your destination to start analyzing your business metrics immediately. Your sales orders, accounts payable, and inventory movements flow into Microstrategy on a configurable schedule, ready for visualization and strategic decision-making.

available pipelines

2201

extractable fields

✓No code, no spreadsheets
✓Auto-refreshed data
✓14-day free trial

Connect Omie now →

Try out all the features for free for 14 days

Kondado provides a direct integration between Omie and Microstrategy that replicates 77 data pipelines including Sales Orders, Accounts Payable, and Stock Movements, allowing business teams to build automated reports updated every 5 minutes to 24 hours without writing code or managing databases.

Business users can transform complex ERP information from Omie into clear visual stories using Microstrategy’s powerful analytics capabilities. Whether tracking cash flow through financial movements or monitoring sales performance across multiple channels, your data stays current and accessible for confident decision-making.

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 Microstrategy

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

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.

Full docs on the wiki → Start free trial →

Try out all the features for free for 14 days

With your Omie data available in Microstrategy, you can track cash flow by analyzing Accounts Receivable and Accounts Payable pipelines alongside Current Accounts transactions to maintain healthy working capital. Monitor sales performance using the Sales Orders and Opportunities pipelines to identify your best customers, products, and seasonal trends that drive revenue growth. Operations teams gain complete visibility into inventory through Stock Movement and Stock Adjustments data, ensuring you never miss a reorder point or create costly overstock situations while optimizing your supply chain decisions.

Try out all the features for free for 14 days

How to create Omie dashboards in Microstrategy

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

Connect Omie as your data source

Authenticate your Omie account in Kondado to access 77 available pipelines including financial and inventory data.

Select Microstrategy destination

Choose Microstrategy as your destination to receive replicated Omie data without intermediate databases or complex configuration.

Configure refresh and build reports

Set your preferred update frequency from 5 minutes to daily, then start building Microstrategy dashboards using your automated Omie datasets.

Access Omie data in Microstrategy 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!

55pbx

ActiveCampaign

Google Ads

Amazon S3

api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery

Bing

Bitrix24 CRM

Bling!

Blip (take)

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook Ads

Facebook

Fatura Simples

Freshdesk

FTP

Google Analytics GA4

Google Cloud Storage

Google Play Store

Google Search Console

Google Sheets

Granatum

Hi Platform

Hotmart

Hubspot

Huggy

InfluxDB v1

Infusionsoft (Keap)

Instagram Ads

Instagram

Jira

Loja Integrada

MailChimp

Mandrill

Mautic

Meetime

Mercado Libre

Meta Ads

Microsoft Ads

Microsoft Advertising

Mixpanel

monday.com

MongoDB

Movidesk

MySQL (& MariaDB)

NectarCRM

Notion

Nuvemshop (Tiendanube)

Olist Tiny

Omie

Oracle

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun

Ploomes

PostgreSQL

Pushwoosh

RDStation CRM

RDStation

Recruiterbox

Salesforce Marketing Cloud (Exact Target)

Salesforce

SenseData

Shopify

SQLServer

Stilingue

Superlogica

Sympla

Taboola

Tangerino

TikTok Ads

TikTok Organic

Tiny ERP

Toggl

Tray

Trello

Twilio

VNDA

VTEX

Wake Commerce

Webhook

Wootric

WordPress

X Ads

YouTube

Zeeng

Zendesk Chat (Zopim)

Zendesk

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

Omie > Airtable

Omie > Alteryx

Omie > Amazon Quicksight

Omie > BIMachine

Omie > Cortex

Omie > Data Studio

Omie > Geckoboard

Omie > Grafana

Omie > IBM Cognos Analytics

Omie > Klipfolio

Omie > Looker Studio

Omie > Looker

Omie > Looqbox

Omie > Metabase

Omie > Microstrategy

Omie > Pentaho

Omie > Power BI

Omie > Qlik Cloud Analytics

Omie > Qlik Sense

Omie > Qlik

Omie > QlikView

Omie > Redash

Omie > Superset

Omie > Tableau

Omie > BI TOTVS

Omie > Zoho Analytics

Related on Kondado

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Frequently Asked Questions (FAQ)

Answers about visualizing Omie data in Microstrategy automatically

How do I connect Omie to Microstrategy without technical knowledge? ▼

Start by selecting Omie as your data source in Kondado and authenticate with your Omie credentials. Choose Microstrategy as your destination and select the specific pipelines you need, such as Sales Orders or Financial Movements. Kondado handles the data replication automatically, delivering ready-to-use datasets to your Microstrategy environment within minutes.

What dashboards can I build with Omie data in Microstrategy? ▼

You can create comprehensive financial dashboards tracking Accounts Payable aging and Accounts Receivable performance, or operational views monitoring Stock Movements and Purchase Orders. Marketing teams often build client analysis reports using the Clients and Suppliers pipeline combined with Sales Orders data to identify top-performing segments and retention rates.

How often does Omie data update in Microstrategy? ▼

You configure the update frequency based on your business needs, choosing intervals from every 5 minutes for near-real-time sales monitoring to daily updates for financial reconciliation. This automated schedule ensures your Microstrategy reports always reflect current Omie data without manual exports or spreadsheet uploads.

Can I track specific KPIs like cash flow and inventory turnover? ▼

Yes, combine the Current Accounts Daily Balance pipeline with Accounts Payable and Accounts Receivable transactions to calculate working capital and cash runway. For inventory metrics, use Stock Movement data alongside Product Families to analyze turnover rates and identify slow-moving items that impact your cash flow.

Are there pre-built templates available for Omie visualization? ▼

While you can build custom Microstrategy dashboards, Kondado also offers ready-made reports including the Omie Looker Studio Report and Omie Power BI Report if you prefer to visualize data in Looker Studio or Power BI. These templates provide immediate insights into financial performance and sales metrics without requiring dashboard design from scratch.

How do I share Microstrategy dashboards with my team? ▼

Once your Omie data flows into Microstrategy, use Microstrategy's native sharing features to distribute reports to stakeholders across your organization. Your team accesses the same updated data automatically, ensuring everyone works with consistent financial and operational metrics for aligned decision-making.

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

Connect Omie to Microstrategy: Dashboards in Minutes

Get started for free

Omie data available in Microstrategy

Available integrations

How to create Omie dashboards in Microstrategy

Connect Omie as your data source

Select Microstrategy destination

Configure refresh and build reports

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

55pbx

ActiveCampaign

Google Ads

Amazon S3

api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery

Bing

Bitrix24 CRM

Bling!

Blip (take)

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook Ads

Facebook

Fatura Simples

Freshdesk

FTP

Google Analytics GA4

Google Cloud Storage

Google Play Store

Google Search Console

Google Sheets

Granatum

Hi Platform

Hotmart

Hubspot

Huggy

InfluxDB v1

Infusionsoft (Keap)

Instagram Ads

Instagram

Jira

Linkedin

Loja Integrada

MailChimp

Mandrill

Mautic

Meetime

Mercado Libre

Meta Ads

Microsoft Ads

Microsoft Advertising

Mixpanel

monday.com

MongoDB

Movidesk

MySQL (& MariaDB)

NectarCRM

Notion

Nuvemshop (Tiendanube)

Olist Tiny

Omie

Oracle

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun

Ploomes