Connect Tray to QlikView: 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 Tray Data in QlikView with Automated Pipelines

Kondado makes it simple to visualize your Tray eCommerce data directly in QlikView without writing code or managing complex configurations. Our platform creates a direct connection between your online store and your analytics environment, allowing you to replicate the Customers, Orders, Payments, and other pipelines on a configurable schedule. You choose how often your data refreshes: every 5 minutes, hourly, or daily, ensuring your reports always reflect current performance.

Kondado connects Tray to QlikView through a Via Kondado connection, eliminating the need for intermediate databases or technical setup while keeping your reports updated automatically on your preferred schedule.

Business teams can finally combine sales data from Tray with other sources to identify trends, track marketing campaign effectiveness, and optimize inventory decisions. Marketing teams monitor customer acquisition through the Newsletters and Discount Coupons pipelines, while operations teams track fulfillment efficiency using Orders and Order Details data. With automated data replication handling the technical work, you focus entirely on analyzing performance metrics and making informed decisions to grow your online store.

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

Combining Tray data in QlikView unlocks powerful insights for online retailers. By analyzing the Orders and Sold Products pipelines together, you identify your best-performing SKUs and seasonal demand patterns to optimize inventory planning. The Payments pipeline reveals which methods drive the most revenue, while Discount Coupons data shows promotion effectiveness and customer retention rates.

Marketing teams leverage the Customers and Newsletters pipelines to segment audiences and measure campaign ROI, while finance teams use Order Invoices and Order Transactions to reconcile daily sales with bank deposits. This unified view transforms scattered eCommerce metrics into actionable intelligence for smarter pricing, stock management, and customer engagement strategies.

Try out all the features for free for 14 days

Tray data available in QlikView

available pipelines

328

extractable fields

Available integrations

Integration	Description
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.

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.

See all available data →

Try out all the features for free for 14 days

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 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 QlikView automatically

How do I connect my Tray store to QlikView using Kondado? ▼

Start by selecting Tray as your data source in Kondado, then authenticate with your store credentials. Choose QlikView as your destination and select which pipelines like Orders, Customers, or Payments you want to replicate. The Via Kondado connection establishes immediately without requiring database configuration or middleware setup.

What type of dashboards can I build with Tray data in QlikView? ▼

Create custom reports tracking sales performance, customer lifetime value, and inventory turnover using pipelines such as Sold Products and Order Details. You can build marketing analysis views combining Newsletters and Discount Coupons data, or financial reconciliation dashboards using Order Invoices and Payments information tailored to your specific business questions.

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

You configure the refresh schedule based on your business needs, choosing from every 5 minutes for near-real-time monitoring, or hourly and daily updates for standard reporting. This automated synchronization keeps your QlikView reports current without manual exports, ensuring your team always works with the latest order and customer information.

Which Tray metrics should I track for eCommerce growth? ▼

Monitor conversion rates by analyzing Orders against Customers data, track average order value using Order Details, and measure promotion effectiveness through Discount Coupons usage. The Payments pipeline helps you understand revenue patterns by method, while Sold Products data reveals your top-performing items and seasonal trends.

Can I share my Tray QlikView dashboards with my team? ▼

Yes, once your data flows into QlikView, you distribute reports to stakeholders across marketing, operations, and finance departments. Your team accesses the same current Tray data simultaneously, enabling collaborative decision-making without exporting spreadsheets or sending manual updates.

Do I need technical skills to replicate Tray data to QlikView? ▼

No coding or database expertise is required to establish the connection. Kondado handles the technical replication process automatically after you select your desired pipelines from Tray. The no-code setup means business users can configure data flows independently without waiting for IT support.

Can I combine Tray data with other sources in the same QlikView reports? ▼

Yes, you can replicate data from multiple sources into QlikView to create comprehensive business reports alongside your Tray store metrics. Connect Google Sheets for marketing campaign data, BigQuery for historical analytics, or PostgreSQL for custom application data, then blend these with your Tray Orders and Customers information for complete operational visibility.

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 QlikView: Dashboards in Minutes

Get started for free

Visualize Tray Data in QlikView with Automated Pipelines

Tray data available in QlikView

Available integrations

How to create Tray dashboards in QlikView

Connect Tray as your data source

Select QlikView as destination

Configure refresh and build reports

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