Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Connecting to SAP and Selecting a DataSource

Connecting to SAP and Selecting a DataSource

Use step 1 of the wizard to connect to SAP and select a DataSource.
To connect to SAP and select a DataSource:
  1. In the Mapping Designer, click Mappings > Generate BCI Mapping.
    The Generate Mapping for BCI Wizard appears.
  2. To connect to the SAP system, enter the login information.
    The following table describes the login information:
    Field
    Description
    Connect String
    Required. DEST entry defined in the
    sapnwrfc.ini
    file for a connection to a specific SAP application server or for a connection that uses SAP load balancing.
    User Name
    Required. SAP source system connection user name. Must be a user for which you have created a source system connection.
    Password
    Required. Password for the user name.
    Client
    Required. SAP client number.
    Language
    Optional. Language you want for the mapping. Must be compatible with the PowerCenter Client code page. If you leave this option blank, PowerCenter uses the default language of the SAP system.
  3. Click Connect.
  4. Optionally, enter the name or a partial name of an Application Component or a DataSource to search for and click the Find button. Or, go to step 7.
    An application component is an expandable container for DataSources.
    You can include an asterisk (*) or percent sign (%) in a name to use as a wildcard in the search.
    The Search Results dialog box appears.
  5. Select a DataSource or application component.
    The DataSources listed are those you activated in Step 1. Prepare DataSources in SAP.
  6. Click Select to close the Search Results dialog box, and click Next.
  7. Expand the application component that contains the DataSource you want to use.
    The Designer displays a list of DataSources.
  8. Select the DataSource from which you want to create the mapping.
    If you select a hierarchy DataSource, go to Configuring the Request File and Data Extraction Parameters.
    If you select a hierarchy DataSource and have already created a processing mapping for a hierarchy DataSource, you receive a warning. You can only have one processing mapping for all hierarchy DataSources in a folder. If you create another processing mapping for a hierarchy DataSource, you overwrite the existing mapping for hierarchy DataSources.
  9. Click Next.
    Step 2 of the wizard appears.

0 COMMENTS

We’d like to hear from you!