How does Kondado replicate Tiny ERP data to PostgreSQL?

Kondado connects directly to your Tiny ERP account using your API credentials to extract data from selected pipelines. The platform automatically loads this information into your PostgreSQL database on your chosen schedule, maintaining data consistency without requiring manual exports or technical maintenance.

What Tiny ERP data can I replicate to PostgreSQL?

You can replicate 15 different pipelines encompassing 792 fields, including financial records like Accounts Payable and Accounts Receivable, operational data such as Product Inventory and Orders, and customer information through CRM Issues and Contacts. Each pipeline contains specific fields relevant to ecommerce, retail, and service management operations.

How often does Tiny ERP data update in PostgreSQL?

Kondado updates your PostgreSQL database on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This near-real-time synchronization ensures your analytics reflect current business conditions while accommodating different data freshness requirements for various use cases.

Can I combine Tiny ERP data with other sources in PostgreSQL?

Yes, PostgreSQL serves as a central repository where you can consolidate Tiny ERP data alongside information from other business systems. You can replicate additional data into the same database from Google Sheets , BigQuery , or marketing platforms to enable comprehensive cross-platform analysis.

What format does Tiny ERP data arrive in PostgreSQL?

Data arrives as structured relational tables with standardized field names and appropriate data types for each pipeline, allowing immediate SQL querying. The schema preserves relationships between entities, such as linking Order Details to Products or Invoice Details to Accounts Receivable records.

Are there pre-built dashboards for Tiny ERP data in PostgreSQL?

Yes, Kondado offers ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report, which you can connect directly to your PostgreSQL database. These templates provide immediate visualization of sales performance, inventory levels, and financial metrics without requiring you to build charts from scratch.

Do I need coding skills to set up the Tiny ERP to PostgreSQL connection?

No programming knowledge is required to establish the connection or select your desired pipelines through Kondado's interface. The platform handles all API interactions and data transformation automatically, making PostgreSQL analytics accessible to business analysts and operations managers.

Send data from Tiny ERP 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

Send Tiny ERP Data to PostgreSQL Automatically

Sending Tiny ERP data to PostgreSQL requires no coding when you use Kondado’s automated replication platform. Simply select your data source, choose the specific pipelines you need from your ERP system, and configure your destination database. Kondado handles the extraction and loading processes on a configurable schedule, ensuring your PostgreSQL database stays updated with fresh sales, inventory, and financial records without manual intervention. This automated approach eliminates the need for manual CSV exports or custom API development, allowing your team to focus on analyzing data rather than moving it between systems.

Kondado provides direct integration between Tiny ERP and PostgreSQL, replicating data from 15 available pipelines including CRM Issues, Accounts Payable, and Product Inventory on a configurable schedule ranging from every 5 minutes to daily intervals, with 792 fields available for analysis.

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

With the Accounts Receivable and Accounts Payable pipelines, finance teams can build sophisticated cash flow models directly in PostgreSQL to track outstanding balances, payment histories, and aging reports across multiple time periods. The Product Inventory pipeline enables current stock level monitoring when combined with sales data from the Orders pipeline, allowing you to identify fast-moving products and prevent stockouts before they impact revenue. By having CRM Issues data available in your database alongside financial records, you can correlate customer support tickets with revenue impact and prioritize resolutions for high-value clients while analyzing service trends over time.

Try out all the features for free for 14 days

Tiny ERP data available for PostgreSQL

available pipelines

792

extractable fields

Available integrations

Integration	Description
CRM Issues	Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.
CRM Issues Details	Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.
Accounts Payable	Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.
Accounts Receivable	Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.
Contacts	Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.
Accounts Payable Details	Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.
Accounts Receivable Details	Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.
Invoice Details	Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.
Invoice Details: XML	Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.
Order Details	Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.
Product Inventory	Table provides information about inventory, including fields such as id, product name, and available quantity.
Invoices	Table contains details of invoices, featuring fields such as id, issue date, and customer name.
Orders	Table lists the orders placed, including fields such as order id, order date, and status.
Products	Table presents information about products, with fields such as id, name, and price.
Product Grid	Table provides a detailed grid of products, including fields such as id, description, and category.

CRM Issues

Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.

CRM Issues Details

Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.

Accounts Payable

Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.

Accounts Receivable

Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.

Contacts

Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.

Accounts Payable Details

Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.

Accounts Receivable Details

Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.

Invoice Details

Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.

Invoice Details: XML

Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.

Order Details

Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.

Product Inventory

Table provides information about inventory, including fields such as id, product name, and available quantity.

Invoices

Table contains details of invoices, featuring fields such as id, issue date, and customer name.

Orders

Table lists the orders placed, including fields such as order id, order date, and status.

Products

Table presents information about products, with fields such as id, name, and price.

Product Grid

Table provides a detailed grid of products, including fields such as id, description, and category.

See all available data →

Try out all the features for free for 14 days

How to send Tiny ERP data to PostgreSQL

Sync data automatically — no code, no manual exports.

Connect Tiny ERP Account

Enter your Tiny ERP API credentials in Kondado to establish a direct connection to your ERP system and authorize data extraction from your ecommerce and financial modules.

Configure PostgreSQL Destination

Provide your PostgreSQL connection details including host, database name, and authentication parameters to designate where your replicated data should be stored.

Select Pipelines and Schedule

Choose from 15 available pipelines such as Orders, Product Inventory, and Accounts Receivable, then set your preferred update frequency ranging from 5 minutes to daily intervals.

Try out all the features for free for 14 days