From Tiny ERP to PostgreSQL: managed, scheduled, no code.
Creating a pipeline that sends data from Tiny ERP to PostgreSQL databases takes only a few minutes with Kondado. And the whole integration from Tiny ERP to PostgreSQL is managed and executed by our platform. With Kondado, you can focus on extracting value from Tiny ERP data and combining it with other data in your PostgreSQL database
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.
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
Replicated to PostgreSQL
Tiny ERP data available for PostgreSQL
Tables Kondado writes into your PostgreSQL, on a schedule you control.
15
available pipelines
792
extractable fields
PostgreSQL
Destination
Available integrations
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.
Sync data automatically — no code, no manual exports.
1
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.
2
Configure PostgreSQL Destination
Provide your PostgreSQL connection details including host, database name, and authentication parameters to designate where your replicated data should be stored.
3
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
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Tiny ERP data to PostgreSQL automatically
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.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
