How do I connect my Tray store to Microstrategy using Kondado?

Start by adding Tray as a data source in your Kondado account and enter your store credentials. Then select Microstrategy as your destination and choose which pipelines you want to replicate, such as Orders or Customers. The connection establishes immediately without requiring any database setup or technical configuration.

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

You can create custom reports showing sales trends from the Orders pipeline, customer acquisition metrics from the Customers pipeline, and product performance analysis using Sold Products data. Combine these with Discount Coupons information to measure promotion effectiveness and optimize your marketing spend based on actual transaction data.

How often does Tray data update in my Microstrategy reports?

You configure the update frequency based on your business needs, choosing intervals from every 5 minutes to daily updates. This keeps your reports current without manual refreshes, ensuring your team always works with the latest order and customer information for timely decision-making.

Which Tray metrics should I track for ecommerce growth?

Focus on key performance indicators from the Payments pipeline to monitor revenue trends, analyze the Order Details pipeline to understand cart values and shipping patterns, and track the Products pipeline to identify your best-selling items. These metrics reveal opportunities to increase average order value and improve customer retention.

Can I share Tray dashboards with my team in Microstrategy?

Once you build your reports in Microstrategy, you can distribute them to stakeholders across your organization using Microstrategy's native sharing features. This ensures everyone from marketing managers to operations directors accesses the same updated Tray data for aligned decision-making.

Do I need technical skills to set up the Tray to Microstrategy connection?

No coding or database knowledge is required to connect Tray to Microstrategy through Kondado. The platform handles the data replication automatically using a direct integration, allowing business users to focus on analyzing their ecommerce metrics rather than managing technical infrastructure.

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

Kondado lets you replicate data from Tray to Microstrategy without writing code or managing complex infrastructure. Simply connect your Tray store as a data source, choose Microstrategy as your destination, and start building reports with your ecommerce metrics. The setup takes minutes and requires no technical expertise, making it easy for marketing and operations teams to access their data.

Kondado provides a direct integration between Tray and Microstrategy, replicating your store data on a configurable schedule ranging from every 5 minutes to daily, with 14 available pipelines including Orders, Customers, and Products.

With automated updates keeping your reports current, you can track sales performance, customer behavior, and inventory trends directly in Microstrategy. This connection helps business teams make faster decisions based on up-to-date ecommerce data without waiting for developer resources.

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

Combining Tray’s ecommerce data with Microstrategy’s visualization capabilities gives you complete visibility into your online store performance. By pulling data from pipelines such as Orders, Sold Products, and Payments, you can create unified dashboards that reveal which products drive revenue, identify purchasing patterns across customer segments, and monitor transaction completion rates. These insights enable marketing teams to optimize campaigns based on actual sales data while operations teams track fulfillment efficiency and inventory turnover in near-real-time.

Try out all the features for free for 14 days

Tray data available in Microstrategy

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

How to create Tray dashboards in Microstrategy

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

Connect Tray to Kondado

Add Tray as a data source by entering your store credentials and selecting the pipelines you need, such as Orders or Customers.

Select Microstrategy as destination

Choose Microstrategy as your destination to start receiving Tray data automatically. You can also send data to Power BI, Looker Studio, or PostgreSQL depending on your reporting needs.