No-code pipeline · Tray → PostgreSQL

Send data from Tray to PostgreSQL

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 PostgreSQL: managed, scheduled, no code.

Creating a pipeline that sends data from Tray to PostgreSQL databases takes only a few minutes with Kondado. And the whole integration from Tray to PostgreSQL is managed and executed by our platform. With Kondado, you can focus on extracting value from Tray data and combining it with other data in your PostgreSQL database

Connect Tray now →

Send Tray Data to PostgreSQL Automatically

How to send Tray data to PostgreSQL? Start by connecting your Tray account to Kondado and selecting the specific pipelines you need from the 14 available data endpoints covering orders, customers, products, and payments. Kondado automatically replicates your eCommerce data to your PostgreSQL database on a configurable schedule, whether you need updates every 5 minutes, hourly, or daily. The platform handles all data transformation and loading, ensuring your PostgreSQL database stays synchronized with your Tray store operations without requiring manual exports or complex API development.

Kondado connects to Tray and replicates data from 14 pipelines including Orders, Customers, and Products to PostgreSQL on a user-configurable schedule, enabling automated data warehousing for eCommerce analytics.

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 PostgreSQL

Once your data arrives in PostgreSQL, you can analyze the Orders pipeline alongside the Customers pipeline to identify purchasing patterns and segment your audience based on buying behavior. Combine the Sold Products data with Discount Coupons information to measure promotion effectiveness and optimize your inventory strategy using standard SQL queries. With 328 fields available across 14 pipelines, you can build comprehensive reports that track everything from payment status to product variants, giving your agency or internal team complete visibility into store performance.

Try out all the features for free for 14 days

Replicated to PostgreSQL

Tray data available for PostgreSQL

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

available pipelines

328

extractable fields

PostgreSQL

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

Try out all the features for free for 14 days

How to send Tray data to PostgreSQL

Sync data automatically — no code, no manual exports.

Connect Tray to Kondado

Authenticate your Tray account in Kondado by providing your API credentials. Select from the 14 available pipelines you want to replicate, including Orders, Customers, and Products.

Configure PostgreSQL destination

Enter your PostgreSQL connection details to establish your data warehouse. Kondado will create the necessary schema structure to receive your Tray data and handle all data type mapping automatically.

Select pipelines and schedule

Choose specific pipelines such as Sold Products or Order Details and set your update frequency from 5 minutes to daily. Kondado will begin replicating data immediately and maintain your schedule automatically without further intervention.

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

How does Kondado replicate Tray data to PostgreSQL? ▼

Kondado uses direct integration to extract data from your Tray account and load it into your PostgreSQL database. You select which of the 14 available pipelines you want to replicate, and the platform handles the data transfer on your chosen schedule. The process requires no coding and maintains data consistency between your eCommerce platform and database.

What Tray data can I replicate to PostgreSQL? ▼

You can replicate data from 14 pipelines including Orders, Customers, Products, Sold Products, and Order Details. Each pipeline contains specific fields such as order IDs, customer emails, product variants, and transaction values. This gives you access to 328 fields covering your entire eCommerce operation from payments to inventory.

How often does Tray data update in PostgreSQL? ▼

Kondado updates your PostgreSQL database on a configurable schedule that you control, with options for frequent updates or longer intervals depending on your reporting needs. You can set different frequencies for different pipelines, updating Orders every 15 minutes while refreshing Products daily. This flexibility ensures your analytics reflect recent store activity without overwhelming your database resources.

Can I combine Tray data with other sources in PostgreSQL? ▼

Yes, you can replicate data from multiple sources into the same PostgreSQL instance to create unified analytics. For example, combine your Tray eCommerce data with marketing platforms or financial systems to get a complete view of your business. You can then send this consolidated data to Power BI or Looker Studio for visualization.

What format does Tray data take in PostgreSQL? ▼

Tray data arrives in PostgreSQL as structured relational datasets that mirror your selected pipelines, with each data endpoint becoming its own database object. Fields such as order dates, customer details, and product attributes map to appropriate PostgreSQL data types. This structure allows you to run complex SQL queries and joins across your eCommerce data immediately.

Do I need coding skills to set up the Tray to PostgreSQL connection? ▼

No coding is required to connect Tray to PostgreSQL through Kondado. The platform provides a no-code interface where you authenticate your Tray account and select your desired pipelines. Configuration takes minutes, and the automated replication begins immediately without writing API scripts or SQL import commands.

Can I visualize Tray data in Google Sheets after replicating to PostgreSQL? ▼

Yes, after replicating Tray data to PostgreSQL, you can connect your database to Google Sheets for simple reporting or BigQuery for advanced analytics. This flexibility lets you choose the right tool for your team's technical level while keeping the data centralized in PostgreSQL.

How do I handle Tray product variants in PostgreSQL? ▼

The Products: Variants pipeline replicates detailed variant information including attributes and IDs to PostgreSQL, allowing you to analyze product performance at the variant level. You can join this data with the Additional Product Information for Orders pipeline to see which specific variants drive sales. This granularity helps you optimize inventory and understand customer preferences for specific product configurations.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days