Solution Icon

APOS Live Data Gateway

Unlock Live Data

Extended Data Connectivity for SAP Analytics Cloud

SAP Analytics Cloud is a powerful tool for analysis and presentation of business intelligence. The APOS Live Data Gateway makes this SAP solution even more powerful through extended data connectivity.

The APOS Live Data Gateway is a data connection and data transformation solution that enables live data connectivity and expanded data source options for SAP Analytics Cloud.

Extensive Range of Live Data Sources

The APOS Live Data Gateway provides live data connectivity to most industry-standard Relational, OLAP, and Cloud data source and solution developers, including:

  • Amazon
  • Cloudera
  • Denodo
  • Google
  • IBM
  • Microsoft
  • MongoDB
  • MySQL
  • Oracle
  • Salesforce
  • SAP
  • Snowflake
  • Teradata

See the full list of over 150 supported data sources…

 

Extended Live Data Connectivity

Using the APOS Live Data Gateway for extended data connectivity lets you:

  • Leverage data from its current location
  • Leverage existing data modelling and security models
  • Keep data behind the firewall
  • Work with data that is always current
  • Remove added data storage requirements
  • Reduce data bandwidth requirements

Freehand SQL Queries

Build your own freeehand SQL queries. Test, save and share your queries so that your team can build stories against them. APOS Live Data Gateway gives you maximum flexiblity to access your data and increase SAP Analytics Cloud self-serve capabilities.

Translate SAP BI Modelling

Automatically translate the queries from Web Intelligence reports and create a Live Data Gateway semantic layer view - an APOS View - based on that query. Use the automatically generated APOS Views for SAC story creation against the same modelling used by the Web Intelligence reports.

Data Connection & Data Transformation

Use the APOS Live Data Gateway's connectors to make your enterprise data sources available for your SAP Analytics Cloud stories.

Direct Data Connector

The APOS Live Data Gateway's Direct Data Connector simplifies the process of building stories and populating dashboards and reports. There is no data modeling required before you construct your stories, because the APOS Data Gateway uses the data model and security model that are deployed in the source database, significantly reducing the time it takes to achieve story objectives, and dramatically improving end user adoption.

SAP BW Connector

The APOS Live Data Gateway connects quickly and easily to BW, with no changes required to the BW environment. Just connect and start building your stories.

JDBC Connectivity

The APOS Live Data Gateway supports generic JDBC connectivity, so it is well positioned to connect to a vast range of additional data sources and applications.  Any source that has a JDBC connection point is a candidate source, meaning there are countless potential sources that the APOS Live Data Gateway can access and serve data from.

Please inquire with APOS if you have questions concerning the use of the APOS Live Data Gateway with a particular application or data source.

Hadoop & Big Data

The APOS Live Data Gateway enables live data connectivity from SAP Analytics Cloud to a set of Hadoop configurations, including:

  • Cloudera with Apache Impala
  • Cloudera with Hive (1.1.0)
  • Hortonworks with Hive (1.2.3)
  • Amazon Web Services with Hive (1.2.3)
  • Google Cloud Platform with Hive (1.2.3)

Learn more about APOS Live Data Gateway Hadoop Configurations.

Custom Connectors

If you don't see the data source you need on our list, contact us and we'll work with you to make it a reality.

APOS Views

Make your data SAP Analytics Cloud-ready, and more report creator-friendly. APOS Views provide a semantic layer between your enterprise data sources and your SAP Analytics Cloud stories, allowing you to establish measures and dimensions centrally, control what data is exposed, address table links and joins, and apply meaningful business names to alias your data field names. The simplified data connection process will enable easier report and story creation, by a broader range of report creators.

APOS Live Data Gateway Architecture

APOS Live Data Gateway Architecture
Click to enlarge...

SAP Analytics Cloud Help

The SAP Analytics Cloud Help website provides help on using the APOS Live Data Gateway to establish and manage live data connections with SAP Analytics Cloud

View Using the APOS Live Data Gateway on the SAP Analytics Cloud Help page...

 

 

Well Managed BI  |  Solutions  |  About APOS  |  Resources  |  Careers  |  Customer Support  |  Contact Us  |  Site Map  |  @APOS_Systems

APOS Well Managed BI Blog APOS LinkedIn pageAPOS Systems feed