AI and integration on top of the systems you already have
I build AI, dashboards and automation on top of the systems a company already has, without replacing them: an ERP that cannot be modified, Excel spreadsheets, WhatsApp, corporate email, or health-insurance and tax-authority services. I read through whatever route is available, keep what is needed in a database of our own, and build on that copy. That is how I did it on CARS Control, on top of an automotive group’s ERP.
What is included
- Reading from an ERP without modifying it. On CARS Control, a SOAP client and SQL Server queries against the Manager ERP.
- A read cache of our own, so dashboards and AI do not load the system the operation depends on.
- Excel spreadsheet uploads, as in MED360 Presupuestos and the referral system at CCDM.
- Messaging and email: Meta’s WhatsApp and Twilio, email through Microsoft Graph, SendGrid or Amazon SES.
- Chilean health and payment services: IMED electronic insurance vouchers and Haulmer/TUU payment terminals in SuiteMedica, Webpay in Keeper, and Bionet sync in the Instituto Cardiovascular laboratory.
- Invoicing and connection to SII, Chile’s tax authority, as in HemoSuite and ICV OS.
- An AI module for asking questions about that same data.
How I work
- I agree with whoever runs the existing system on the route we read through and what stays untouched.
- I settle with the people using the dashboard how fresh each piece of data needs to be.
- The integration gets the most tests, because that is where things break without warning. CARS Control has 149 test files on Vitest.
- In production there is error monitoring and alerting, with Sentry on CARS Control.
Cases and products behind it
Frequently asked questions
Do I need to change my ERP to add AI?
Not necessarily. On CARS Control the ERP was neither replaced nor modified: the dashboard and the AI module work on a read copy of the data.
What happens if the existing system changes?
That is the main risk in any integration. That is why the integration has automated tests that run on every change, so a format change shows up in continuous integration rather than in a report with wrong numbers.
Can the new system write to the ERP?
It can, but that is a different problem: how and where writes happen has to be agreed with the system’s owner. CARS Control only reads from the ERP.
Which systems have you integrated with?
An ERP over SOAP and SQL Server, Excel spreadsheets, Meta’s WhatsApp and Twilio, email through Microsoft Graph, IMED electronic insurance vouchers, Haulmer/TUU payment terminals, Webpay, Bionet and SII.