SQL Editor

[Former Member]

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?

[Former Member · Accepted solution]

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.

[Former Member]

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