What is generic DataSource in SAP BI?

What is generic DataSource in SAP BI?

You come to a situation where most of the fields are not available in any standard datasource, then you go for what is called the creation of a generic datasource. You can create a database view of the fields required by combining a number of tables. Then you create a datasource out of the view.

How many types of generic DataSource we can create in SAP BW?

Generic Extractors You can create data sources in three different ways, based on: Tables and Views (for simple applications) Infosets. Function Modules (for complex extractions)

Which source types can you use for a generic DataSource?

Generic Data Source in SAP BW4HANA

  • ABAP CDS (Logics can be incorporated)
  • HANA Calculation Views (potentially on top of External Views of InfoProviders)
  • BADI Provider as ODP-BW Provider.

How do you create a generic DataSource in SAP BI?

How to Create a Generic Datasource

  1. In Source System, go to SE11 and create the view, then go to RSO2 to create datasource.
  2. Specify the name of the datasource in the field of RSO2 and hit Create.
  3. Give the Application component and description.
  4. In View/Table field field specify the ZView name.

What is generic extraction?

Generic Extraction is sort when the standard extractors are not supporting the extraction what you need. Generic extractors are of 3 types: 1. Based on table/view. 2.

What is Lo extraction in SAP BW?

:Extracts data from application table and stores in update queue and then transfers and then transfers to BW delta queue. Direct Delta:In case of Direct Delta LUW’s (Logical Unit of Work) are directly posted to delta queue (RSA7) and we extract the LUW’s from delta queue to SAP-BW by running delta loads.

How do I create a data source in SAP HANA?


  1. You are in the BW Modeling tools.
  2. Make the required entries in the wizard and choose Finish.
  3. On the Overview tab, you make general settings, if required.
  4. On the Extraction tab, you make extractor-specific settings.
  5. On the Fields tab, you maintain the properties of the DataSource fields.

How does ODP work in SAP BW?

The ODP infrastructure (with delta queues) takes over important services such as monitoring data requests. The data is stored in a compressed state in the delta queue. A delta request transfers data records from the queue to the subscriber (target system).

How do you replicate a generic data source?

You have the following options:

  1. Choose Replicate Metadata in the Data Warehousing Workbench in the DataSource tree through a DataSource context menu. or.
  2. On the initial screen of the DataSource repository (transaction RSDS), select the source system and the DataSource and then choose DataSource Replicate DataSource .

What is generic data source in WebLogic?

Generic data sources provide database access and database connection management. Each data source contains a pool of database connections that are created when the data source is created and at server startup.

What are SAP extractors?

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.

How many types of extractions are there in SAP?

Types of SAP Extractors There are three types of content extractors: Business Content Extractors (Application Specific): BW content FI, HR, CO, SAP CRM, LO Cockpit. Customer-Generated Extractors (Application Specific): such as LIS, FI-SL, CO-PA.