Live connectivity to Snowflake from SAP Analytics Cloud

 

SnowflakeAPOS Administrator Sales InquirySAP Analytics Cloud

 

APOS Live Data Gateway enables SAP Analytics Cloud users to consume live Snowflake Data Cloud data, and to easily self-serve through existing APOS semantic layer views. Users can also conveniently define their own semantic layer views and freehand SQL queries against Snowflake Data Cloud data, all while respecting Snowflake security structure and schema. Special features for Snowflake allow APOS Live Data Gateway to handle and respect Snowflake roles while minimizing and automating administration and maintaining Single Sign On (SSO) between Snowflake and SAP Analytics Cloud.

Connect live to Snowflake Data Cloud data for SAP Analytics Cloud (SAC) business intelligence users with the APOS Live Data Gateway solution. This fully live data access allows SAP accounts to efficiently unlock greater value from their Snowflake Data Cloud data, yielding better and faster business analytics and decisions.

Why Snowflake + APOS for live connectivity from SAP Analytics Cloud? SAP Analytics Cloud does not have built-in support for a live connection to Snowflake.

 

Fast, efficient, and transparent live data access to
valuable Snowflake Data Cloud data from SAP Analytics Cloud

 

Unified Data Connectivity

Leverage existing Snowflake security

Control and govern what Snowflake Data Cloud data is exposed through a focused Single Sign On (SSO) integration from SAP Analytics Cloud into Snowflake, creating mapping between SAC IDP SAML users and Snowflake users through OAuth. Snowflake roles are respected, and administration is minimized and automated.

Universal Semantic Layer

Data stays in Snowflake

With a live connection to SAP Analytics Cloud, analytics processes work directly with the Snowflake environment, so that replicating data outside of Snowflake is not needed. Snowflake's powerful data processing engine is used to deliver very high-speed processing of live queries, performance tested with over a billion rows of data.

Governed Data Connectivity

Snowflake Data Cloud data is always current

Live data is always current, with no data replication or data latency. Live Data Gateway works with Snowflake’s powerful data processing engine to efficiently access and serve large and growing data environment scenarios.

Governed Data Connectivity

Unified Semantic Layer

Snowflake data is presented in business terms to the business user to enable self-serve and ad hoc consumption of Snowflake Data Cloud data and broad dissemination of information from Snowflake to business users. The Snowflake schema is easily read by the semantic layer to help the users generate business-friendly views of the data.

Self-Service Data Modelling

Leverage existing data modelling

Easily build and share views on your data for agile data modelling. Since the Snowflake security structure and schema are maintained, there is no need to rebuild row level security or data structures.


 

Performance with Very Large Datasets

Snowflake Data Cloud presents power and scalability, and APOS Live Data Gateway presents the live data connectivity and unified semantic layer organizations need to use large data sets from Snowflake in SAP Analytics Cloud analytics solutions.

Watch this demonstration to see how easy APOS Live Data Gateway makes connecting to and querying a Snowflake Data Cloud of over 288 billion rows (10.5 TB dataset) with results in under 2 seconds.

.


"Push" Import for SAP Analytics Cloud Planning

APOS Live Data Gateway's ETL feature gives you the ability to "push" data from non-SAP data sources for import to SAP Analytics Cloud on a scheduled basis without the need for the SAC Cloud Connector. Load SAP planning data from sources such as Salesforce, Exasol, Workday, Microsoft Dynamics, etc.
See full details

 

APOS Live Data Gateway ETL

Overview of Live Data Gateway


WR Grace


The customer used this implementation of APOS Live Data Gateway between SAP Analytics Cloud and legacy data in Snowflake Data Cloud as a test case for moving current data from legacy data assets to Snowflake. They were well pleased with the performance of the APOS solution, as well as the self-serve analytics capabilities and data governance provisions.

WR Grace

Retailer Success Story with APOS Live Data Gateway for SAP Analytics Cloud with Snowflake Data Cloud

 

High-performance, live data connectivity between SAP Analytics Cloud and Snowflake Data Cloud - Read more


Extensive Data Source Support

APOS Live Data Gateway serves data with speed and consistency from an extensive range of relational, OLAP, Hadoop and Cloud sources.
See the full list of over 150 supported data sources

Extensive data source support


 

Thought Leadership

 

Pic
MIND THE GAP: Expanding Data Access Options to Open SAP Analytics Opportunities
Whitepaper

Expand and transform data connectivity to include all pertinent data sources in your Analytics.

View now

Pic
Unlocking the Value of Data with APOS Live Data Gateway
Futurum Research
Infosheet

Leveraging data is an imperative, but we also know that it has its challenges, such as managing data from disparate sources.

View now

Pic
Leveraging Data Connection Gateways to Harness Full Value from Analytics Investments
SAPinsider Research
Market Insight

SAPinsider's Kumar Singh describes the critical role of analytics in digital transformation.

View now

Pic
Expand, simplify and unify your data connectivity
SAP
Infographic

94% of organizations need access to multiple data sources to support effective decision-making.

View now

 


 


Data Connection Architecture

APOS Live Data Gateway Architecture

 

Live Data Connectivity & Data Consumption Methods

Live Data Gateway Functional Layers:

Data Virtualization Layer

Data Virtualization Layer

The Data Virtualization layer of Live Data Gateway is the connection point into the many data sources that are supported - Cloud Data, Relational Data, OLAP Data, Hadoop Data, Applications (On-Premise and Cloud).  All connectivity is managed through this single virtualized data connection point, meaning that no database drivers or other connections mechanisms are required by any consuming application or user environment, instead Live Data Gateway manages all of these connection details.  The primary connection protocol is JDBC, however connection via OData, XMLA, JSON, REST, and API is also supported.

Data Preparation Layer

Data Preparation Layer

The Data Preparation Layer of Live Data Gateway enables important data transformation steps, and provides a simplified semantic layer for business users to easily navigate data and be shielded from the complexities of the underlying data structures.  This semantic layer produces very strong benefits for both self-service analytics and self-service modelling.

Within the semantic layer, data views are created which define what data should be exposed, define measures and dimensions, manage data linking complexities, and rename data fields to meaningful business terms.  With these data complexities managed centrally, the end users of the semantic layer can quickly and easily build reports and visualizations, all while the strong data control and governance mechanism is protecting against inappropriate data access.

Three types of data views can be utilized within the Data Preparation Layer:

    • Semantic Layer View – non-technical users can select tables and fields and joins in APOS Live Data Gateway’s Web UI
    • Freehand SQL View – technical users can create views based on SQL queries in APOS Live Data Gateway’s Web UI
    • OLAP View – create a subset of existing measures and dimensions from an OLAP cube data source in APOS Live Data Gateway’s Web UI
Data Consumption Layer

Data Consumption Layer

The Data Consumption layer enables the communication of data requests into Live Data Gateway and the serving of the requested data. The simplified view into your data created in the data preparation layer allows for consumers to easily understand the data in business terms. Being able to consume data presented in business terms is a strong enabler of self-service. The semantic data of Live Data Gateway is served for consumption by SAP Analytics Cloud through the SAP Native protocol, but can also be consumed via OData, JDBC and ODBC.

 

 

 


APOS Administrator DetailsAPOS Administrator Sales InquiryAPOS Administrator Free Trial

See our case studies and customer stories

 

 

You are in good company

Some of the hundreds of organizations using APOS well managed BI solutions across the globe:

University of Pittsburgh Medical CenterAPOS Live Data GatewayEnergy NorthwestAPOS Live Data GatewaySalling GroupAPOS Live Data GatewayBlue Cross Blue Shield Kansas CityAPOS Live Data GatewayHarvey NormanAPOS Live Data GatewayUniversity of Miami