cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Extracting data from Oracle Tables/Views by using DB Connect

Former Member
0 Kudos

hai

Im extracting data from Oracle views by using DB Connect .

1)So how i need to generate the datasource?

(Can i use RSO2 for that or some other steps).Please

tell me ?

2)I have so many special characters in my sourcedata.so

i can load until PSA(not into characteristic

datatargets).So what can i do ???

3)One field contains values like 23145 , 2444,7465 .

Error says that 'InfoObject' doesn't confirm the alpha

conversion exit.(Eventhough i make sure in Infoobject

maintanence screen ALPHA is in Conversion Routine).

So what can i do

pls tell me

txs

rizwan

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

hi Rizwan,

1. to create datasource, it's done in bw and not using RSO2, but transaction RSDBC,

mark the table/view from oracle row and click 'edit datasource', in next screen click 'generate datasource'.

2. try to maintain transaction RSKC in bw with ALL_CAPITAL

3. in transfer rules maintenance, scroll right to last column 'conversion' for that infoobject and mark the checkbox.

hope this helps.

Former Member
0 Kudos

generate datasource? see if this can help..

RSA1-> SOURCE SYSTEM-> SELECT YOUR SOURCE SYSTEM-> RIGHT CLICK-> GENERATE SOURCE SYSTEM.

Also check:

and OSS Notes: 518241

      • assign points if useful ***

Thanks,

Raj