Using HANA secondary credentials in combination with PostgreSQL remote source

539 Views Last edit Jul 02, 2020 at 01:34 PM 5 rev

Hi guys,

I want to configure a remote source in HANA 2.0 that connects to a PostgreSQL database. I've already set up the DP agent and registered it in HANA, as well as registrering the required adapter.

If I understand correctly from SAP documentation I would have to create a credential in HANA e.g. by executing the following statement (I do this on a test system for user SYSTEM):

CREATE CREDENTIAL FOR USER SYSTEM COMPONENT 'SAPHANAFEDERATION' PURPOSE 'test_name' TYPE 'SECONDARY' USING 'user=<postgre_db_username>;password=<postgre_db_password>';

Which is then stored in SYS.P_CREDENTIALS_.

Then I create the remote source selecting the adapter (PostgreSQLLogReaderAdapter) and agent name, hostname, port and database name, and finally the credentials mode, which I set to 'Secondary Credentials'.

If I now hit Create the system tells me: No secondary credentials are defined for this remote source. Do you want to set the credentials mode to "None" instead of "Secondary Credentials"?

I have no clue what I'm doing wrong and online documentation doesn't seem to be that extensive. Anyone can help me further with this?

Regards,

Niels