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.