SAP Analytics Cloud source : Snowflake datawarehouse Live connection

[mfoeken]

Hi,

Has anybody come across Snowflake datawarehouse as a source for SAP Analytics Cloud (SAC) live connection?

If yes,

1. Was APOS used as a connector between Snowflake and SAC? If no, what connector/adapter was used?

2. Was hierarchies from snowflake consumed as expected in SAC data model? Were you able to use live connection data models to stories and straight away use the hierarchies from snowflake in stories?

3. the date hierarchy. Was that created in snowflake and how did it behave in SAC via live connection? Were you able to get the SAC date functionalities? range/member , Current year/previous year, month etc.

4. Is there a way to merge SAC data models outside a story and use that object as a source for a story?

Regards,

Cleo

[mfoeken]

Hi Cleo,

With one of my our customers we are exploring using APOS Live Data Gateway (LDG) to connect in a live manner from SAP Analytics Cloud to Snowflake. Regarding question 2 and 3: i can't comment yet. Regarding question 4: no, you can't merge. You can use blending/linking or simply create a data model to combine your data in for instance snowflake and consume this as a single model.

Kind regards,

Martijn van Foeken | Interdobs

[former_member6443]

Hi Martin,

We leveraged SDI and wrote our own adapter using the development kit and then we had the could get live connectivity to Snowflake . Not pretty but this way we got the best of both the worlds HANA and Snowflake.

APOS was not an option for us.

Cheers

Afshin