Show TOC

Supported Sources for Open ODS ViewsLocate this document in the navigation structure

Various sources for data access with Open ODS views are available: DataSources in BW, DataStore objects (advanced), database tables or views of the BW SAP HANA database, and external sources connected to BW using SAP HANA Smart Data Access. In addition, transformations allow data type conversions, for example, as sources, if data is consumed outside of the BW-managed database schema.

DataSources in BW

With the source type DataSource (BW), Open ODS views can access the data of DataSources that support direct access. This is possible for ODP, SAP or SAP HANA source systems.

DataStore Objects (Advanced)

With the source type DataStore-Object (Advanced), Open ODS views can access data from DataStore objects (advanced). Only DataStore objects for which all reporting takes place on the active table are supported.

Database Tables or Views of the BW SAP HANA Database

With source type database table or view, Open ODS views can access data from any schemas on the BW SAP HANA database. The connection to the relevant schema is configured in the SAP HANA source system with connection type Local SAP HANA Database Schema.

Note The connection to the relevant schema was configured as a DB Connect source system before the SAP HANA source system was made available. Existing DB Connect source systems can still be used. You can configure new connections via the SAP HANA source system.
Tables and Views from External Sources Using SAP HANA Smart Data Access

With source type Virtual Tables Using HANA Smart Data Access, Open ODS views can access remote data from different external sources. The source must be configured in SAP HANA as a remote source. The connection to the source and the relevant schema is configured via a SAP HANA source system with connection type SAP HANA Smart Data Access for BW.

Note The connection to the relevant schema was configured as a DB Connect source system before the SAP HANA source system was made available. Existing DB Connect source systems can still be used. You can configure new connections via the SAP HANA source system.

When an Open ODS view is created with source type Virtual Table Using SAP HANA Smart Data Access, a virtual table is created in SAP HANA. The virtual table points to a remote table, which is the source object of the Open ODS view, and allows access to data.

Note

Note that this source type is currently only supported for sources with schemes. Sources with a logical structure (folders) are not supported at present. At the moment you can only access these sources via an Open ODS view by creating a SAP HANA DataSource and using it as a source for the Open ODS view.

Transformations

Using source type transformation you can use transformations for example, to perform data conversions, assignments and string operations on data, which is consumed using Open ODS views. This can be useful for example, if you do not want to or are not able to use these transformations in the data source on data, which is outside of the BW-managed database schema.

You can use a transformation as the source for the Open ODS view provided that you have created the corresponding data flow:

Related Information