IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Snowflake jdbc connection in webMethods on-prem

  • 1.  Snowflake jdbc connection in webMethods on-prem

    Posted yesterday

    Hello Team,

    We are looking to establish jdbc connection with Snowflake with key pair authentication, unfortunately it is not working as expected, we have followed the instruction given in the documentation but still no luck, any one can help here?

    Doc ref - Generating a Pair of Key Based Authentication - IBM Documentation


    Error - Error encountered

    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Eric_SnowflakeConnector:sf_temp.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "net.snowflake.client.jdbc.SnowflakeBasicDataSource".
Cannot create connection because password is missing in DataSource properties.



    Below are my current setup :
    KeyStore Alias :


    user=demo_user;account=zercowp-mib82023.snowflakecomputing.com;warehouse=my_warehouse;db=my_database;schema=PUBLIC;role=demo_role;keyPairAuthN=true;private_key_file=C:/SoftwareAG/IntegrationServer/conf/privatekey.pem;

    Note my key doesn't have any passkey and it is not encrypted.





    ------------------------------
    Mukes Behera
    ------------------------------


Related Content