on 02-11-2013 11:21 AM
Hi,
I have a project where BW will act as source of data and BODS will be destination.Can anyone tell me how what is the best way to do this?
Br, Arvind
Hi,
Create a 'BW as source' datastore in BODS by giving the required BW server credentials.
Create a transformation to manpulate the data as per client requirements.
BODS as destination -- I din't understand it clearly.
You also need to create a target datastore also.
Create a job and include all the above objects and run the same.
Br
Prabhith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prabhith,
Thanks for reply. BODS as destination: This means I have to load data from BW to BODS and from BODS reporting will be done.
As per my understanding I have to create OHD's which will load data to Open Hub tables and after creating Data source in BODS I will take table as Open Hub.
Is this procedure ok?
Br, Arvind
Hi,
In BW side, create a OPH like below:
In BO side, create a BW as source Datastore after providing the necessary BW server credentials.
Then you will find the following options in which OPH tables option would alos be there.
Import the earlier created OPH in BODS by using the option Import by Name.
Now source s ready.
Now create a query transformation.
Drag a template table and connect the transformation to the same.
Hope this clarifies your query.
Br,
Prabhith
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.