Data Sources
The EFX platform integrates data from four sources, each serving a distinct purpose in the import intelligence pipeline.
PostgreSQL (ERP)
Ecosys SRM/ERP database hosted on DigitalOcean Managed PostgreSQL. 87 tables covering purchase orders, suppliers, shipping windows, landed costs, transit times, and product catalog. Normalized schema with soft deletes.
87 tablesAirtable (CRM)
Business CRM with customers, sales orders, contracts, inventory, forecasts, and pricing data. 58 tables with 2,455 computed fields. The primary source for customer-facing data and sales analytics.
58 tablesDatamyne
US Maritime Import data via the Visual Datamyne API. Bills of lading, consignee/shipper records, HS code classifications, and trade route volumes. 7 HS codes tracked across palm oil derivatives. Cached 24 hours.
BOL recordsUSDA / Web Research
USDA MPR DataMart API for dairy component prices (Reports 2991, 2989). Claude Sonnet 4.6 with web_search for commodity pricing, trade policy, and market news. Cached 30 days (USDA) and per-month (research).
Live APIsDeep Dives
Current State Assessment
Side-by-side analysis of PostgreSQL and Airtable — what each system does well, where they overlap, and orphan audit results.
Architecture Options
Four integration paths compared — from ad-hoc scripts to declarative sync to full consolidation.
Analysis Tools
Schema analysis pipeline, snapshot diffs, orphan audit, and auto-generated reports.
Data API Reference
29 REST endpoints across 7 groups — the centralized layer that agents use to access all data.