Role in the Ecosystem

NetSuite is the authoritative source for all financial and operational data at Service Compression. Work orders, invoices, inventory, customer records, and financial transactions all originate here. It's the single source of truth for the business.

The Data Hub Pattern

Today, multiple tools call the NetSuite API independently โ€” competing for rate limits and sometimes getting inconsistent data snapshots. The Data Hub changes this: one system reads NetSuite, everything else reads from the Data Hub. This eliminates rate-limit conflicts and ensures all tools work from the same verified dataset.

What Data It Contains

Data DomainExamplesConsumed By
Financial Records General ledger, revenue, expenses, P&L line items Pennywise, Data Hub
Work Orders Corrective maintenance, preventive maintenance, field work Platform API, Ask Ricky
Inventory & Parts Parts catalog, stock levels, warehouse locations TrueCount, Data Hub
Customers & Contracts Customer records, contract terms, billing rates Pennywise
Assets Compressor units, hierarchy (company โ†’ region โ†’ area โ†’ unit) Platform API, Pennywise
Employees & Scheduling Employee directory, time entries, approval chains Hawkeye
Approvals Purchase orders, expense reports, work order approvals Hawkeye (via SuiteScript)

How It Connects

NetSuite data reaches the SC ecosystem through multiple paths (consolidating to the Data Hub over time):

NetSuite
โ†’
Data Hub (Airflow sync)
โ†’
All consumers
NetSuite
โ†’
Pennywise (direct API โ€” temporary)
NetSuite
โ†’
Hawkeye (SuiteScript)