Establish connection from SAP HANA Cloud to Standalone Datalake?

[former_member721699]

Hello SAP Experts,

We are planning to reduce the memory footprint on my SAP HANA Cloud Instances. We have two SAP HANA Cloud Instances and I have created a new standalone Datalake. The Datalake is a standalone instance(NOT MANAGED INSTANCE).

I would like to establish a remote source connection from my SAP HANA Cloud Instances to the Standalone Datalake so that I can move the historical data to datalake.

Questions:

Is it possible to establish the connection between a Standalone Datalake and a SAP HANA Cloud Database Instance? Would like to know the steps to establish the connection.

[JasonHinsperger · Accepted solution]

Yes, you can use the HANA “CREATE REMOTE SOURCE” statement to create a connection to a standalone data lake instance. Here is an example:

CREATE REMOTE SOURCE TESTDL ADAPTER iqodbc 
CONFIGURATION
  'Driver=libdbodbc17_r.so;ENC=TLS{tls_type=rsa;direct=yes};Host=<host name>:443;'
WITH CREDENTIAL TYPE 'PASSWORD' USING
  'user=<USER>;password=<PASSWORD>';

Regards,

--Jason

[former_member721699 · Accepted solution]

Thanks Jason. The SQL worked. I am able to establish the connection now.