Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAS -DV-Snowflake JDBC connection- Parameter To Support Key Value Pairs

It would be helpful if we have a textbox as part of the connection definition screen that accepts free text to support key value pairs for correct driver/additional configurations.
Note: This is already available as part of the weblogic snowflake-Datasource definitions.
Current connection string Vs Expected connection string to establish connection from OAS DV to snowflake as follows:
Current connection string being used - jdbc:snowflake://XXXX.snowflakecomputing.com/?useProxy=true&proxyHost=XXXX&proxyPort=XXXX&db=XXXXX
Expected connection string- jdbc:snowflake://XXXX.snowflakecomputing.com/?useProxy=true&proxyHost=XXXX&proxyPort=XXXX&client_session_keep_alive=true&jdbc_query_result_format=json&db=XXXXX
================================
Weblogic snowflake datasource parameter declaration:
proxyHost=XXXX
useProxy=true
jdbc_query_result_format=json
client_session_keep_alive=true
database=XXXXX
proxyPort=8000
user=XXXXX
Comments
-
Recently our security teams are insisting that we need to use Key Value Pair authentication to connect to snowflake from OAC . Did Oracle make any progress of including parameters for Key-Value pair while configuring snowflake connection in OAC DV or in OAC RPD ?
0 -
Has there been any developments/comments on this issue. Apparently Snowflake are deprecating all username password authentication from November 25!
0 -
I completely agree.
I feel Oracle is behind the times on this one and is loosing more competitive advantages compared to other BI tools.
I also posted a similar message some time ago but took a more generic approach to the change for all data source definitions. (See below)
Why would Oracle restrict what can be done here.. let free the data source driver parameters and stop restricting… you cannot cater for all scenarios and changes. It's easier for Oracle and the customer gets what they want.
1