database link from SAP to legacy

[Former Member]

can we make database link from SAP to legacy(for java and .net application) to access the records or any access of views to legacy application ,please suggest if this requirement is possible .

[Former Member]

Hi ,

what is your target database?

check this Note 555223 - FAQ: Microsoft SQL Server.

and go through this discussion

Regards,

Suresh

[Former Member]

target database is oracle with the .net application ,need to connect the SAP underlying database ,plz suggest the steps.

[raymond_giuseppi]

- First configure the connection via [The DBA Cockpit |http://help.sap.com/saphelp_nw70/helpdata/En/f8/a70f51542d482ea1a9ea888824d586/frameset.htm]/[Monitoring of Remote Databases |http://help.sap.com/saphelp_nw70/helpdata/En/f4/740835a120425994ff926836c3800b/frameset.htm] - transaction DBACOCKPIT.

- Then via [Native SQL |http://help.sap.com/abapdocu_70/en/ABENNATIVESQL.htm] statements you can [EXEC SQL - CONNECT |http://help.sap.com/abapdocu_70/en/ABAPEXEC_CONNECTION.htm] and execute other SQL statement in your legacy database.

Regards,

Raymond

[Former Member]

Thanks for the response ,the requirement is that we have some views in SAP which needs to be accessed by other legacy sytem like java or .net application.Basicaly they require to fetch data from SAP R/3 views / Tables.can you suggest how to achieve this requirement.