connecting 2 systems using 1 common database

[Former Member]

Hi,

we have a common database SQL server for SAP and .Net system.

Can we do a database link between these two systems??

Can we do directly get the values from .net tables and put into temp db and process from that temp db into SAP??

Is that advicable??Please help me.

Appreciate for the quick response.

krishna.

[Former Member]

Thanks.

[Former Member]

Hey,

You should use the .Net connector,

in order to execute RFC:

please read note 533055 and 506603

and check

there is a good documentation here:

https://websmp109.sap-ag.de/~form/sapnet?_SHORTKEY=00200797470000050068&;

p.s

you should mark the function module in se37, as RFC enable (remote function call)

[former_member193399]

SAP does not recommend having other database on the same SQL Instance where SAP database resides.

Are you trying to access this database in EP or from ABAP? Becuase in EP you can create a non-sap system and connect to a SQL database.

At the back end you can definitely write queries linking tables in two databases, but it is not a good practice in this scenario. Instead what you can do is, expose the data you want using a webservice and use the webservice to get the data in SAP (SOA/ESA ).

RT

[Former Member]

Hi there,

As per ur thread, i had an query,

I am also having a similar scenrio wherein have to receive data from a dot net application system,

can u pls suggest the possible ways of doing it without using any middleware like XI,

Its very urgent ,

thanks

Regards,

Pratibha