Skip to Content
avatar image
Former Member

How to consume external SQL data in NetWeaver Developer Studio / Eclipse

Hi All,

The scenario: We have a server with SAP NetWeaver PO running on HANA and a separate server with MS SQL. We are creating a BPM solution with forms(both visual composer and sapui5) and would like to populate drop-down lists in both Visual composer or a SAPUI5 app using data from the SQL server.

Limits: data migration is not possible; we cannot move data from the SQL Server to HANA.

What we have done: Published a web service using Visual Studio to IIS on the SQL Server exposing some SQL queries. We added both the SQL Server and web service to the "Data Source Explorer" view NWDS, but are unable to link a drop-down list to it:

How would you go about to consume the data from the SQL server within NetWeaver Developer Studio?

Kind Regards,


capture.png (6.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers