coding for DB connect

[Former Member]

Hi All,

I am new to SAP BW and trying to gather as much as I can when reading topics and looking to you all to gather the knowledge.

Can anyone tell me what is the ABAP code that needs to be put in place for DB connect. I am aware of the procedure , but have no idea of the preparation that needs to be done in BW and also the ABAP code that needs to be done.

Thanks in advance

Amit

[Former Member]

Hi Amit,

there is no ABAP coding to connect a database to BW.

regards

Siggi

[Former Member]

Hi Siggi,

Do we need to do anything on the sap bw to prepare the system for the DB connect. Can you go over the steps with me on the DB connect , i will appreciate that.

I was asked in an interview about the ABAP code that needs to be done for DB connect and I was completely thrown, so just can you throw some light on this topic.

Thanks

Amit

[Former Member]

Hi Amit,

I would recommend, that you start creating a new source system of type DB-Connect within rsa1. Then step by step, if you have questions which cannot be answered by the F1-help, ask them here in this forum and I and I'm sure all other guys will help you.

regards

Siggi

[Former Member]

it's very simple :

RSA1 -> SourceSystems -> right window RMB on SourceSystems -> Create ... -> Databasesystems -> type in the qualifier for your systemj in BW

On the next screen you can choose your Databasesystem and your User.

Type in the PIN twice and then the connection-Info, depending on your DBMS, b.e. for an ORACLE-System type in your Database-Connection you want out of your TNSNAMES.ORA.

Select afterwards your table/view, create a DataSource. Voilá, that's all.

A little hint. Don't forget synchronizing your connection on all your Systems (DEV, QAS, PRD), otherwise you'll waste a lot of time searching for this completely superfluos bug

Bye

Ralf