interface to another database

Former Member — Wed, 01 Aug 2007 09:47:32 GMT

Hi Gurus,

does anyone know if it is possible to pull data out of SAP directly into any other SQL-based database?

I know of course that you can write files in ABAP which can interact as an interface, but I do not know about an interface to SQL-databases.

We are using release 4.6c.

Thanks for any help.

Markus

Re: interface to another database

Former Member — Wed, 01 Aug 2007 09:50:40 GMT

Hi markus,

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.