cancel
Showing results for 
Search instead for 
Did you mean: 

BW and BODS connectivity

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Prabhith
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Prabhith
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Prabhith,

Thanks for the details description. Got the idea about how to proceed.

Br, Arvind

Answers (0)