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?