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 databases 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 source type DataSource (BW), Open ODS views for supported source system types - BW, SAP, ODP (SAP extractors), ODP (BW) and DB Connect - can access data, for which DataSources already exist in BW. For Open ODS views, only DataSources are available as sources that support direct access.

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 must be configured as a DB Connect source system.

Tables and Views from Databases Using SAP HANA Smart Data Access

With source type Virtual Tables Using HANA Smart Data Access, Open ODS views can access remote data in different source databases. The source database must be configured in SAP HANA as a remote source. The connection to the source database and to the relevant schema is configured using a DB Connect source system. When an Open ODS view is created with source type Virtual Table Using 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.

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: