Data connectivity from SAP Analytics Cloud to specialized and premium data sources

SAP Analytics Cloud and SAP Data Warehouse Cloud

APOS Live Data Gateway Premium expands, simplifies, and unifies data connectivity and data consumption options for SAP Analytics Cloud and across the SAP solution landscape. With LIVE mode connection for SAP Analytics Cloud this middleware platform provides virtualized data connectivity which enables live-mode connectivity to data from strategic SAP applications, such as SAP Ariba, Concur, Fieldglass, SuccessFactors, and other Cloud applications or niche data sources.

SAP Ariba SAP Concur SAP FieldglassSAP SuccessFactors Cloud Applications through API

Live mode connection to premium data sources

Simplified self-service BI

A unified semantic layer removes the complexity of strategic SAP applications data structures, which enables easier report creation by a broader range of users

Data never leaves the firewall

Pre-built analytics extractions

Live Data Gateway provides predefined SAP applications data extraction options for fast time to value

Unified Semantic Layer

Optimized data access & processing

Minimize stress on the application system, while dramatically enhancing performance with optimized, efficient query responses for SAP Analytics Cloud and other consumers

Unified Semantic Layer

Aggregate multiple application sources

Leverage data combined from multiple sources blended into a single broad, enriched, comprehensive business view of your SAP application data

Unified Semantic Layer

Customizable analytics extractions

Expand on pre-built processes to customize data extractions using an interactive UI to explore SAP application data

Data never leaves the firewall

Governed self-service BI

The unified semantic layer also enables controls over what SAP application data is exposed to report creators


WR Grace


This APOS solution was extremely easy to deploy, simplifying the process of connecting to Google BigQuery and our other data sources. We were also pleased with live data connecting using the APOS Live Data Gateway because it kept all data within the corporate firewall for an added level of security.

Sunil Kumar, SAP Enterprise Architect
WR Grace

WR Grace

WR Grace Success Story with APOS Live Data Gateway for SAP Analytics Cloud

W.R. Grace established direct data connectivity in live mode to Oracle, SQL Server and Google BigQuery for more informed analytics - Read more


Performance with Large Data Sets

In today's data landscapes it is critical that there is strong processing performance for large and growing data environments including Cloud and Big Data platforms.  Live Data Gateway has been designed to thrive with such scenarios. See how the APOS Live Data Gateway performs with large data sets in Google BigQuery (196 million rows), and Snowflake (1.3 billion rows).


 

APOS Live Data Gateway Premium includes all of the features of APOS Live Data Gateway, plus these special features:

Optimize data access and processing

Data caching minimizes stress on endpoint API provider, while dramatically enhancing performance with optimized, efficient query responses for SAC and other consumers.

Live Mode with Caching

Frequent data caching updates allow current data access with no data acquisition limitations. Data as fresh as you want it.

 

 

Aggregate multiple application sources

View data combined from multiple sources into a single broad business view of your data.

Extensive data source support

Extensive Data Source Support

In addition to the strategic SAP application connectivity, APOS Live Data Gateway Premium allows access to an extensive list of data.
See the full list of over 150 supported data sources


 

WR Grace


This global customer needed to implement live data connectivity between their SAP Analytics and data from Microsoft SQL Server Analysis Services (SSAS) data cubes for comprehensive real-time reporting on their operations. APOS Live Data Gateway provided performant live data connectivity, ease of deployment and use, and real-time performance with current data from non-SAP sources.


WR Grace

Global Finance Success Story with APOS Live Data Gateway for SAP Analytics Cloud

Performant live data connectivity, ease of deployment and use, and real-time performance with current data from non-SAP sources - Read more


 


 

 

 

Overview of Live Data Gateway

Data Consumption Flow

Data consumption flow image


Data Connection Architecture

APOS Live Data Gateway Architecture
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, fields and joins to create a view in APOS Live Data Gateway’s Web UI
  • Freehand SQL View – technical users can create a view based on SQL queries in APOS Live Data Gateway’s Web UI
  • OLAP View – select a subset of existing measures and dimensions from an OLAP cube to create a view 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 through the SAP Native, OData, JDBC and ODBC protocols.

 

APOS Live Data Gateway for Ariba DetailsAPOS Live Data Gateway for Ariba Demo RequestAPOS Live Data Gateway for Ariba Free Trial

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