Modern data infrastructures don’t do ETL

Businesses are 24/7. This includes everything from the website, back office, supply chain, and beyond. At another time, everything ran in batches. Even a few years ago, operational systems would be paused so that data could be loaded into a data warehouse and reports would be run. Now reports are about where things are right now. There is no time for ETL.

Much of IT architecture is still based on a hub-and-spoke system. Operational systems feed a data warehouse, which …

analytics architecture beyond businesses dashboards data database data warehouse etl hub nosql databases office reports software software development sql supply chain systems visualization warehouse website