Skip to Content
author's profile photo Former Member
0
Former Member

Creating DB link in SAP ABAP to retrieve data from external system

Posted on Dec 03, 2014 at 02:04 PM 1.5k Views

Hi gurus, Hope you all are fine. I have a requirement in which i have to retrieve data from external system database (Oracle) and then need to post it in SAP FI. I have never done this before. Can anybody tell me step by step how can i create DB link in SAP to access external system tables and what ABAP code need to write for it? Kindly guide step by step. I will much appreciate that.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Raymond Giuseppi
    Raymond Giuseppi
    Posted on Dec 03, 2014 at 02:11 PM
    2

    Look at tool as ADBC - ABAP Database Connectivity to execute SQL statement (OO substitute of native SQL statements), but first you need to actually connect database.

    This part is not related to Abap : For Information on a tool as DB connect, look at document DB Connect Architecture and reference note 323151 - Several DB connections with Native SQL. Not that Basis will be required to install some component to access a database type distinct from current one (An other manufacturer, e.g. access Oracle if SAP running on MS SQL)

    NB: You could also perform some search on UD Connect (uses Application Server J2EE connectivity)

    Regards,

    Raymond

    Add a comment
    10|10000 characters needed characters exceeded

    • Raymond Giuseppi Former Member
      Dec 04, 2014 at 03:55 PM

      TNS info should be copied into conn. info field. (Just press F1 on the field in the new entry dynpro od DBCO)

      Connection name Logical name of the connection

      DBMS ORA

      User name Oracle user

      DB password Password for the Oracle user mentioned above

      Conn.info TNS alias

      Permanent Should not normally be set for a secondary connection.

      AFAIK DBACockpit should not be required (but ask your basis too)

      If you define a structure (no actual database table required) with same definition it would be easier to map result of fetch data, but this is not mandatory. Else you have to map field by field in select statement. - Look at EXEC SQL documentation for SELECT and CURSOR / FETCH statements.

      Regards,

      Raymond

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.