APOS Data Gateway, Design Studio Edition

The Design Studio Edition of the APOS Data Gateway supports data connectivity to an expanded range of trusted enterprise data sources, including data from any database, from blocks of data in Web Intelligence documents, or from universes (both UNV and UNX). The Design Studio Edition provides this support through four key components:

  • Web Intelligence Connector
  • Direct Data Connector
  • Relational Grid
  • Identity Controller

APOS Trusted Source Connector

The APOS Trusted Source Connector lets you leverage the trusted data, data connections business rules of Web Intelligence reports and instances. This connector allows you to:

  • Inherit Web Intelligence  data connection options such as UNV,HANA, UNX, and BEx
  • Leverage the Web Intelligence calculation engine
  • Leverage existing Web Intelligence reports for shorter time to value
  • Use Web Intelligence instances to access pre-loaded and pre-calculated data

The value is clear: by using the APOS Trusted Source Connector with the APOS Data Gateway, you leverage the investment already made by your enterprise in the development of Web Intelligence — all of the data connection options, and all of the data preparations and calculations. By leveraging these assets, you greatly shorten the amount of time it takes to realize value through your SAP Design Studio projects.

Direct Data Connector

The Direct Data Connector lets you connect to any relational database using either of the following connection types:

  • Dynamic connection - sending a SQL statement of your construction or choice to the database
  • Stored Query connnection - using a pre-configured query with parameters

The Direct Data Connector lets you acquire any data from any relational database and use aggregate queries to speed data acquisition.

In addition, the Direct Data Connector for SAP Design Studio also provides direct access for your Design Studio projects HANA tables, allowing you to bypass HANA Views.

Relational Grid

The APOS Data Gateway's Relational Grid lets you bring an unlimited amout of relational data into Design Studio, overcoming the solution's current limits on relational data, and displays that data with great speed — high relational data volume at high speed.

Identity Controller

The APOS Data Gateway Identity Controller allows dashboard design to be driven by flexible row-level security. It determines the components and data that appear in a dashboard according to the SAP BusinessObjects user logging in to view the dashboard.

What this means in practice is that designers can use SAP BusinessObjects Groups to customize dashboards, a feature that is quite valuable in multi-tenancy environments.

APOS Data Gateway Server

All APOS Data Gateway connectors use another component, the APOS Data Gateway Server. The connectors reside on the desktop and the APOS Data Gateway Server connects, with authentication, and using SAP BusinessObjects SDKs, to the selected databases and/or Web Intelligence reports within the SAP BusinessIObjects environment.

apos data gateway design studio