Show TOC

Creating VirtualProviders Based on Data Transfer ProcessesLocate this document in the navigation structure

Prerequisites

If you want to use a DataSource as the source for the VirtualProvider, you have to allow direct access.

To be assigned to this type of VirtualProvider, a source system must meet the following conditions:

  • For a connection using a 3.x InfoSource, the BW Service API (included in Plug-In Basis) has to be installed. DataSources from the source system that are released for direct access are assigned to the InfoSource. There are active transfer rules for these combinations.

  • The source system is Release 4.0B or higher.

Context

With this kind of VirtualProvider, the transaction data for analysis and reporting purposes is read directly from an SAP system using a DataSource or an InfoProvider.

Use this VirtualProvider if:

  • You require up-to-date data from an SAP source system.

  • You only access a small amount of data from time to time.

  • Only a few users run queries on the dataset at any one time.

Do not use this VirtualProvider if:

  • You request a large amount of data in the first query navigation step, and no appropriate aggregates are available in the source system.

  • A large number of users execute queries at the same time.or

  • frequently access the same data.

Procedure


  1. In the Data Warehousing Workbench, select the InfoProvider tree under Modeling.

  2. In the context menu, choose Create VirtualProvider.

  3. As the type, select VirtualProvider based on data transfer process for direct access.

    For compatibility reasons, a VirtualProvider that is based on a data transfer process with direct access can also be linked with an SAP source system using an InfoSource 3.x. See Creating VirtualProviders Based on 3.x InfoSources.

    The Unique Source System Assignment flag is used to stipulat whether or not this source system assignment needs to be unique. If the flag is set, you can select a maximum of one source system in the assignment dialog. If the flag is not set, you can select more than one source system. In this case, the VirtualProvider acts like a MultiProvider.

    If the flag is not set, characteristic 0LOGSYS is automatically added to the VirtualProvider when it is created. This characteristic allows you to select the source system dynamically in the query. In each navigation step, the system only requests data from the assigned source systems whose logical system name fulfills the selection condition for characteristic 0LOGSYS.

  4. Define the VirtualProvider by adding the required InfoObjects. Activate the VirtualProvider.

  5. Choose Create Transformation in the context menu for the VirtualProvider. Define the transformation rules and activate them.

  6. In the context menu for the VirtualProvider, choose Create Data Transfer Process. The default value for the DTP type is DTP for Direct Access. Select the source for the VirtualProvider. Activate the data transfer process. See Creating Data Transfer Process for Direct Access.

  7. Activate direct access. In the context menu for the VirtualProvider, choose Activate Direct Access. In the dialog box that appears now, choose one or more data transfer processes and choose Save Assignments.

Results

The VirtualProvider can be used for analysis and reporting in the same way as any other InfoProvider.