Discussion about this post

User's avatar
Peter Andrew Nolan's avatar

Hi Saurabh,

Yes, this is widely known and well known. Getting data out of "large operational systems" like ERPs and getting it into a state an AI can read it is very similar to creating a data warehouse. You have to do the ETL.

There is a new invention you might want to know about. It is now possible to create pseudo-dimensional views over the top of large operational systems. This reduces the possibilities of lossy joins and cartesian products.

It's not as good as a data warehouse, but it's much cheaper. These sorts of views will make it easier to feed AIs for training. It also makes it possible to query data from large operational systems via query tools.

The post has a full example with Microsofts Business Central which has 200K+ installed accounts.

Enjoy!

https://bida.ro/2025/12/30/bida0060-dimensional-models-over-business-central/

No posts

Ready for more?