Dashboards in minutes

Connect Tray 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

Connect Tray to Pentaho

Tray

Pentaho

How to visualize Tray data in Pentaho? Kondado offers a direct connection that lets you replicate your ecommerce information into Pentaho without technical complexity. Simply select Tray as your data source and Pentaho as your destination to start creating visual reports that help you track sales performance and customer behavior. Your data updates on a configurable schedule, ensuring your dashboards always reflect current business conditions.

available pipelines

328

extractable fields

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

Connect Tray now →

Try out all the features for free for 14 days

Marketing and operations teams can easily monitor discount coupon effectiveness, analyze newsletter engagement, and track order fulfillment status through intuitive visualizations that support faster decision making. With 328 fields available across 14 pipelines, you gain comprehensive visibility into your ecommerce operations without writing a single line of code.

Kondado connects Tray to Pentaho via a direct “Via Kondado” connection with no intermediate databases required, allowing business users to replicate 14 data pipelines including Customers, Orders, and Payments on update frequencies ranging from 5 minutes to daily.

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

Tray data available in Pentaho

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

available pipelines

328

extractable fields

∞

Auto-refresh

Available integrations

Customers

Includes information such as name, email, and registration date, along with modification date and last visit.

Discount Coupons

Contains details such as coupon code, creation date, and discount value, along with usage restrictions.

Newsletters

Presents information about the customer's email, newsletter status, and creation and modification dates.

Payments

Includes data on payment methods, status, and values of transactions made by customers.

Orders

Provides information such as order ID, order date, and delivery status, along with customer details.

Order Details

Includes detailed information such as order ID, billing address, and additional cart values.

Order Details: Mercado Livre

Presents data such as customer ID, estimated delivery date, and information about the purchased product.

Additional Product Information for Orders

Contains additional information such as product ID and product name related to each order.

Order Invoices

Includes data such as invoice ID and product CFOP, essential for accounting.

Order Transactions

Provides information on transaction status and values associated with each order made.

Products

Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.

Products (Kits)

Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.

Sold Products

Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.

Products: Variants

Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

Full docs on the wiki → Start free trial →

Try out all the features for free for 14 days

Combining Tray’s ecommerce data with Pentaho’s visualization capabilities opens new possibilities for business intelligence. By replicating your Orders and Order Details pipelines alongside Payments data, you can create comprehensive dashboards that reveal purchasing patterns and revenue trends. Analyze your Discount Coupons pipeline to measure campaign ROI and understand which promotions drive actual sales. Operations teams benefit from tracking Sold Products and Products data to optimize inventory decisions, while customer service managers can use the Customers pipeline to monitor registration trends and improve retention strategies. These insights help SMBs and agencies make data-driven decisions that grow their online business.

Try out all the features for free for 14 days

How to create Tray dashboards in Pentaho

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

Connect Tray as Data Source

Log into Kondado and add Tray as a new data source by entering your store credentials. The platform will identify all 14 available pipelines including Customers, Orders, and Payments for replication.

Select Pentaho as Your Destination

Choose Pentaho to receive your Tray data, or explore other visualization options like Power BI, Looker Studio, or Google Sheets depending on your team's preferences. The connection requires no intermediate databases, allowing immediate access to your ecommerce metrics.

Configure Refresh and Build Reports

Set your preferred update schedule ranging from every 5 minutes to daily, then build custom reports in Pentaho using your replicated Tray information. Your dashboards will stay current automatically based on the schedule you set, giving your team reliable insights for daily operations.

Access Tray 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

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 Tray data in other BI tools

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

Tray > Airtable

Tray > Alteryx

Tray > Amazon Quicksight

Tray > BIMachine

Tray > Cortex

Tray > Data Studio

Tray > Geckoboard

Tray > Grafana

Tray > IBM Cognos Analytics

Tray > Klipfolio

Tray > Looker Studio

Tray > Looker

Tray > Looqbox

Tray > Metabase

Tray > Microstrategy

Tray > Pentaho

Tray > Power BI

Tray > Qlik Cloud Analytics

Tray > Qlik Sense

Tray > Qlik

Tray > QlikView

Tray > Redash

Tray > Superset

Tray > Tableau

Tray > BI TOTVS

Tray > 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 Tray data in Pentaho automatically

How do I connect my Tray store to Pentaho without coding? ▼

Kondado provides a no-code solution where you select Tray as your data source and Pentaho as your destination. The platform establishes the connection for you, requiring no technical setup or database configuration from your team.

What Tray data can I visualize in Pentaho dashboards? ▼

You can replicate 14 different pipelines including Customers, Orders, Payments, Discount Coupons, and Newsletters into Pentaho. This gives you access to 328 fields covering everything from customer registration dates to product variants and transaction values.

How often does Tray data update in my Pentaho reports? ▼

You control the refresh schedule based on your business needs, choosing intervals from every 5 minutes to daily updates. This ensures your Pentaho visualizations stay current without overwhelming your system with unnecessary data transfers.

Can I track Mercado Livre orders from Tray in Pentaho? ▼

Yes, the Order Details: Mercado Livre pipeline specifically captures marketplace data including customer IDs, estimated delivery dates, and product information. This allows you to create unified reports that combine your direct sales with marketplace performance in one Pentaho dashboard.

What metrics should I monitor for my Tray ecommerce business in Pentaho? ▼

Focus on combining your Payments pipeline with Orders data to track revenue trends and transaction statuses. You can also analyze the Sold Products pipeline alongside Discount Coupons to measure which promotions actually drive inventory movement and customer acquisition costs.

How do I share Pentaho dashboards with my marketing team using Tray data? ▼

Once you build reports in Pentaho using replicated Tray data, you can distribute access through Pentaho's native sharing features. Your marketing team will see updated metrics automatically based on your configured refresh schedule, keeping everyone aligned on campaign performance and customer behavior.

Can I combine Tray customer data with order history in Pentaho? ▼

Absolutely, the Customers pipeline contains registration and visit data that links naturally with your Orders and Order Details information. This connection lets you visualize customer lifetime value, repeat purchase rates, and demographic trends that inform your retention strategies.

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

Connect Tray to Pentaho: Dashboards in Minutes

Get started for free

Tray data available in Pentaho

Available integrations

How to create Tray dashboards in Pentaho

Connect Tray as Data Source

Select Pentaho as Your Destination

Configure Refresh and Build Reports

Access Tray data in Pentaho 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