Solution Icon

APOS Live Data Gateway

Extended Data Connectivity for SAP Analysis Office

The APOS Live Data Gateway provides live data connectivity for SAP Analysis for Office 2.5 and higher.

APOS Live Data Gateway AO

Click to view APOS Live Data Gateway for SAP Analysis for Office Architecture.

Extend data connectivity by unlocking live data for your SAP Analysis for Office projects. Live data connectivity provides:

  • Connection to trusted and governed data sources
  • A simplified discovery experience, with no need to write SQL
  • Flexible data selection
  • Data that is always current
  • Stronger security -- no data stored on the user's computer

APOS Live Data Gateway Data Sources for SAP Analysis Office

The APOS Live Data Gateway simplifies data access to numerous data sources, providing live data connectivity that can be managed easily by end users with no knowledge of SQL or MDX queries. Data source connections are available for:

  • Microsoft SQL Server (On-Premise & Microsoft Azure)
  • Microsoft Analysis Services (MSAS - On-Premise & Microsoft Azure)
  • Oracle
  • Oracle Essbase
  • Oracle Exadata
  • Teradata
  • IBM Netezza
  • DB2
  • Redshift on Amazon Web Services
  • MongoDB & MongoDB Atlas
  • Sybase IQ
  • Sybase SQL Anywhere
  • UNX and UNV Universes
  • SAP BW (7.3 and higher)

Single Sign-On for SAP Analysis Office Users

Single sign-on for SAP Analysis Office users comes in three levels:

  • Level 1 - A single cached database account can be used by all users of a given connection.
  • Level 2 - The administrator can set up a list of accounts to be used to connect to the database, mapping SAP BusinessObjects accounts to databases. The administrator can optionally define row-level security for each account.
  • Level 3 - A link can be established automatically between SAP BusinessObjects accounts and UNX / UNV universes. The administrator can optionally define row-level security for each account.

 

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

APOS Well Managed BI Blog APOS LinkedIn page APOS Facebook page WellManagedBI Twitter feed