Skip to Content
avatar image
Former Member

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

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

Fabien

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers