Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to retrieve data from secondary database

Dear Firebds.

I wish to know, How i access a MS Sql Server data from to SAP, I do understand for the secondary database I am required dbcon table configuration, my problem is this I dont know the dbcon concept and establishing connection string between secondary db and SAP ABAP program through native sql. please help me to understand this problem. Any article, code, suggestion will be the reat help of mine.

thanking you.

Naim

Tags:
Former Member
Former Member replied

Hi naim,

1. for this u will also require help of basis team.

2. these are the steps.

a) make an entry in DBCON

b) make connection string

(on the physical application server,

so that it can connect to secondary database)

(this will be done by basis team,

in which, they will specify the

IP address of the secondary database server,

the DATABASE ID, and the port number)

c) then using open sql / native sql,

we can use the secondary database connection,

just like normal.

d) if we use open sql,

then there must be Y/Z table on

sap as well as secondary database,

and the field names , their type all should be identical.

regards,

amit m.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question