Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question