JCOManaged Data Pipeline Book a call

Your data in BigQuery, watched by a person, not a ticket.

Business Central, a database, a ticketing or payments platform. Landed in BigQuery every night in your own project, counts checked, fixed by us when it breaks.

Book a 30-minute call Per month$2,500
  • Runs in your own Google Cloud project
  • Row counts checked against the source
  • Cancel any month, no setup fee
Scroll

Built for sources like yours

Real engagements, anonymized. The same build, on your system.

Revenue reconciled across operations, billing, and bank.

Outcome$2.2M reconciled
Built asFinance reporting
Automated pipelines underneath, one number on top

An ERP in BigQuery every night, without a connector.

OutcomeNightly feed
Built asBusiness Central
OData with paging and retry, into the client's own project

Warehouse counts signed off against the source.

OutcomeRow counts matched
Built asMariaDB and MSSQL
Source and warehouse compared table by table, gaps listed

Fare and payments data landed on a schedule.

OutcomeScheduled pulls
Built asTicketing and payments
Vendor APIs, paged and retried within their rate limits

A failed run reaches a person, not a report.

OutcomeAlerts first
Built asFreshness checks
Every run logged, every miss flagged to a person

Warehouse tables opened straight in Excel.

OutcomeLive in Excel
Built asOData feed
Finance kept its spreadsheets, fed from BigQuery

The same stack, built many times over.

Outcome30+ companies
Built asData platforms
Finance, lending and operations teams on Google Cloud

You know the numbers.
We keep the feed running.

One system, the tables you name, landed in BigQuery in your own project every night. Code, IAM and runbook are yours from day one, so cancelling leaves a running feed.

Book a 30-minute call
Johnny Chen
Johnny Chen, CFA, FRM
CEO and Founder of JCO. 30+ companies, 100+ projects. Our team builds the feed and answers when it breaks.
Month one, then every month
  1. Name the system and the tables Your part One source, the tables you report from, and who gets the alerts. Week 1
  2. Open the source and the project Your part Read access to the system. A Google Cloud project in your name. Week 1
  3. First load, counts checked Every table in BigQuery, counts checked against the source. Weeks 2 to 3
  4. Schedule on, alerts on Nightly runs. A failed run reaches us first. Runbook handed over. Week 4
  5. Every month after One change request, one working session, a monthly run note. Monthly

What it takes

Read access
To one source system
$2,500
A month, cancel any month
Your project
Google Cloud, usage billed to you

What gets landed

Business Central
MariaDB and MSSQL
Fare and ticketing
Payments platforms
Vendor and partner APIs
Accounting systems
Into Excel and Sheets
Flat file drops

Bring one system.

Thirty minutes with our team. We work out whether a connector already covers your source, and which feed to start with. If it is not a fit, you will hear that on the call.