Skip to Content
0

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

Mar 14, 2017 at 12:47 PM

49

avatar image

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,

Adriaan

capture.png (6.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers