Skip to Content
avatar image
Former Member

database link from SAP to legacy

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 28, 2010 at 05:48 AM

    Hi ,

    what is your target database?

    check this Note 555223 - FAQ: Microsoft SQL Server.

    and go through this discussion

    Accessing MsSQL Database from ABAP

    Regards,

    Suresh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

  • Jun 28, 2010 at 08:54 AM

    - 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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.