Error connecting Datasphere as a datasource in Snowflake

[Roberth_Reyes]

Hello,

We are trying to connect SAP Datasphere as a datasource in Snowflake, for this we are following these steps:

On Datasphere side:

1. Create a DB hana user in Datasphere space management.
2. Add the snowflake IP in the Datasphere's IP allowlist.
3. Add snowflake as a trusted origins in the app integration from Datasphere's system administration.

On Snowflake side:

1. Install SAP HANA JDBC driver (versión ngdbc-2.23.10).
2. Create a network rule with the hostname of Datasphere DB.
3. Configure the Secret to hold the credentials of Datasphere hana DB user.
4. Create external access integration.
5. Create a function to connect to datasphere.

After completing these steps, we make a select to one view created in datasphere with the expose for Consumption using the Function created in snowflake and we get the following error:

{ "ERROR": "com.sap.db.jdbc.exceptions.SQLInvalidAuthorizationSpecExceptionSapDB: [10]: authentication failed: Detailed info for this error can be found with correlation ID 'C72F4380CAAEB647B6A3F49747F9F11D'" }

Could anybody advise how to resolve this error?

Many thanks and kind regards.

SAP Datasphere #Snowflake