topic Re: Connection between Sql-server and ABAP in Application Development and Automation Discussions

Connection between Sql-server and ABAP

Former Member — Mon, 04 Sep 2006 14:05:20 GMT

Hi !

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

please tell me how to select the data?

thanks

moshe

Former Member — Tue, 05 Sep 2006 04:51:23 GMT

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 — Tue, 05 Sep 2006 05:47:05 GMT

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 — Tue, 05 Sep 2006 05:48:01 GMT

good

go through this link

thanks

mrutyun^