Connection between Sql-server and ABAP

[Former Member]

Hi !

I need to select data from Sql-server tables to R3.

please tell me how to select the data?

thanks

moshe

[Former Member]

Hi !

It is possible to have a secundary database-connection from a SAP-System.

To make it work you'll need to customize the table DBCON.

For details see The online-help of the SAP "Open SQL" commands. There's a chapter for secundary database-connections.

Regards

Rainer

Some points would be nice if that helped a bit.

[Former Member]

Hi solman,

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.

[Former Member]

hi

good

go through this link

http://www.microsoft.com/technet/itsolutions/msit/operations/sql2005sap.mspx

thanks

mrutyun^