What is data source in SAP BI?

What is data source in SAP BI?

A DataSource is a set of fields that provide the data for a business unit for data access and extraction and data transfer into SAP BW∕4HANA. DataSources supply the metadata description of source data. They are used to extract data from a source system and to transfer the data to the SAP BW∕4HANA system.

What is ODP data source?

Operational Data Provisioning (ODP) provides a technical infrastructure that we can use to support two different application scenarios:- 1. The first of these is Operational Analytics for decision making in operative business processes. 2. The other is data extraction and replication.

How do I know if my DataSource is ODP enabled?

How to recognize if particular DS is released for ODP? Check table ROOSATTR. If the datasource (extractor) is marked as released in ROOSATTR (field EXPOSE_EXTERNAL = X), then ODP API will be used for extraction and multiple subscriptions should be possible.

What is DTP in SAP BW?

DTP determines the process for transfer of data between two persistent/non persistent objects within BI. As of SAP NetWeaver 7.0, InfoPackage loads data from a Source System only up to PSA. It is DTP that determines the further loading of data thereafter.

What is PSA in SAP?

Definition. The Persistent Staging Area (PSA) is the inbound storage area for data from the source systems in the SAP Business Information Warehouse. The requested data is saved, unchanged from the source system.

What is extractor in SAP BW?

An extractor is the program in SAP ERP which can be activated to prepare and capture the data through an extract structure for transfer to BW. The extractor can be the result of a standard DataSource or a custom built DataSource. It can describe a full load or a delta load process of different types.

What is ODP and Odq?

ODP(Operational Data provisioning) is a Netweaver based framework , ODQ(Operational Delta queue) is the queue for data extraction where ODP is installed as a source. ODP extractors can be used to transfer data between BW systems.

What is SAP ODP source system?

Operational Data Provisioning (ODP) provides a technical infrastructure to support data extraction and replication. For example, used to connect an SAP ECC system as the source system to a BW system. Communication is performed using remote function calls (RFC).

What are ODP extractors?

ODP is the key infrastructure used for the data extraction from ABAP-based SAP systems to an SAP S/4HANA system. SAP providers vary based on the source object through which you can extract data. The SAP providers define the context for the ODP extraction mechanism.

What is SAP ODP?

• The Service API (S-API) is the framework for DataSources (aka “Extractors”) in SAP ABAP applications. It allows the implementation, activation and enhancement of DataSources (Extractors). • Operational Data Provisioning (ODP) is a framework in SAP ABAP applications for transferring data. between systems.

What is the difference between InfoCube and DSO?

The main difference between the DSO Object and the PSA and InfoCube is that the DSO Object allows existing data to be changed. Whereas an InfoCube principally allows inserts, and only allows deletion on the basis of requests, data in an DSO Object can be changed during the staging process.

What is a DSO in SAP BW?

A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed transaction data or master data on a lowest granularity. DSO stands for Data Store Object. It is a two dimensional Transparent Table. Data is stored at detailed level. With DSO, it is also possible to overwrite data fields.