DB connect with a DB2 backend

[Former Member]

I am trying to create a manual datasource from a source system (DB CONNECT) which is DB2. However, I face the following problem:

1. Select the table all okay

2. Proposal - No fields are available from the table (all fields and table names are in upper case)

3. When I have a SQL Server backend the proposal tab provides a list of fields from the table

Can anyone assist with this

Thanks

[ChandranGanesan · Accepted solution]

Hello,

Have a look at this Note

SAP Note 523552 DB2/390: BW: DB-Connect

Also see

[Transferring Data with DB Connect|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b5c2ae5e40]

[Streamlining DB2 Connect for SAP|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/207c5c32-51ea-2a10-c7bc-bcfca74552d5]

[Configuring Systems for Remote Monitoring Using Remote Database Connections (DB2 UDB for UNIX and Windows)|http://help.sap.com/saphelp_nw04s/helpdata/en/c4/b5f88a4252e24e8aab40a956d571c8/frameset.htm]

[How to Transfer Data From AS400 to BW Using DB Connect|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b031fd32-f109-2a10-5486-ccddf1660ce5]

Thanks

Chandran

[Former Member · Accepted solution]

Thanks for this. Have referred to the links. However, not specific to my problem. Have awarded a couple of points anyway for all your effort

[Former Member · Accepted solution]

Hi Nitin,

From what I understood, you are trying to make a datasource on your dbconnect source system.

I think I have faced a similar issue, but not really the same and not with DB2. Anyways, do you see any fields in the "Fields" tab ? Because in my case I could see fields in the Fields tab and not fields in the Proposal tab.

There is another workaround using which you can create your datasource. Try using the tcode RSDBC instead of RSA1 for creating your datasource. However, this creates datasources of BW 3.x and we need to migrate them.

Quick Steps:

1. Goto RSDBC and enter your source system name (the one you have under DBConnect). Execute

2. Select the table/view of your interest and click on the Generate Datasource button on the top. Give application folder name so that it creates under proper app. component.

3. You will find this DS created as 3.x DS. Right click and say migrate. Selection option "With Export".

4. Now you have your DS ready to be used. If you notice, you wont find any fields in the proposals tab here and you will find only in the Fields tab. But it works perfectly alright.

Note : RSDBC creates DS with a default name which is suffixed with 6. If you want to change the name you need to do a right click and say copy. Give the name you require and activate.

Regards,

F-S

[Former Member · Accepted solution]

Hi Fahid,

I had to refer to SAP notes specific to the database system and than carry out translations for the data types. However, your suggestions especially the copy of the 6DB_* datasource were so helpful that at a minimum I would have to give you full points for them.

Just to confirm that nothing is visible in the proposal tab but the extract worked fine

All the best

Edited by: Niten Shah on Jun 11, 2008 1:01 PM

[Former Member · Accepted solution]

Hi!

Could you please share which notes do you refer?

Which translations helps with proposal, maybe data fileds?

Thanks!

[Former Member · Accepted solution]

Will answer to myself: resolve this by using upper case letters for DB user name in connection parameters for source system.