# Bom Controle + Databricks

> Move data into Databricks with Erathos. Sync data from Bom Controle with Erathos — an incremental, no-code pipeline with full observability.

Source: https://www.erathos.com/en/pipelines/bom-controle-databricks
Em português: https://www.erathos.com/pipelines/bom-controle-databricks

BomControle is a Brazilian ERP (Enterprise Resource Planning) system, developed to provide a complete, integrated business management solution, especially for small and mid-sized companies. Founded in 2015 and based in São Caetano do Sul, São Paulo, BomControle aims to simplify and automate administrative and financial processes, enabling more efficient, intelligent management.

With Erathos, you can integrate Bom Controle data into Databricks in just a few minutes. Our platform handles the entire data movement process into your lakehouse platform and enables this data to be joined with other sources. That way, your time goes to what truly creates value — surfacing insights and making data-driven decisions.

### Which Bom Controle data does Erathos sync with Databricks?

The integration automatically syncs the main Bom Controle objects:

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

### Why sync Bom Controle with Databricks?

In Databricks, you combine this data with Delta Lake for ACID transactions, time travel, and schema evolution. Data and ML teams get unified access through Python, SQL, and Spark — ideal for feature engineering, predictive models, and large-scale analytics.

### How it works

Erathos connects to Bom Controle 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 5 minutes to daily), the objects to sync, and the Databricks destination. Syncs use Delta Lake writes with configurable partitioning. You choose the sync frequency, the objects to sync, and the target schema. Every run is fully observable: runtime, rows processed, and alerts via Slack or email.

## Bom Controle data in Databricks in minutes

### Bom Controle Connector ready to use

Connect Bom Controle to Databricks and automatically export data. Centralize ERP data for analytics — no spreadsheets and no scripts.

### Full control over your pipelines Bom Controle

Configure schedule, frequency, and sync type at the table level. Configure frequency, sync type, and partitioning per table. Data lands in Databricks in Delta Lake—ready for ML, analytics, and ad hoc queries with predictable cost.

### End-to-end observability

Stop finding out about Bom Controle issues only when the business team complains. Every run is logged with run time, rows processed, and error context. Automatic alerts via Slack, Discord, or email as soon as anything deviates from expectations — keeping your data fresh for analysis.

## Centralizing data from Bom Controle in Databricks has never been this easy

Erathos is a data ingestion platform built for operations and data teams. With the Bom Controle connector, you automatically centralize inventory, products, and movements in Databricks — always up-to-date data, 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 Bom Controle to their data warehouse — with full observability into every run, zero maintenance, and none of the black box behavior of traditional market tools.

### What data from Bom Controle does Erathos sync to Databricks?

Erathos connects the main modules of Bom Controle to your Data Warehouse: finance, inventory, orders, customers, suppliers, and much more. Data is extracted incrementally, with no impact on operations.

### How often does Erathos sync data from Bom Controle to Databricks?

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

### What happens if a Bom Controle 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 Bom Controle connector?

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