Connect Tray to Superset: 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

Tray
Superset

Visualize Tray Ecommerce Data in Apache Superset

Kondado makes it simple to visualize your Tray ecommerce data in Apache Superset without writing code or managing complex infrastructure. Our platform creates a direct connection that replicates your store information on a configurable schedule, updating your dashboards automatically every 5 minutes, hourly, or daily based on your specific business needs.

Marketing and operations teams can finally access unified visualizations that combine customer behavior, sales performance, and inventory trends in one intuitive interface. You can track key metrics like conversion rates, average order values, and customer lifetime value without waiting for technical resources or dealing with manual data exports that quickly become outdated between updates.

Kondado connects Tray to Superset through a direct integration requiring no intermediate databases or coding, allowing business users to replicate 14 data pipelines including Orders, Customers, and Products on a configurable schedule ranging from 5 minutes to daily, enabling automated dashboard updates and near-real-time ecommerce analytics.

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

With your Tray data flowing into Superset, you can combine the Orders and Customers pipelines to analyze purchasing patterns and identify your most valuable buyer segments through automated visualizations. The Products and Sold Products pipelines enable you to visualize inventory turnover rates and identify which items drive the most revenue across different marketplaces and sales channels. By connecting these data sources, marketing teams can track campaign effectiveness through Discount Coupons usage while operations monitors Payment statuses and Order Details to optimize fulfillment workflows, reduce delays, and improve overall cash flow management for your ecommerce business.

Try out all the features for free for 14 days

Tray data available in Superset

14
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.

Try out all the features for free for 14 days

How to create Tray dashboards in Superset

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

1
Connect Tray as Data Source

Log into Kondado and select Tray from our available data sources, then enter your store credentials to establish authentication. Choose which pipelines you want to replicate, such as Orders, Customers, or Products, to define what data will be available for visualization.

2
Select Superset Destination

Choose Superset as your visualization tool to create a direct connection that sends your Tray data without intermediate databases. You can also send data to Power BI, Looker Studio, or Google Sheets if your team uses multiple tools.

3
Configure Refresh and Build

Set your preferred update frequency from 5 minutes to daily schedules, then start building custom dashboards in Superset using your replicated Tray data. Create visualizations that track sales performance, customer behavior, and inventory trends to drive better business decisions.

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

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

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

Frequently Asked Questions (FAQ)

Answers about visualizing Tray data in Superset automatically

How do I connect my Tray store to Superset using Kondado?
Start by selecting Tray as your data source in Kondado and authenticate with your store credentials. Then choose Superset as your destination to establish a direct connection that replicates your ecommerce data without requiring any intermediate databases or complex configuration steps.
What specific Tray data can I visualize in Superset?
You can replicate 14 different pipelines including Orders, Customers, Products, Sold Products, Payments, and Discount Coupons to build comprehensive dashboards. This includes detailed information such as order values, customer registration dates, inventory attributes, and transaction statuses across your entire ecommerce operation.
How often does Tray data update in my Superset dashboards?
You configure the update frequency based on your business needs, with options ranging from every 5 minutes to daily schedules. This automated refresh keeps your dashboards current without manual intervention, ensuring your team always works with the latest sales and inventory information.
Can I share Tray ecommerce dashboards with my team in Superset?
Yes, Superset allows you to share reports with stakeholders across your marketing, operations, and executive teams through user permissions and dashboard links. Your colleagues can view the visualizations without needing access to your Tray backend or understanding the technical replication process.
What business metrics should I track with Tray data in Superset?
Focus on combining the Orders and Customers pipelines to calculate customer lifetime value and repeat purchase rates, while using Sold Products to identify top-performing inventory. You can also monitor Discount Coupons effectiveness and Payment method preferences to optimize your marketing spend and checkout experience.
Do I need technical skills to replicate Tray data to Superset?
No coding or database management is required, as Kondado handles the entire replication process through a no-code interface. Business users can set up the connection in minutes and start building visualizations immediately without waiting for IT resources or writing API queries.
Can I combine Tray data with other sources in Superset?
Absolutely, Superset allows you to blend your Tray ecommerce data with information from other platforms like Google Sheets, BigQuery, or PostgreSQL for unified reporting. This enables comprehensive analytics that connect your store performance with advertising spend, CRM data, or financial records.

Try out all the features for free for 14 days