Experience with OAS or OAC above Snowflake ?

User_9F4QA

HI

I wanted to ask if any of the OAS or OAC developers/customers uses it above Snowflake ?

Is there a dedicated connector between them ? if not, what is the best way to do that ?

Thanks

Yossi

Benjamin Arnulf-Oracle

Hi Yossi,

Yes - we have many customers/developers using OAC on top of Snowflake.

We do have a dedicated connector for Snowflake Data Warehouse:

Please find the documentation here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-snowflake-data-warehouse.html#GUID-BA2D5623-D18F-47DD-B9B1-FF23C3DFDDAA

EzequielC-Oracle

Yes. It is available in OAS, too. Here is the documentation. Check the table under "Data Sources Supported for Use with Oracle Analytics Server" for Snowflake data source:

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-supported-data-sources.html#GUID-ABD97D54-6157-4287-BEF8-1B6B7D9EC6C2

This screenshot comes from OAS:

Ezequiel.

User_9F4QA

Thank you very much, Ezequiel (and Ben) for this info.

Much appreciated.

This is important to us, as we are about to start a POC using Snowflake and OAS.

Thanks!,

Yossi

EzequielC-Oracle

Hi Yossi,

Additionally, please look at the table under "Data Sources Supported for Use with Oracle Analytics Cloud" for additional information on using Snowflake.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/supported-data-sources.html#GUID-3702ABF9-F3D3-4924-B4F8-3A436349DF9E

It can be used in Data Visualization with Datasets and in a model (either using the online Semantic Modeler or the Model Administration Tool). Look at above link for more details and at the following link, too:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/manage-database-connections-modeling-data-model-administration-tool.html#GUID-3C8367BE-8CCF-4ECF-BD71-103C37F5C59A

Regards,

Ezequiel.

User_9F4QA

HI Ben,

Glad to hear!

Thanks for the information.

Is this connector available also for OAS (or will it be ) ?

Thanks a lot,

Yossi