cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP help for UD connect

Former Member
0 Kudos

Hello Gurus,

I have a requirement in which I have to retrieve data from an external SQL database table into BW using an ABAP program.

The BW and SQL servers are connected by UD connect.

There are a number of suggestions in sdn, if it is a DB connect. But could not find any ABAP help for a UD connect.

Can you please suggest how to handle ABAP in this case.

Regards,

Nageswara

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I guess you can put ABAP in the Transformations Routines on BW.

UD Connect is a JAVA Stack,

http://sapport.blogspot.com/2008/06/bi-source-systems-db-connect-vs-ud.html

Former Member
0 Kudos

Hi Jo,

Thanks for the reply.

As it is a Java Stack, cant we use Native SQL like we do in the DB connect?

For example, the code goes like this in case of DB connect.

EXEC SQL.
  CONNECT TO 'MYCONNECTION'
ENDEXEC.

EXEC SQL.
  open c for
    SELECT * from
PVACCOUNTBALANCE2

ENDEXEC.

Former Member
0 Kudos

Not sure but have doubts you can do it.

DB connect, I believed, is a more SAP standard connection.

UD uses *.jar files to the integration.

I guess you need to try for yourself.

Answers (0)