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.
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
How to create VTEX dashboards in Pentaho
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
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.
2
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.
3
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.
Try out all the features for free for 14 days
Access VTEX 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!
Answers about visualizing VTEX data in Pentaho automatically
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.
'%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)