Skip to Content
avatar image
Former Member

SQL Editor

Hi,

got a question on SQL editor.

when is this used, is it only used to connect to relational databases, am i right?

becuase as you know the best practice to connect to a SAP system is using RFC/ BAPI's instead of talking directly to underlying DB?

could someone please clarify?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 20, 2006 at 05:43 AM

    Hi Yogi,

    SQL editor comes into picture when a model is using BI JDBC connector to connect to any JDBC system.

    In this scenario you can directly talk to database tables, otherwise if you use normal JDBC connectivty in portal, you'll have to use stored procedures to talk to the JDBC tables.

    SQL Editor is related to JDBC systems, not SAP.

    Thanks in advance,

    Deep.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 19, 2006 at 10:48 PM

    ...and then there are hundreds of applications that do not run on SAP or other standard software vendors, but were built inhouse. There are often no RFCs or BAPIs available.

    Otherwise you are absolutely right: the recommended way is to access the data through RFCs or BAPIs

    Mario

    Add comment
    10|10000 characters needed characters exceeded