Dashboards in minutes

Connect Mercado Libre to Pentaho: 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 Mercado Libre to Pentaho

You can visualize Mercado Livre data in Pentaho by using Kondado to replicate your marketplace information directly into your analytics environment. Simply connect Mercado Livre as a data source, select Pentaho as your destination, and choose from nineteen available pipelines spanning over seven hundred fields to populate your business reports. Kondado handles the data preparation behind the scenes, so marketing and operations teams can build insightful dashboards without writing any code or managing technical infrastructure.

19
available pipelines
716
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial
Connect Mercado Libre now →

Try out all the features for free for 14 days

With automated updates running on your preferred timetable, your Pentaho reports always reflect the latest marketplace activity. This means you can track product performance, advertising results, and customer behavior as your business evolves, turning raw marketplace data into clear visualizations that support daily decisions.

Kondado offers a direct Via Kondado connection that sends Mercado Livre data to Pentaho with no intermediate databases and no complex setup, allowing business teams to monitor sales, ads, and orders with automated updates on a configurable schedule.

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

Mercado Libre data available in Pentaho

Each item below is automatically replicated by Kondado from Mercado Libre into Pentaho — no schema setup, no manual mapping.

19
available pipelines
716
extractable fields
∞
Auto-refresh

Available integrations

Ads
Table presents published ads with fields such as id, title, price, and description, along with metrics like total_visits_last_90_days.
Items
Table contains item details, including id, catalog_product_id, and attributes such as brand and model, along with pricing information.
Items: stock
Table provides information on available stock, including user_product_id, item_id, and quantity, along with availability type.
Items: daily performance
Table presents daily performance metrics of items, allowing analysis of sales and interactions over time.
Items: prices
Table displays pricing information for items, including id, selling price, and sale conditions, essential for marketing strategies.
Items: selling prices
Table provides details on the selling prices of items, including id and values, fundamental for market analysis.
Items: variations
Table presents variations of items, including attributes such as color and size, allowing better customer segmentation.
Store: daily performance
Table provides daily performance metrics of the store, including total sales and interactions, essential for evaluating results.
Payments Mercado Pago
Table contains information on payments, including id, status, and values, fundamental for financial management.
Orders
Table presents order details, including id, status, and information about buyers, essential for sales management.
Order Invoices
Includes fields such as id, seller_id, and total_amount, allowing detailed analysis of transactions and billed amounts.
Order Reviews
Contains information such as order_id, rating, and comment, facilitating the assessment of customer satisfaction and feedback on orders.
Order Buyers
Presents data such as buyer_id, buyer_email, and buyer_name, allowing analysis of buyer profiles and their contact information.
Order Context
Includes fields such as order_id, context_type, and context_value, providing insights into the conditions and circumstances of orders.
Order Shipments
Contains information such as shipment_id, tracking_number, and shipping_status, allowing tracking and management of shipments made.
Order Items
Includes data such as item_id, quantity, and price, facilitating the analysis of purchased products and their quantities.
Order Payments
Presents fields such as payment_id, payment_method, and payment_status, allowing analysis of payment methods and statuses for orders.
Order Sellers
Includes information such as seller_id, seller_name, and seller_rating, allowing analysis of seller performance and reputation.
Complaints
Contains fields such as complaint_id, order_id, and resolution_status, facilitating tracking and management of customer complaints.
Full docs on the wiki → Start free trial →

Try out all the features for free for 14 days

Combining Mercado Livre with Pentaho gives business teams a complete view of their e-commerce operation through rich visual reports. For example, you can merge the Items: daily performance pipeline with the Ads pipeline to understand how published listings and advertising spend translate into actual sales trends over time. Adding the Orders pipeline and Order Payments data lets operations and finance teams track transaction volumes, payment methods, buyer behavior, and revenue patterns in one centralized place. These combined insights help you adjust pricing, optimize campaigns, and manage inventory with confidence.

Try out all the features for free for 14 days

How to create Mercado Libre dashboards in Pentaho

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

1
Connect Mercado Livre Data Source

Log in to Kondado and add Mercado Livre as a data source by entering your marketplace credentials. This establishes the direct link that pulls your store information into Kondado.

2
Select Pentaho as Destination

Choose Pentaho as your destination and pick the pipelines you want to replicate, such as Orders, Ads, and Items. Kondado prepares the data so it is ready for visualization in your Pentaho environment.

3
Build Reports and Set Refresh

Open Pentaho and create visual reports using your replicated Mercado Livre data, then set your preferred refresh interval to keep insights current. Your dashboards will update automatically on the schedule you choose.

Access Mercado Libre data in Pentaho 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
55pbx
ActiveCampaign
ActiveCampaign
Google Ads
Google Ads
Amazon S3
Amazon S3
api4com
api4com
Apple App Store
Apple App Store
ASAAS
ASAAS
AWS CloudWatch Metrics
AWS CloudWatch Metrics
Azure Table Storage
Azure Table Storage
BigQuery
BigQuery
Bing
Bing
Bitrix24 CRM
Bitrix24 CRM
Bling!
Bling!
Blip (take)
Blip (take)
ClickUp
ClickUp
Clockify
Clockify
ContaAzul
ContaAzul
Criteo
Criteo
E-goi
E-goi
EADBOX
EADBOX
Exact Sales
Exact Sales
Facebook Ads
Facebook Ads
Facebook
Facebook
Fatura Simples
Fatura Simples
Freshdesk
Freshdesk
FTP
FTP
Google Analytics GA4
Google Analytics GA4
Google Cloud Storage
Google Cloud Storage
Google Play Store
Google Play Store
Google Search Console
Google Search Console
Google Sheets
Google Sheets
Granatum
Granatum
Hi Platform
Hi Platform
Hotmart
Hotmart
Hubspot
Hubspot
Huggy
Huggy
InfluxDB v1
InfluxDB v1
Infusionsoft (Keap)
Infusionsoft (Keap)
Instagram Ads
Instagram Ads
Instagram
Instagram
Jira
Jira
Linkedin
Linkedin
Loja Integrada
Loja Integrada
MailChimp
MailChimp
Mandrill
Mandrill
Mautic
Mautic
Meetime
Meetime
Mercado Libre
Mercado Libre
Meta Ads
Meta Ads
Microsoft Ads
Microsoft Ads
Microsoft Advertising
Microsoft Advertising
Mixpanel
Mixpanel
monday.com
monday.com
MongoDB
MongoDB
Movidesk
Movidesk
MySQL (& MariaDB)
MySQL (& MariaDB)
NectarCRM
NectarCRM
Notion
Notion
Nuvemshop (Tiendanube)
Nuvemshop (Tiendanube)
Olist Tiny
Olist Tiny
Omie
Omie
Oracle
Oracle
Pagar.me
Pagar.me
Pinterest Ads
Pinterest Ads
Pipedrive
Pipedrive
Pipefy
Pipefy
PipeRun
PipeRun
Ploomes
Ploomes
PostgreSQL
PostgreSQL
Pushwoosh
Pushwoosh
RDStation CRM
RDStation CRM
RDStation
RDStation
Recruiterbox
Recruiterbox
Salesforce Marketing Cloud (Exact Target)
Salesforce Marketing Cloud (Exact Target)
Salesforce
Salesforce
SenseData
SenseData
Shopify
Shopify
SQLServer
SQLServer
Stilingue
Stilingue
Superlogica
Superlogica
Sympla
Sympla
Taboola
Taboola
Tangerino
Tangerino
TikTok Ads
TikTok Ads
TikTok Organic
TikTok Organic
Tiny ERP
Tiny ERP
Toggl
Toggl
Tray
Tray
Trello
Trello
Twilio
Twilio
VNDA
VNDA
VTEX
VTEX
Wake Commerce
Wake Commerce
Webhook
Webhook
Wootric
Wootric
WordPress
WordPress
X Ads
X Ads
YouTube
YouTube
Zeeng
Zeeng
Zendesk Chat (Zopim)
Zendesk Chat (Zopim)
Zendesk
Zendesk

Visualize Mercado Libre data in other BI tools

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

Airtable
Mercado Libre > Airtable
Alteryx
Mercado Libre > Alteryx
Amazon Quicksight
Mercado Libre > Amazon Quicksight
BIMachine
Mercado Libre > BIMachine
Cortex
Mercado Libre > Cortex
Data Studio
Mercado Libre > Data Studio
Geckoboard
Mercado Libre > Geckoboard
Grafana
Mercado Libre > Grafana
IBM Cognos Analytics
Mercado Libre > IBM Cognos Analytics
Klipfolio
Mercado Libre > Klipfolio
Looker Studio
Mercado Libre > Looker Studio
Looker
Mercado Libre > Looker
Looqbox
Mercado Libre > Looqbox
Metabase
Mercado Libre > Metabase
Microstrategy
Mercado Libre > Microstrategy
Pentaho
Mercado Libre > Pentaho
Power BI
Mercado Libre > Power BI
Qlik Cloud Analytics
Mercado Libre > Qlik Cloud Analytics
Qlik Sense
Mercado Libre > Qlik Sense
Qlik
Mercado Libre > Qlik
QlikView
Mercado Libre > QlikView
Redash
Mercado Libre > Redash
Superset
Mercado Libre > Superset
Tableau
Mercado Libre > Tableau
BI TOTVS
Mercado Libre > BI TOTVS
Zoho Analytics
Mercado Libre > Zoho Analytics

Related on Kondado

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

Why Kondado?

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

shape-data-to-dashboards icon-data-multiple-destinations

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 →
shape-data-to-dashboards icon-data-multiple-destinations

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 →
shape-data-to-dashboards icon-data-dollar

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Frequently Asked Questions (FAQ)

Answers about visualizing Mercado Libre data in Pentaho automatically

How do I connect Mercado Livre to Pentaho using Kondado? ▼
Start by adding Mercado Livre as a data source in your Kondado account and authenticate your marketplace credentials. Then select Pentaho as your destination, choose the pipelines your team needs, and Kondado will begin replicating data on a configurable schedule.
What dashboards can I build in Pentaho with Mercado Livre data? ▼
You can build reports that track advertising ROI, daily item performance, order completion rates, and payment status across Mercado Pago. Many teams also combine store metrics with shipment data to monitor fulfillment efficiency and customer satisfaction.
How often does Mercado Livre data update in Pentaho? ▼
You choose the refresh frequency that fits your business, with options ranging from every five minutes to daily updates. This keeps your Pentaho reports current without manual exports, so your team always works with fresh marketplace insights.
Which KPIs should I track for my Mercado Livre store in Pentaho? ▼
Focus on metrics such as total visits from the Ads pipeline, stock availability from Items: stock, and conversion trends from Items: daily performance. You can also monitor order status, payment confirmations, and review ratings to spot opportunities for growth.
Are there pre-built report templates available for Mercado Livre? ▼
Yes, Kondado offers ready-made report templates to help you get started faster, including the Mercado Libre Looker Studio Report template. While this template runs in Looker Studio, you can use it as inspiration or build equivalent custom reports directly inside Pentaho.
Can I share my Mercado Livre Pentaho reports with my team? ▼
Absolutely. Once your data is in Pentaho, you can distribute reports to marketing, operations, and leadership using Pentaho’s built-in sharing and publishing features. Everyone stays aligned on the same metrics without needing access to the marketplace back office.
Do I need technical skills to replicate Mercado Livre data to Pentaho? ▼
No code is required to set up the connection or manage your data flows. Kondado’s interface lets business users select pipelines and configure updates visually, so you can focus on analyzing results instead of technical setup.
Can I send Mercado Livre data to other tools besides Pentaho? ▼
Yes, Kondado supports multiple destinations, so you can send your marketplace data to Power BI, Looker Studio, Google Sheets, BigQuery, or PostgreSQL in addition to Pentaho.

Try out all the features for free for 14 days