Data Source Parameters - Open text, key value pairs

Ciaran

Scenario:

As it stands, when we create data sources (In Analytics Server or DV) we are limited by the fields that Oracle has provided. E.G Server, Username, Password, Token...

Note that when defining Data Sources on the weblogic server (for custom JAVA 3rd party drivers) we are presented with an open textbox where we can send the driver a list of key value pairs to be interpreted.

In DV for certified data sources like Snowflake we are limited to :

Connection Name, Description, hostname, Database Name, Username, Password and Warehouse.

What's required by users is an open text field which is sent to underlying driver to be parsed for valid key value pairs. Examples that are currently missing for Snowflake:

client_session_keep_alive, db, useProxy, proxyPort. (This is just a few, please refer to snowflake driver documentation)

Impact:

Even though Oracle has certified certain data sources, users are still not able to adopt as there are further parameters required.

Suggestion:

We would see the same capability that weblogic server has for data source definitions being available for Analytics Server (RPD connection pools) & DV as a huge advantage and an obvious choice.