Expand, simplify, and unify your data connectivity for SAP Analytics Cloud and Snowflake. Leverage live connectivity with the performance and security of Snowflake, and achieve critical import and export of planning data, and data extraction from SAC and other supported sources.
APOS Data Gateway provides fast, efficient, and transparent live data access to valuable Snowflake Data Cloud data from SAP Analytics Cloud, providing easy self-service through existing APOS semantic layer views. Users can also conveniently define their own semantic layer views and freehand SQL queries against Snowflake Data Cloud data, all while respecting Snowflake security structure and schema. Special features for Snowflake allow APOS Data Gateway to handle and respect Snowflake roles while minimizing and automating administration and maintaining Single Sign-On (SSO) between Snowflake and SAP Analytics Cloud.
This extended Live, Import and Export data access allows SAP accounts to unlock greater value from their Snowflake Data Cloud data, yielding better and faster business analytics and decisions.
Why Snowflake + APOS for Snowflake connectivity from SAP Analytics Cloud?
SAP Analytics Cloud does not have built-in support for a live connection to Snowflake.
APOS Data Gateway includes:
Live connectivity from SAC to Snowflake
LEARN MORE
Import Snowflake data into SAC, and extract SAC data for import into Snowflake
LEARN MORE
Schedule your strategic data export to a variety of destinations
LEARN MORE
APOS Live Data Gateway:
Live connectivity to Snowflake from SAP Analytics Cloud
APOS Live Data Gateway enables SAP Analytics Cloud users to consume live Snowflake Data Cloud data, and to easily self-serve through existing APOS semantic layer views. Users can also conveniently define their own semantic layer views and freehand SQL queries against Snowflake Data Cloud data, all while respecting Snowflake security structure and schema. Special features for Snowflake allow APOS Live Data Gateway to handle and respect Snowflake roles while minimizing and automating administration and maintaining Single Sign On (SSO) between Snowflake and SAP Analytics Cloud.
Connect live to Snowflake Data Cloud data for SAP Analytics Cloud (SAC) business intelligence users with the APOS Live Data Gateway solution. This fully live data access allows SAP accounts to efficiently unlock greater value from their Snowflake Data Cloud data, yielding better and faster business analytics and decisions.
Fast, efficient, and transparent live data access to
valuable Snowflake Data Cloud data from SAP Analytics Cloud
Leverage existing Snowflake security
Control and govern what Snowflake Data Cloud data is exposed through a focused Single Sign On (SSO) integration from SAP Analytics Cloud into Snowflake, creating mapping between SAC IDP SAML users and Snowflake users through OAuth. Snowflake roles are respected, and administration is minimized and automated.
Data stays in Snowflake
With a live connection to SAP Analytics Cloud, analytics processes work directly with the Snowflake environment, so that replicating data outside of Snowflake is not needed. Snowflake's powerful data processing engine is used to deliver very high-speed processing of live queries, performance tested with over a billion rows of data.
Snowflake Data Cloud data is always current
Live data is always current, with no data replication or data latency. Live Data Gateway works with Snowflake’s powerful data processing engine to efficiently access and serve large and growing data environment scenarios.
Unified Semantic Layer
Snowflake data is presented in business terms to the business user to enable self-serve and ad hoc consumption of Snowflake Data Cloud data and broad dissemination of information from Snowflake to business users. The Snowflake schema is easily read by the semantic layer to help the users generate business-friendly views of the data.
Leverage existing data modelling
Easily build and share views on your data for agile data modelling. Since the Snowflake security structure and schema are maintained, there is no need to rebuild row level security or data structures.
Performance with Very Large Datasets
Snowflake Data Cloud presents power and scalability, and APOS Live Data Gateway presents the live data connectivity and unified semantic layer organizations need to use large data sets from Snowflake in SAP Analytics Cloud analytics solutions.
Watch this demonstration to see how easy APOS Live Data Gateway makes connecting to and querying a Snowflake Data Cloud of over 288 billion rows (10.5 TB dataset) with results in under 2 seconds.
.
Overview of Live Data Gateway
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. We had built up a big repository of data imports and after a while, that was causing a problem in itself, just the size of the data repository.
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. The success of APOS Data Gateway’s integrated authentication and SSO with the Snowflake security model has been very helpful, and we have not even had to revisit settings since deployment.
- Paul Carey, Business Solution Manager
- Information & Analytics
Britvic
High-performance connectivity from SAP Analytics Cloud to live Snowflake data - Read more
Live Data Gateway Data Connection Architecture
close ×
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 by SAP Analytics Cloud through the SAP Native protocol, but can also be consumed via OData, JDBC and ODBC.
APOS worked with Salling Group to develop new Single Sign-On functionality in the Live Data Gateway product using a combination of SAML and Oauth2. This capability did not exist in the marketplace.
APOS Live Data Gateway has made it possible for us to supply relevant data to business users within a familiar UI. APOS Live Data Gateway, together with these SSO capabilities, enables users to operate in a single reporting tool (SAP Analytics Cloud) without disturbance and regardless of the complexity of infrastructure and data storage models behind the data used for reporting.
- Tommy Baunwall, Enterprise Architect, and
Mikael Skou Andersen, Business Process Manager & PO - Finance
Salling Group
close ×
Salling Group Success Story
High-performance, live data connectivity between SAP Analytics Cloud and Snowflake Data Cloud - Read more
APOS Import Data Gateway:
Import Snowflake data into SAC and extract SAC data to import into Snowflake
APOS Import Data Gateway expands, simplifies and unifies your data connectivity for SAP Analytics Cloud users of Snowflake Data Cloud. This middleware platform enables you to enrich SAC Planning with data imported from Snowflake Data Cloud, without the need to use the SAC Cloud Connector. Strategic bidirectional movement of data in and out of SAC Planning to Snowflake.
Snowflake data source for SAP Planning
Import data directly from Snowflake Data Cloud
Bidirectional integration of SAP Planning data
Extract data out of SAC for Import into Snowflake Data Cloud
Simplify data connection
Easy-to-configure and use alternative to the SAP Cloud Connector
Schedule data imports
Ensure timely imports and appropriate data for SAC Planning and other Analytics applications
Full and delta data uploads
Strong configuration options to control data load settings and import methods
Unify data management
Centrally manage and execute data imports and extracts across many sources
Full Cycle Planning Data
APOS Import Data Gateway enables bi-directional data processes, with import of data from non-SAP sources into SAP Analytics Cloud, and then return of enhanced SAC Planning data back to the non-SAP source – full cycle. This bi-directional flow allows for the SAC Planning data to be incorporated into other organizational processes and analysis.
APOS Export Data Gateway:
Export Planning data from SAP Analytics Cloud
APOS Export Data Gateway is designed to meet strategic requirements for data extracts from a data source, which are then saved to a static file (CSV) and distributed to a targeted location or user. These capabilities provide effective automation to meet common requirements where a static data file is needed to fuel a separate data process, a regulatory requirement, or other strategic information need.
This means that APOS Export Data Gateway enables scheduled processes to export SAP Analytics Cloud Planning data to a CSV file and send to a strategic user or file location for Import into Snowflake Data Cloud. It also means that APOS Export Data Gateway can export data from an extensive range of relational, OLAP, Hadoop and Cloud sources to CSV files and send to Snowflake Data Cloud for further processing.
APOS Export Data Gateway respects database security: users can only export data that they have rights to access, and a self-service end user interface simplifies the extract process.
High volume data exports
- CSV format output
- Strong performance
Schedule recurring exports
- Hourly
- Daily
- Weekly
- Monthly
Automated delivery to:
- Network File shares
- FTP or secure FTP
- SharePoint
- Email
On-demand data exports
APOS Data Gateway Architecture
close ×
APOS Data Gateway Architecture
Extensive Data Source Support
Along with focused Snowflake connectivity, APOS Live Data Gateway also 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
close ×
Global Healthcare Success Story
Live data access to Snowflake from SAP Analytics Cloud with high performance and self-service - Read more
Thought Leadership
MIND THE GAP: Expanding Data Access Options to Open SAP Analytics Opportunities
Whitepaper
Expand and transform data connectivity to include all pertinent data sources in your Analytics.
View now
Unlocking the Value of Data with APOS Live Data Gateway
Futurum Research
Infosheet
Leveraging data is an imperative, but we also know that it has its challenges, such as managing data from disparate sources.
View now
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
Expand, simplify and unify your data connectivity
SAP
Infographic
94% of organizations need access to multiple data sources to support effective decision-making.
View now