Tuesday, July 14, 2020
How APOS Semantic Layer Migrator and the APOS Live Data Gateway Translate SAP BI Modelling for SAP Analytics Cloud
The specific focus of this discussion is non-SAP, relational data sources, and how you can use APOS Semantic Layer Migrator and APOS Live Data Gateway together to make a wide variety of such data sources available to Hybrid BI data connectivity scenarios with SAP Analytics Cloud and other SAP applications.
Live Data Gateway expands live data connectivity from SAC to a wide range of relational, OLAP, Hadoop and Cloud data sources.
For example:
Note that APOS Live Data Gateway can connect to nearly all data sources supporting JDBC connectivity.
You can see a list of data sources currently supported by APOS Live Data Gateway
here.
APOS Live Data Gateway's Unified Semantic Layer contains the data modelling logic needed to allow applications such as SAP Analytics Cloud to consume the data from those data sources.
The APOS Live Data Gateway Unified Semantic Layer highlighted in the image above consists of APOS Views, which:
- Define which data fields are exposed
- Define Measures and Dimensions
- Manage table links and joins
- Set meaningful field names
- Define and secure who can access specific data
Using APOS Semantic Layer Migrator and APOS Live Data Gateway together extends the data modelling translation capabilities of APOS Semantic Layer Migrator
Working with APOS Live Data Gateway, APOS Semantic Layer Migrator can:
- Automate, the translation of modelling through wizard-driven process
- Capture the data connections and data modelling logic from SAP BI that connect to relational data sources, and replicate the data modelling logic into APOS Views
- Speed adoption of SAP Analytics Cloud by leveraging SAP BI logic investment
- Enable adoption of universal semantic layer for long-term data modelling
- Speed movement into Hybrid BI by leveraging SAP BI logic investment
APOS Live Data Gateway also allows you to create Freehand SQL Views, which empower analyst self-service, allowing you to create inner / outer joins, alias tables, calculated dimensions etc. OLAP Views are also available.
APOS Semantic Layer Migrator translates your Web Intelligence SQL statements into APOS Live Data Gateway Freehand SQL Views, and your Universe semantic layer into Semantic Views, while making no changes at all to the underlying relational data source, and caching no data outside that data source.
APOS Live Data Gateway greatly expands the range of data sources to which you can connect, but there is a second side to the APOS Live Data Gateway, the data consumption side, which you can see on the left side of this diagram:
APOS Live Data Gateway supports a number of different data consumption protocols, which allow your SAP solutions to consume data from a wide range of data sources via APOS Live Data Gateway. These data consumption protocols include SAP Native, OData, JDBC, and ODBC.
OData Support is particularly important, because it:
- Enables SAC Acquire/Import connection
- Expands import source options
- Enables Planning & Predictive scenarios
Consuming data via APOS Live Data Gateway allows your solutions to share the same Unified Semantic Layer and connection models.
JDBC and ODBC support round out the data consumption options, opening up a vast array of data connection and consumption options for your SAP solutions, and APOS Semantic Layer Migrator and APOS Live Data Gateway work together to allow you to leverage your SAP BusinessObjects data modelling for great speed to value in your new SAP BI & Analytics deployments.