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.

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.

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.

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.

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.

.

Overview of Live Data Gateway

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

Data Connection Architecture

close ×

APOS Live Data Gateway Architecture

Live Data Connectivity & Data Consumption Methods

Live Data Gateway Functional Layers:

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

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

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.