Question:
BW 3.5 Receiving data from a RDBMS (likely dbconnect):
I am working for an aviation company where we are expecting to receive large number of records from flying aircrafts. Since the number of aircraft could be in thousands and data could reach 2 GB per flight, we must create ODSs dynamically. Firstly, a new ODS should be created for a new plane as the plane sends in first chunk of data. Secondly if an ODS reaches to a certain size, we would like to create a new one just so that the size wouldn't kill performance. Lastly we have to also store binary data in the ODS.
Any ideas? Clue or code for creating an ODS dynamically and not messing the BW system integrity. Also best way to deal with binary data in an ODS table.
I'll appreciate any ideas and examples of succesful implementations. Thanks a lot.
Answer:
The following BAPI should do it :
BAPI_ODSO_CREATE
Regards,
FCI