UDC vs DB Connect for DB2

[former_member584656]

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

[Former Member]

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]

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

[Former Member]

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]

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.