# Tiny + PostgreSQL

> Centralize your data in PostgreSQL with Erathos. Sync data from Tiny with Erathos, an incremental, no-code pipeline with full observability.

Source: https://www.erathos.com/en/pipelines/tiny-postgresql
Em português: https://www.erathos.com/pipelines/tiny-postgresql

Tiny ERP is a simplified enterprise resource planning (ERP) system designed for small and midsize businesses, centralizing processes like sales, finance, and inventory.

With Erathos, you can integrate data from Tiny into PostgreSQL in just a few minutes. Our platform handles the entire data movement process into your open-source relational database and lets that data be combined with other sources. That way, your time goes to what really drives value — extracting insights and making data-driven decisions.

### Which Tiny data does Erathos sync with PostgreSQL?

The integration automatically syncs Tiny's main objects:

- **Orders and sales** — number, status, items, and amounts
- **Customers** — profile, purchase history, and balance
- **Products and inventory** — code, available quantity, and movements
- **Financials** — accounts payable, accounts receivable, entries, and balances
- **Suppliers** — profile, purchase orders, and commercial terms
- **Invoices** — issuance, status, and tax details

### Why sync Tiny with PostgreSQL?

In PostgreSQL, you retain full control over the infrastructure without cloud lock-in. Data stays accessible to any tool that speaks SQL — dashboards, apps, notebooks. Ideal for teams that want flexibility and operational data available directly in the application database.

### How it works

Erathos connects to Tiny via the official API and syncs your data incrementally — only new or updated records are processed on each run. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination schema in PostgreSQL. The sync uses intelligent UPSERTs to ensure data consistency even during reprocessing. You choose the sync frequency, the objects to sync, and the target schema. Each run is logged with full observability: execution time, processed rows, and alerts via Slack or email.

## Get Tiny data into PostgreSQL in minutes

### Tiny connector ready for use

Connect Tiny to PostgreSQL and automatically export your data. Centralize ERP data for analysis — no spreadsheets, no scripts.

### Full control over your Tiny pipelines

Set sync timing, frequency, and type at the table level. Configure sync frequency and type per table. Erathos uses intelligent UPSERT in PostgreSQL—ensuring data consistency even during reprocessing and preventing duplicates.

### End-to-end observability

Stop finding Tiny failures only after the business team complains. Every run is logged with execution time, processed rows, and error context. Get automatic alerts via Slack, Discord, or email as soon as something deviates from expectations — so your analytics always run on fresh data.

## Centralizing Tiny data in PostgreSQL has never been easier

Erathos is a data ingestion platform built for operations and data teams. With the Tiny connector, you can automatically centralize operational data and metrics in PostgreSQL — always up to date, with full observability into every run and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like Tiny to their data warehouse — with full observability into every run, zero maintenance, and none of the black-box behavior you get with traditional market tools.

### Which data from Tiny does Erathos sync to PostgreSQL?

Erathos connects Tiny’s core modules to your data warehouse: finance, inventory, orders, customers, suppliers, and more. Data is extracted incrementally, without impacting operations.

### How often does Erathos sync data from Tiny to PostgreSQL?

You can configure sync frequency anywhere from every 5 minutes to once a day, at the table level. Erathos uses incremental sync—only new or updated records are processed in each run, keeping the Tiny pipeline efficient and PostgreSQL costs predictable.

### What happens if a Tiny sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the Tiny connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect Tiny to PostgreSQL and start syncing right away — no credit card required.