Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC DV to Snowflake using SSO

Needs Votes
246
Views
13
Comments
2»

Comments

  • User_SK2UI
    User_SK2UI Rank 3 - Community Apprentice

    I understand that we can pass Key Pair authentication when creating direction DV connection . But we are connecting to Snowflake via RPD . Can we pass Key-pair authentication value in connection string or not ?

  • Joseph Reed
    Joseph Reed Rank 1 - Community Starter

    For our connection to Snowflake in the RPD we have switched from using a username/password to using a username/PAT (https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) which will still be supported going-forward. After the PAT is set up in Snowflake, you would simply just replace your password with the PAT (it's just a long alpha-numeric string) in the RPD connection. The key-pair authentication doesn't really gain us anything in regard to our use case. OAuth will be the ideal solution.

  • Ciaran
    Ciaran Rank 4 - Community Specialist

    We're currently having PAT approach reviewed from a security perspective… I don't see how this would be acceptable given that it's still a shareable "Password" in another form.

    OAS in it's current state does not support OAuth and even at that I don't see how OAC it supports the configuration of encrypted key passwords.. still seems to be a gap.

    We're trying to configure a JDBC / ODBC based connections, this might be a good stepping stone.

    We really need Oracle to produce a guidance document / response to the Snowflake Situation.

    Full support of OAuth & Key Pairs for: Repository, Weblogic Console and Publisher based connections.

    Oracle really needs to enable plain open text key pair type configuration screen for all areas so we can configure data sources and connection drivers without being dependent on the GUI restrictions that current exist.