Virtualized data connectivity

Name: APOS Live Data Gateway
Brand: APOS

Simplified and unified data connectivity across BI and Analytics applications

Remove the complexities of data connection, data structures and data linking from your analytic user’s experience. Replace complexity with a common business layer that provides a simplified, secured, and governed connection point to data.

Unified Data Connectivity

Access relational, OLAP, Cloud, and Hadoop data using a single connection mechanism

Universal Semantic Layer

Offer pre-built data models for all your data assets

Governed Data Connectivity

Control the data elements users can access

Democratized Self-Service BI

Simplify data access for all users without database/IT knowledge

Self-Service Data Modelling

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

Agile Data Discovery

Broaden and speed access to new data for discovery without burdening IT resources

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

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 Semantic Layer edition of 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 Semantic Layer edition of Live Data Gateway can connect to a vast range of data sources. An extensive set of core relational, OLAP, Hadoop, and Cloud data sources are supported, and a broader set of extended data sources and applications are also available. See the full list of over 150 supported data sources

Broad Data Consumer Support

APOS Semantic Layer edition of Live Data Gateway can serve data to any application or database consumer via OData, JDBC, and ODBC. This broad range of support for analytics greatly amplifies the significance of the Unified Semantic layer as a shared connection mechanism and business layer.

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

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 Brief

Leveraging Data Connection Gateways to Harness Full Value from Analytics Investments

Overview of APOS Semantic Layer with Live Data Gateway

Data Connection Architecture

Data Flow Architecture diagram

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.