Table of Contents

Search

  1. Getting Started with PowerExchange for SAP NetWeaver
  2. SAP Table Data Extraction
  3. SAP BW OHS Data Extraction
  4. SAP BW Data Load
  5. SAP Pushdown Optimization
  6. Data Type Reference

PowerExchange for SAP NetWeaver User Guide

PowerExchange for SAP NetWeaver User Guide

Creating a 7.x DataSource in SAP BW 7.3

Creating a 7.x DataSource in SAP BW 7.3

You can create a 7.x DataSource when you want to use an InfoPackage and load data to the PSA. You can then configure a DTP to transfer the data from the PSA to an SAP target.
  1. Define Informatica as a logical system in the SAP BW 7.3 system.
  2. Create an SAP BW Service by using the Administrator tool and enable the service.
  3. In the Data Warehousing Workbench, click
    DataSources
    .
  4. Right-click the DataSources folder, and select
    Create application component
    .
  5. Enter the application connection parameters and click
    Enter
    :
    The following table describes the application connection parameters:
    Parameter
    Description
    Application Comp
    Organizes logical systems.
    Long Description
    Description of the application component.
    The application component appears in the Data Warehousing Workbench.
  6. Right-click the application component and select
    Create DataSource
    .
    The
    Create DataSource
    dialog box appears.
  7. Enter the DataSource parameters and click
    Enter
    .
    The following table describes the DataSource parameters:
    Parameter
    Description
    DataSource
    Name of the DataSource.
    Source system
    Name of the source system that populates the DataSource with data.
    Data Type DataSource
    Type of the DataSource that you want to create.
    You can create the following types of DataSources:
    • DataSource for transaction data
    • DataSource for master data text
    • DataSource for master data attributes
    • DataSource for hierarchies
    The DataSource appears in the Data Warehousing Workbench.
  8. Click the
    Fields
    tab and add InfoObjects to the DataSource.
    The InfoObjects you use in the DataSource display as ports in the data object.
  9. Select the data format options for the InfoObjects.
    The following table describes the data format options:
    Parameter
    Description
    Internal Format
    Indicates if the data from the source is in a secure internal format.
    When you select this option, SAP does not verify or convert the format. Therefore, if the source does not return data in an internal format, there could be data inconsistencies or errors in the loading process.
    External Format
    Indicates if the data from the source is in an external format.
    When you select this option, SAP converts the data into an internal format before it passes the data to the transformation.
    Check for Internal Format
    Indicates if the SAP system must verify whether the data from the source system is in an internal format.
    Select this option if the data from the source is in an internal format, but it must be verified before being passed to the transformation. Select this option to ensure data conformity.
  10. After creating metadata, click
    Enter
    to return to the Data Warehousing Workbench.

Back to Top

0 COMMENTS

We’d like to hear from you!