How do I set up VTEX as a data source in Kondado?

Start by adding VTEX from the data source catalog and entering your store credentials. Kondado will display the available pipelines so you can select the ones that match your reporting goals. The entire connection takes just a few minutes and requires no technical configuration.

What reports can I build with VTEX data in Pentaho?

You can build reports that track order status, monitor inventory across warehouses, and analyze coupon performance over time. Many teams also create logistics views that compare shipping estimates with actual delivery dates. These reports turn raw ecommerce information into visual stories that guide daily operations.

How often does VTEX data update in Pentaho?

You choose the refresh interval when setting up your data source, with options ranging from every five minutes to daily updates. This means your Pentaho reports can stay aligned with business activity without manual refreshing. The schedule can be adjusted at any time as your reporting needs change.

Which KPIs should I track using VTEX and Pentaho?

Popular metrics include total order value, stock availability by warehouse, and campaign conversion from the Marketing Data of Orders pipeline. You can also monitor average shipping time and coupon redemption rates. Pentaho makes it easy to visualize these numbers side by side for complete store performance visibility.

Are there pre-built VTEX reports I can use?

Yes, Kondado offers ready-made reports including the VTEX Power BI Report and VTEX Looker Studio Report. These reports display essential ecommerce metrics right away so you can start analyzing performance immediately. You can also send your data to Power BI , Looker Studio , or other tools if your team prefers a different visualization environment.

Can I share VTEX reports with my team in Pentaho?

Pentaho allows you to distribute reports to colleagues through scheduled emails or shared folders inside the platform. Once your VTEX data is connected through Kondado, everyone sees the same updated numbers. This keeps marketing, operations, and finance aligned on current store performance.

What VTEX pipelines are available for Pentaho reporting?

Kondado offers seventeen pipelines covering orders, stock, products, promotions, and logistics. You can select specific pipelines such as Orders, SKUs, and Payments to build focused reports. This flexibility lets you start with high-priority data and expand your Pentaho reports as your questions grow.

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

Visualize VTEX Data in Pentaho with Kondado

Kondado helps business teams turn VTEX store information into clear visual reports inside Pentaho without any technical complexity. You simply connect your VTEX account as a data source, choose the information you want to replicate, and Kondado keeps your Pentaho reports updated on a configurable schedule. Marketing and operations teams can then explore orders, inventory, and campaign performance through familiar views that support daily decision-making.

Kondado connects VTEX directly to Pentaho with no intermediate databases and no coding required, enabling business teams to build automated reports that stay current on a configurable schedule.

Once your data is flowing, you can create Pentaho reports that track daily revenue, compare promotional campaigns, and monitor stock availability without switching between platforms. The setup takes minutes, and updates continue automatically so your insights are always ready when you need them.

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

With Kondado, your Pentaho environment can bring together VTEX Orders, Stock, and Marketing Data of Orders to reveal patterns that drive smarter retail decisions. You might combine order totals with shipping timelines to identify delivery bottlenecks, or match stock levels with promotional campaigns to see which discounts actually move inventory. These connections help operations teams prioritize replenishment, help marketing teams measure campaign return, and help leadership understand daily revenue trends without ever requesting technical support or waiting for manual data preparation.

Try out all the features for free for 14 days

VTEX data available in Pentaho

available pipelines

432

extractable fields

Available integrations

Integration	Description
Coupons	Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.
Stock	Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.
Master Data	Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.
Orders	Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.
Shipping Data of Orders	Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.
Marketing Data of Orders	Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.
Order Details	Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.
Logistics Information of Orders	Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.
Order Items	Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.
Payments: Order Transactions	Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.
Orders: Fees and Benefits	Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.
Orders: Totals	Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.
Products	Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.
Promotions	Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.
SKUs	Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.
SKUs: Kits	Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.
SKUs: Prices	Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

Coupons

Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.

Stock

Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.

Master Data

Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.

Orders

Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.

Shipping Data of Orders

Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.

Marketing Data of Orders

Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.

Order Details

Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.

Logistics Information of Orders

Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.

Order Items

Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.

Payments: Order Transactions

Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.

Orders: Fees and Benefits

Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.

Orders: Totals

Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.

Products

Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.

Promotions

Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.

SKUs

Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.

SKUs: Kits

Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.

SKUs: Prices

Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

See all available data →

Try out all the features for free for 14 days

How to create VTEX dashboards in Pentaho

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

Connect VTEX as Data Source

Log into Kondado and add VTEX from the data source catalog by entering your store credentials. Select the pipelines you want to replicate, such as Orders or Stock, so your Pentaho environment receives the exact information you need.

Select Pentaho as Destination

Choose Pentaho from the destination list to establish a direct connection that sends your VTEX data straight into your reporting workspace. Kondado handles the transfer automatically, so there is no need for manual exports or intermediate storage.

Build Reports and Set Refresh

Open Pentaho to create visual reports using your refreshed VTEX data, then set your preferred update schedule from five minutes to daily. Your reports will stay current automatically, giving your team reliable insights for every business decision.