Create an SAP Vora Remote Source - connection refused

[paweladamczak]

Hi Community, below you can find the steps taken to setup connection between SAP HANA system and SAP Vora being a part of SAP Data Hub installation. Unfortunately, it doesn't work, so I need to investigate what’s wrong with the setup.

I've used SAP Cloud Appliance Library to install SAP DataHub 1.4.

Here are the logs from Vora installation on Jump Box - I wanted to determine Hana wire port by checking the instance number of the SAP Vora cluster as configured in the Kubernetes cluster manager

Therefore, I manually unlocked HANA Wire port on Jump Box:

3.jpg(31.2 kB)

Then I tried to create remote source:

As a result, the connection is refused.

Any idea?

[JasonHinsperger]

Try checking out this support note:

https://launchpad.support.sap.com/#/notes/2711582

Your create stmt should look like this:

CREATE REMOTE SOURCE MyHanaWireConnection ADAPTER "voraodbc"
CONFIGURATION 'ServerNode=<server>:<hanawire-port>;Driver=libodbcHDB;sslValidateCertificate=false;encrypt=true'
WITH CREDENTIAL TYPE 'PASSWORD' USING 'user=<tenant>\<user>;password="<password>"';