Skip to Content
-1

Connect External DB from HANA XSJS

May 07 at 11:13 AM

56

avatar image
Former Member

Hello Guys,

I've got a requirement to run SQL query on external DB from .xsjs service. Is it possible to establish a connection to external DB and run SQL query? Like we do in JAVA using JDBC.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sergio Guerrero May 07 at 04:23 PM
0

no this is not possible - the only way to accomplish something like this is if the external db has a webservice on top of it.. and you can invoke that service from xsjs via outbound connectivity

Share
10 |10000 characters needed characters left characters exceeded
Thomas Jung
May 08 at 02:09 PM
0

Although not specific to XSJS, you could use SDA and virtual tables to access a remote database from HANA SQL.

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

So will we be able to do POST operation on this external DB using SDA ?

0

INSERT and UPDATES? Yes via Virtual Tables.

0

is it SDA, or SDI (Smart Data Integration)?

0

I'm specifically referring to SDA - Smart Data Access.

0
0