Data Sources
Tachapps connects to your existing production databases and historian systems to ingest real-time and historical data automatically.
Overview
Data sources are configured by an administrator and run scheduled sync jobs that pull new production records into Tachapps. You can have multiple data sources per project.
Production DB ──▶ Tachapps Connector ──▶ Tachapps Data Layer ──▶ Dashboard / API
Historian ──▶ ↑
CSV Upload ──▶────────┘Sync Schedule
Each data source has an independent sync schedule:
| Schedule | Cron Expression | Use Case |
|---|---|---|
| Real-time | */5 * * * * | SCADA / historian (5-min intervals) |
| Hourly | 0 * * * * | Daily allocations updated every hour |
| Daily | 0 6 * * * | End-of-day production reports |
| Manual | — | CSV uploads, one-time imports |
Data Mapping
Raw data from source systems must be mapped to Tachapps fields. The mapping editor lets you:
- Select a source column from a preview of your data
- Map it to a Tachapps field (e.g.,
oil_rate_bopd) - Apply an optional unit conversion (e.g., m³/d → bbl/d)
- Set a validation range to flag anomalous values
Standard Production Fields
| Tachapps Field | Description | Unit (Imperial) |
|---|---|---|
oil_rate | Gross oil production rate | bbl/d |
water_rate | Gross water production rate | bbl/d |
gas_rate | Gross gas production rate | Mscf/d |
bhp | Bottom-hole pressure | psi |
thp | Tubing head pressure | psi |
choke_size | Choke bean size | 64ths of an inch |
runtime | Pump runtime | hours/day |
Monitoring Sync Health
Navigate to Settings → Data Sources to monitor sync status:
- 🟢 Healthy — Last sync completed successfully within the expected window
- 🟡 Warning — Last sync succeeded but was delayed
- 🔴 Error — Last sync failed; see error log for details
WARNING
If a data source shows a red error status for more than 24 hours, contact your Tachyus support engineer as production data may be missing from dashboards.
Manual CSV Import
For ad-hoc data uploads:
- Navigate to Data → Import
- Download the CSV Template for your data type
- Fill in the template with your data
- Upload the completed CSV
- Review the validation summary and confirm
CSV Template Format
csv
api_number,date,oil_rate_bopd,water_rate_bwpd,gas_rate_mscfd
4201500123456,2025-01-01,450.2,1200.8,325.0
4201500123456,2025-01-02,448.7,1215.3,318.5