How to retrieve data from secondary database
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.
Amit Mittal replied
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.