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.
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:
- MongoDB & Mongo DB Atlas
- MySQL
- Oracle
- Oracle Essbase
- Oracle Exadata
- Salesforce
- Snowflake
- Sybase IQ
- Sybase SQL Anywhere
- SAP BW 7.3 and higher
- Teradata
- All JDBC data sources
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.