cancel
Showing results for 
Search instead for 
Did you mean: 

VB write to BW tables / ODS ?

Former Member
0 Kudos

Hello BW Experts,

How can Visual Basic application write to BW table / ODS. Is this possible?

Thanks,

BWer

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi,

I don't think that this is possible...what is your reqt though?

Former Member
0 Kudos

Recon of data from couple of databases is done in VB Applications and they are contemplating if its possible to directly write the data to BW Table / ODS. They want to avoid flat files.

I know that ascential datastage can directly write to ODS / table. Wondering if VB can also do the same thing. Can any application access the tables in the DB level and write to it? I heard once a custom table in BW was copied from QA to Dev system by a database level copy.

Suggestions appreciated.

Thanks,

BWer

0 Kudos

hi BWer,

you may try vb staging bapi, following link is zip file, include there are 'how to', sample code, etc.

https://websmp202.sap-ag.de/~sapidb/011000358700010881972001

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/350ac790-0201-0010-b887-fcb...

<i>...Your company wants to load data from various external (Non SAP) sources. You want to avoid the multi-step approach of transferring the legacy data first into a comma separated (CSV) or ASCII file, and subsequently uploading these files via the flat file interface into the BW system....</i>

and check this

http://help.sap.com/saphelp_nw04/helpdata/en/c7/dc833b2ab3ae0ee10000000a11402f/frameset.htm

hope this helps.

Former Member
0 Kudos

A.H.P u r 2 good.. many thanks...

Answers (0)