cancel
Showing results for 
Search instead for 
Did you mean: 

Exracting data from two tables existing in external database

Former Member
0 Kudos
46

Hi SDN friends,

I have 2 tables in external database system. I cannot create a view as I am using Netweaver Java Dictionary. I therefore would like to get the data on BI side & perform join there. TABLE1 & TABLE2 has many to many relationship.

<b>TABLE1</b> - FieldA, FieldB

<b>TABLE2</b> - FieldB, FieldC(texts)

Please help me find the best approach to populate the data into the BI infoobjects.

I assure I will give full points to anyone who replies.

Thanks,

Sunil

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sunil,

I m not aware of Java Dictionary..

But if you could fetch data in SAP BI then you can create views on table and by making use of generic data source based on tht view you could load BI obejcts.

Generic Data Source :RSO2..

Let me know if you need more clarifications..

Cheers

Sorabh

        • Assign points if i m help 2 u...***

Former Member
0 Kudos

Hi Sorabh,

Thanks for the reply. Sorry, but I didn't get you. How do I fetch this data for 2 tables into BI? You mean generated infoobject tables? or create some other tables(using SE11)? If I create my own, how will I extract data into them? Please help me understand with a little example.

Appreciate your time.

Thanks,

Sunil

Former Member
0 Kudos

Sunil,

I m not aware of Java Dictionary as you are saying..

I guess you can think of DBCONNECT.. how are you fetching data earlier into BI from your source system?

Look for documentatin on DBCONNECT or UDCONNECT...

Hope it helps...

Rgds

Sorabh

Former Member
0 Kudos

Hi Sorabh,

I am using UD connect & am able to get the data into two infoobjects(INFO1 & INFO2) using two infosources. I now want to join these infoobjects into a single infoobject..which I where I need help.

Thanks,

Sunil

Former Member
0 Kudos

Hi

If you are having data into 2 infoobjects, then its as good as having data nto tables. So now the question comes, whts the scenario?

You can use these twe infoobjects in ODS ..create update rule and so on....

Sunil, I m not able to understand further whts the problem you are facing exactly....

You want help with ODS or wht?

If you want to have join on infobjects then we can go ahead with infosets...

Plz expain problem so tht we can work ahead

Regards

Sorabh

        • Dont forgot to assign points in SDN -****

Message was edited by: Sorabh Arora

Former Member
0 Kudos

Hi Sorabh,

Let me explain again: I have two infoobjects INFO1 & INFO2. I want to combine them into a <b>single infoobject</b> containing <b>"Master data of INFO1" & "Texts of INFO2".</b> I am extracting INFO1 from table1, INFO2 from table2 using UDI.

Thanks for your time.

Regards,

Sunil

Former Member
0 Kudos

Hi Sunil,

1)You can create a view on master table of INFO1 and Text table of INFO2 and then create generic delta source to load into Target Single infoobject. You can use join in view if you want to.

2)You can create two data sources and two infosources for the INFO1 and INFO2 and use these to update target Single INFO object. In update rules map the objects as you want.

Hope it helps..

Regards

Sorabh

Former Member
0 Kudos

Hi Sunil,

ALso you can make infoobjectas infoprovider and generate export datasource for it.

use these datasources as said in above reply.

Hope it helps

Cheers

Sorabh

    • Assign points if it helps..***

Former Member
0 Kudos

Hi Sorabh,

Thanks for your quick reply.

I am trying the second method..but have some questions.

1. I created INFO1 & INFO2 and extracted the data into this.

2. Generated export datasource for both INFO1 & INFO2 called 8INFO1 & 8INFO2.

3. Created 2 infosources INF_SRC1 & INF_SRC2 & assigned it to datasources 8INFO1 & 8INFO2.

4. Created INFO3 & need to populate this now.

Am I correct till this point? If yes, please help me understand what do I do next.

Thanks again for your time & hep.

Regards,

Sunil

Former Member
0 Kudos

Sunil,

Now wht remians is to populate INFO3.

So create update rules for INFO3 and assign infosources for 2 and 3.

NOte there will be two update rules; one for INFO1 and other for INFO2.

Map the fields as you want.

I assume INFO3 contains relevant fields tht fields coming from INFO 2 and INFO1.

Hope its clear...

let me know if you need some help.

Cheers

Sorabh

      • Assign points if it helps***

Former Member
0 Kudos

Hi Sorabh,

Thanks for your reply. I will try your suggestion & get back to you if I have any questions.

Thanks again,

Sunil

Former Member
0 Kudos

Hi Sorabh,

Thanks for your reply. I have assigned your the points.

Thanks for the help.

Cheers,

Sunil