No-code pipeline · Tray → SQL Server

Send data from Tray to SQL Server

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

From Tray to SQL Server: managed, scheduled, no code.

Kondado provides direct integration between Tray and SQL Server, replicating 14 available pipelines including Customers, Orders, Payments, and Products on a configurable schedule ranging from every 5 minutes to daily, with 328 total fields automatically mapped to your database schema.

Connect Tray now →

Tray to SQL Server: Automated Data Replication

Sending Tray data to SQL Server requires no coding when you use Kondado’s automated data replication platform. Simply select Tray as your data source and SQL Server as your destination, then choose which pipelines you want to replicate from the 14 available options. Kondado handles the technical complexity of extracting your eCommerce data and loading it into your Microsoft database on a configurable schedule that fits your operational requirements.

Once your data arrives in SQL Server, you can build custom reports, run complex queries, and combine Tray information with data from other sources to create comprehensive business intelligence solutions that drive decision-making across your organization.

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

Available Tray Pipelines for SQL Server

The Orders and Order Details pipelines deliver comprehensive transaction information directly into your SQL Server environment, enabling you to analyze purchasing patterns and customer behavior through complex SQL queries. With the Payments pipeline, you can reconcile financial data against other accounting systems stored in your database, while the Products and Sold Products pipelines allow you to track inventory performance and identify top-performing SKUs. This consolidated Tray data empowers you to build custom dashboards in Power BI or Looker Studio, create automated reporting workflows, and perform advanced analytics that combine your eCommerce operations with warehouse, marketing, and financial data already residing in SQL Server.

Try out all the features for free for 14 days

Replicated to SQL Server

Tray data available for SQL Server

Tables Kondado writes into your SQL Server, on a schedule you control.

available pipelines

328

extractable fields

SQL Server

Destination

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.

See all available data → Send Tray to SQL Server →

Try out all the features for free for 14 days

How to send Tray data to SQL Server

Sync data automatically — no code, no manual exports.

Connect Tray to Kondado

Authenticate your Tray account in Kondado by entering your API credentials to establish the data source connection and access your eCommerce data.

Configure SQL Server destination

Enter your SQL Server connection details and specify the target database where your Tray pipelines will be replicated and stored for analysis.

Select pipelines and schedule

Choose from the 14 available Tray pipelines including Orders, Customers, and Products, then configure your preferred update frequency ranging from every 5 minutes to daily.

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 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 →

Send data from Tray to other destinations

Tray > Looker Studio

Tray > Power BI

Other visualizations

Tray > Amazon S3

Tray > BigQuery

Tray > Excel

Tray > Google Sheets

Tray > MySQL

Tray > PostgreSQL

Tray > Redshift

Tray > SQL Server

Choose a tool to visualize your Tray data

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

Frequently Asked Questions (FAQ)

Answers about sending Tray data to SQL Server automatically

How does Kondado replicate Tray data to SQL Server? ▼

Kondado connects directly to your Tray account using your API credentials and extracts data from your selected pipelines. The platform automatically transforms this eCommerce information into the appropriate schema for SQL Server, then loads it into your designated database on your chosen schedule. This automated process eliminates manual CSV exports and ensures your database stays current with your latest Tray transactions.

What Tray pipelines are available for replication to SQL Server? ▼

Kondado offers 14 distinct pipelines from Tray, including Customers, Orders, Payments, Products, Discount Coupons, and Newsletters. Each pipeline contains specific fields relevant to eCommerce operations, such as order details, transaction values, and product attributes, totaling 328 available fields. You can select individual pipelines or replicate multiple data streams simultaneously to build comprehensive datasets in your SQL Server environment.

How often can I update Tray data in my SQL Server database? ▼

Kondado provides flexible scheduling options that let you replicate Tray data as frequently as every 5 minutes or as infrequently as daily, depending on your business requirements. You configure the update frequency during setup, and the platform automatically manages the extraction and loading process according to your timeline. This near-real-time capability ensures your SQL Server reflects current eCommerce activity without overwhelming your system resources.

What format does Tray data take when replicated to SQL Server? ▼

Tray data arrives in SQL Server as structured relational tables that mirror the pipeline structure, with appropriate data types for fields like dates, currencies, and text values. Kondado automatically handles schema mapping to ensure that Tray's eCommerce fields translate correctly into your Microsoft database format. The resulting tables integrate seamlessly with existing SQL Server data, allowing you to write joins and queries that combine Tray information with your other business datasets.

Can I combine Tray data with other sources in SQL Server? ▼

Yes, once Tray data resides in SQL Server, you can join it with information from any other data source you replicate using Kondado, such as additional eCommerce platforms or marketing tools. This consolidation enables comprehensive analytics that connect your Tray transactions with advertising campaigns, inventory systems, or financial records stored in the same database. Many users create unified reports in Power BI or Looker Studio that blend Tray orders with data from other business platforms.

Do I need technical skills to set up Tray to SQL Server replication? ▼

No coding is required to configure the connection between Tray and SQL Server through Kondado's interface. You simply authenticate your Tray account, provide your SQL Server connection details, and select which pipelines to replicate using the visual pipeline selector. The platform handles API complexities, data transformation, and schema management automatically, making the process accessible to business analysts and marketing teams.

Which SQL Server versions work with Kondado's Tray data source? ▼

Kondado supports various SQL Server editions including Standard, Enterprise, and Express versions, as well as Azure SQL Database and SQL Server running on cloud or on-premises infrastructure. The platform works with SQL Server 2016 and newer versions, automatically adapting to your specific license type and configuration. Whether you run SQL Server on AWS, Azure, or local servers, Kondado maintains compatibility across different deployment scenarios.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days