Stream non-SAP data into various SAP applications

(SAP HANA, SAP S/4HANA, SAP Data Warehouse Cloud, SAP Analytics Cloud Planning)

 

The APOS Live Data Gateway solution expands, simplifies and unifies your data connectivity for SAP Analytics Cloud.  This middleware platform provides virtualized data connectivity which enables live data connectivity to a vast range of non-SAP data sources. With Live Data Gateway, you can leverage the unique benefits of a live data connection in SAP Analytics Cloud including your valuable non-SAP data.


In addition to live connectivity to SAP Analytics Cloud, Live Data Gateway enables you to bring live data or import data into your various SAP data technologies such as SAP HANA, SAP S/4HANA, SAP Data Warehouse Cloud, and SAP Analytics Cloud Planning. Live Data Gateway simplifies these data movement requirements while unifying data access and data preparation steps for all consuming applications.


Expanded Live Data Connectivity

APOS Live Data Gateway for SAP Landscape includes all of the features of APOS Live Data Gateway, plus these special features:

 

Live data access

Live Data Access

Blend big data (Google BigQuery/Snowflake/Azure Datalake, etc.) into your business processes or analytics
View more

Import data

Import Data Access

Import data for use in your business processes or analytics
View more

SAP Analytics Cloud Planning

SAP Analytics Cloud Planning

Import data for SAP Analytics Cloud Planning


 

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).


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


 

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

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


Connecting the SAP Solution Landscape

In addition to SAP Analytics Cloud, the APOS Live Data Gateway expands, simplifies and unifies data connectivity to a large range of data sources, and consumption of that data (streamed or imported) by applications across your SAP solution landscape.

SAP Analytics Cloud

Stream or import data from a large range of available data sources to Data Warehouse Cloud. More about SAP Data Warehouse Cloud...

SAP Analytics Cloud

Stream or import data from a large range of data sources to SAP S4/HANA. More about SAP S4/HANA...

SAP Analytics Cloud

Stream or import data from a large range of data sources to your in-memory data platform. More about SAP HANA...

 


 

 

 

Overview of Live Data Gateway

Data Consumption Flow

Data consumption flow image


Extensive data source support

Whitepaper

Mind the Gap: Expanding Data Access Options to Open SAP Analytics Opportunities

Digital transformations come in all shapes and sizes, but the one thing they all have in common is the need to expand and transform data connectivity. Analytics can be transformative, but only if analysts have access to all pertinent data sources. Organizations have data in many non-SAP sources that need to be leveraged in their analytics program. Download this whitepaper to learn more about digital transformation for non-SAP data assets.


 

Thought Leadership

 

Futurum Research Insight

Unlocking the Value of Data with APOS Live Data Gateway

 

Unlocking live data value

SAPinsider Video Q&A

The Importance of Seamless Data Connections

 

 

Video interview with with Kumar Singh, Research Director, Automation & Analytics, SAPinsider and Ofir Gil, CTO, APOS Systems

Market Insight - SAPinsider Research

Leveraging Data Connection Gateways to Harness Full Value from Analytics Investments

Extensive data source support


Data Connection 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 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 through the SAP Native, OData, JDBC and ODBC protocols.


APOS Administrator DetailsAPOS Administrator Sales InquiryAPOS Administrator Free Trial


Specialty Mineral Leader Success Story with APOS Live Data Gateway

Live data connectivity and drill-down capabilities for their Amazon Redshift Cloud data warehouse to consolidate financial and billing data Read more

Human and Animal Nutrition Leader Success Story with APOS Live Data Gateway

Live, transparent connectivity to Denodo, SSO integration, and portable modelling assets Read more

 

 

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