Live data connectivity from SAP Analytics Cloud to non-SAP data sources


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 live data connections in SAP Analytics Cloud including your valuable non-SAP data.


Expanded Live Data Connectivity

Utilize data from existing location

Utilize data from existing location

Access relational, OLAP, Cloud, and Hadoop data using a single, simplified and consistent connection point into the available data
View more

Data always current

Data is always current

Live data connectivity to SAC and Datasphere and live data consumption using OData, JDBC, ODBC
View more

Data never leaves firewall

Data never leaves the firewall

In Live data connection mode no sensitive data ever leaves the network environment, and only report metadata crosses the firewall

Unified Semantic Layer

Unified Semantic Layer

Simplified data connection process enables easier report, dashboard and story creation by a broader range of users

Leverage existing security

Leverage existing security

Control and govern what data is exposed through the semantic layer between your enterprise data sources and your SAP solutions

Self-Service Data modelling

Leverage existing data modelling

Easily build and share views on your data for agile data modelling


WR Grace

APOS Data Gateway resolved a major issue we had with continued use of SAP Analytics Cloud. We experienced limitations in the way SAP Analytics Cloud handled visualizations on large imported data sets from Snowflake. Live data connectivity with APOS Data Gateway provided a path forward, allowing us to fulfill current SAP Analytics Cloud use cases and build new ones.

Paul Carey, Business Solution Manager
- Information & Analytics, Britvic

WR Grace

Britvic Success Story with APOS Live Data Gateway for SAP Analytics Cloud

Britvic achieved live connectivity from SAP Analytics Cloud to a large data repository in Snowflake with integrated authentication and SSS - Read more

Performance with Large Data Sets

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 Snowflake (288 billion rows - 10TB data set) and Google BigQuery (196 million 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

Salling Group 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

Aspris Success Story with APOS Live Data Gateway

Live data connectivity from SAP Analytics Cloud to Azure SQL
Read more



Specialized connectivity needs for SAP Ariba, SAP SuccessFactors, SAP S/4HANA, SAP Concur, SAP Fieldglass and other Cloud applications or niche data sources? Click here to contact us for solutions.


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.



Contact APOSSales InquiryFree Trial

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

Direct data connectivity in live mode to Oracle, SQL Server and Google BigQuery for more informed analytics - Read more

Heavy Equipment Manufacturer and Distributor Success Story

Live data connectivity from SAP Analytics Cloud to Azure SQL
Read more

See our case studies and customer stories



Available on SAP Store



Thought Leadership


Expand data connectivity whitepaper
MIND THE GAP: Expanding Data Access Options to Open SAP Analytics Opportunities

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

View now

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

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

View now

SAPInsider research
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

SAP Infographic
Expand, simplify and unify your data connectivity

94% of organizations need access to multiple data sources to support effective decision-making. Virtualized data connectivity is a timely, exciting solution.

View now


You are in good company

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

Melbourne Water
Energy Northwest
Salling Group
Blue Cross Blue Shield Kansas City
Harvey Norman
University of Miami