Skip to Content

Full automatic creation of open hub with SAP BW for 140'000 Tables

Sep 27, 2017 at 01:09 PM


avatar image
Former Member

Dear all,

We have a Entreprise Data Whare House with 10 TB of data and we need to export the data as flat file to some Hadoop Big Data Platform. The team use Open Hub to do the data extraction. The Open Hub creation require 1 day of work with click and drop per table (which contain between 100 and 200 variable). We have 2'000 to 140'000 table for which we need to create Open Hub. How can we fully automatize the creation of these Open Hub by using the SAP Meta Data ? Is there some SAP base code to do that or can we do it in C++? Shell or any other script ? I know from consultant that this was done 10 years ago but was not recommened. I can imagine since then than a robust solution exist.

Manual creation is not an option since too slow and we will have too many errors (experience from the past with 4 Open Hub created manually). Is there some new feature on SAP BW on Hana concerning the crearion of Open Hub.

Thanks a lot


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers