cancel
Showing results for 
Search instead for 
Did you mean: 

UDC vs DB Connect for DB2

former_member584656
Participant
0 Kudos

Hi,

I need to use transactional data from a DB2 on AS/400 as Datasource for BW3.5. Should i use UDC or DB Connect?, whats the difference?, do i need any configuration on AS/400 (db2) or just in BW?.

thanks a lot

JP

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Juan,

These are the Guidelines for your decision.

You should use DB connect when it's possible to do so. If it can not be used you can consider UDC (For DB connect table and field names have to be capital and it isn't the case with UDC, in addition, for direct access needs you can not use DB connect, then you can use UDC).

Hope it helps,

Sree

former_member584656
Participant
0 Kudos

...what do you mean with direct access ? I need to use DB2 as a Source System for master and transactional data.

Former Member
0 Kudos

Direct access refers to executing the queries in BW via UDC by accessing the data in the source system (without storing it in BW).

In your case, if you would like to store data in BW, both options are feasible.

Have you also looked at the DB connect documentation

http://service.sap.com/bi >infoindex> DB connect

Hope it clarifies,

Sree

Former Member
0 Kudos

If you have the JDBC driver for DB2 you should be able connect from using BW J2EE based UDC. There are some How to documents available on configuring UDC for BW 3.5 under service market place.

Thanks.