Is a data warehouse the best option to consolidate data into one location?

I am a director at a business enhancement solutions company that provides mechanical systems and distributes high-quality bearings and related products.

I am planning for b2b e-commerce. I have operations in Singapore, Malaysia, Indonesia, China, and Mongolia. Each country uses a different ERP. Singapore HQ uses JDE (one world), that was last implemented 20 years ago.

I intend to consolidate the data to one 'location' for the integration of data into e-commerce or e-marketplace. Is a data warehouse the best way to go? 

Thanks! I appreciate your help. 

22 Answers

author avatar

The idea of an EDW or enterprise data warehouse is the right path. That said, it's all about choosing the appropriate set of technology platforms and tools. Bringing together data from disparate platforms (you mentioned multiple ERP implementations) is not a trivial task and the choices you make for your EDW platform and the related data management tool will greatly affect your timeline, costs, and maintenance. Best of luck let me know if there is anything else we can do. Dave

author avatar
Top 10Real User

It depends on whom do you ask the question. I personally say, Yes, Absolutely required. If you wanted to combine the data from multiple systems. For sure it is definitely required.


Find out what your peers are saying about Snowflake Computing, Oracle, Micro Focus and others in Data Warehouse. Updated: November 2020.
448,542 professionals have used our research since 2012.