Core Technology | texlytics

03/07/ 2026

We spent a year building a data platform. Here’s what AI can finally do with it.

This article was originally published on LinkedIn and is archived here on texlytics.com. Most construction firms that say they want “AI” don’t have data that AI can use. The accounting system doesn’t talk to the project management tool, half the operational truth lives in spreadsheets, and the same vendor is spelled three ways across three systems. Point the fanciest model on the market at that, and it will confidently produce nonsense — because it’s learning from a mess. So before any of what follows, the boring part. We…

26/06/ 2026

Stop Writing One Pipeline Per Source

This article was originally published on LinkedIn and is archived here on texlytics.com. Every data engineer hits this moment. You’ve integrated three systems, you’re proud of it, and then a fourth source shows up. So you do what you did the last three times: copy the previous notebook, find-and-replace the table names, tweak the date logic, adjust the pagination, ship it. It works. You now have four notebooks that are 80% identical and 20% subtly different — and that 20% is where every future bug will live. Then…

19/06/ 2026

The Bug That Reported Success

This article was originally published on LinkedIn and is archived here on texlytics.com. One of our customers didn’t exist. Not deleted, not archived — simply absent. A real company, with real invoices, that should have been sitting in our analytics layer like everyone else. It wasn’t. And the system responsible for bringing it in had run cleanly every night for weeks. Green checkmark after green checkmark. No errors, no warnings, no failed jobs. The whole time, it was quietly wrong. This is a story about why the bugs…

12/06/ 2026

Our ERP’s API returned different results for the same query. Here’s how we dealt with it.

This article was originally published on LinkedIn and is archived here on texlytics.com. Run the query at 9:00 AM. You get 4,812 rows. Run the exact same query at 9:01 AM. You get 4,797. Run it a third time and you get 4,812 again — the exact count you started with. Relief. Except that run is the most dangerous of the three, and I’ll come back to why. No data changed. No filter changed. Same endpoint, same parameters, same everything. Fifteen rows just evaporated, and they were different…

07/06/ 2026

How I Solved CMiC’s 429 Rate Limit Challenge

This article was originally published on LinkedIn and is archived here on texlytics.com. If you have ever built an integration against the CMiC Cloud APIs, you already know where this story is going. HTTP 429. Too Many Requests. Over and over. I pull CMiC ERP data into our Microsoft Fabric Lakehouse on a schedule, Bronze through Gold. The pipeline ran clean for months. Then one morning I walked in to find it already in full meltdown, runs failing on throttling across the board. Nothing had changed on our…

Category Core Technology