How to find Technical User mentioned during remote source connection step in SDI

[senthil17]

Is there a way to find the technical user mentioned in remote source connection and also who created a remote source subscription in a HANA to HANA SDI replication?

We tried the "select * from M_Remote_connections"  query, but the remote_source_user_name field is blank.

[xiaoming_wu]

For the remote source credentials, we can tell from DP agent log, do a connection test for the remote source, search in the DP agent log for something like below example for CamelJDBCAdapter Open remote source [remote_source_name]. Parameters: {localDriverFolder=, pds_use_agent_stored_credential=false, db_credential_user=token, url=, filename=, filepath=, dbname=, port=, driverClass=, dbtype=other, host=, servername=, db_credential_password=******, remote_source_name=} Different adapter might have different log information like above. There is no way for us to tell who start the subscription. But you can run the following query to tell the owner of the subscriptions.

SELECT O.OWNER_NAME, RS.REMOTE_SOURCE_NAME, RS.SUBSCRIPTION_NAME FROM OWNERSHIP O INNER JOIN remote_subscriptions RS ON O.OBJECT_OID = RS.SUBSCRIPTION_OID WHERE RS.REMOTE_SOURCE_NAME ='Remote_source_name'

Usually for XSC, owner is _SYS_REPO, for XSA, owner is **#OO