# Tiny + Redshift

> Integrate data into Redshift with Erathos. Sync data from Tiny with Erathos — an incremental, no-code pipeline with full observability.

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

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

With Erathos, you can integrate Tiny data into Redshift in just a few minutes. Our platform handles the entire data movement process into your AWS data warehouse and lets you combine this data with other sources. That way, your time is focused on what really drives value — uncovering insights and making data-driven decisions.

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

The integration automatically syncs Tiny's main objects:

- **Orders and sales** — number, status, line items, and amounts
- **Customers** — profile, purchase history, and balance
- **Products and inventory** — code, available quantity, and inventory movements
- **Finance** — accounts payable, accounts receivable, journal entries, and balances
- **Suppliers** — profile, purchase orders, and commercial terms
- **Tax invoice** — issuance, status, and tax data

### Why sync Tiny with Redshift?

In Redshift, you connect this data to the AWS ecosystem — QuickSight for dashboards, SageMaker for ML, and S3 as a staging layer. Columnar storage optimized for analytical queries at petabyte scale with predictable billing. Ideal for teams already running on AWS.

### How it works

Erathos connects to Tiny via the official API and syncs your data incrementally — only new or updated records are processed in each run. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination in Redshift. The sync uses incremental processing, which handles only new or updated records — keeping Redshift costs predictable. You choose the sync frequency, the objects to sync, and the destination schema. Every run is logged with full observability: run time, rows processed, and alerts via Slack or email.

## Tiny data in Redshift in minutes

### Tiny connector ready for use

Connect Tiny to Redshift and automatically export data. Centralize ERP data for analysis — without spreadsheets or scripts.

### Full control over your Tiny pipelines

Set the schedule, frequency, and sync type at the table level. Set the frequency and sync type per table. Incremental sync for Redshift — only new records are processed in each run, without reprocessing everything from scratch and with predictable AWS costs.

### 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 data from Tiny into Redshift 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 Redshift — with always up-to-date data, full observability for 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 Redshift?

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 Redshift?

You can set the 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 your Tiny pipeline efficient and Redshift 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 Redshift and start syncing right away — no credit card required.