Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to SAP Connector
  3. Part 2: SAP Connector administration
  4. Part 3: Connections
  5. Part 4: Data integration using BAPI/RFC functions
  6. Part 5: Data integration using IDocs
  7. Part 6: SAP BW data extraction
  8. Part 7: Data integration for SAP ADSO
  9. Appendix A: SAP data type reference

SAP Connector

SAP Connector

Back Next

Configuring a Synchronization task with a single SAP BW object as the source

Configuring a
Synchronization
 task with a single SAP BW object as the source

  1. To create a synchronization task, click
    Data Integration
    New
    Tasks
    . Select
    Synchronization Task
     and click
    Create
    .
  2. Enter a name for the
    synchronization
     task.
    The names of
    synchronization
     tasks must be unique within the organization.
    Synchronization
     task names are not case sensitive.
    Synchronization
     task names can contain alphanumeric characters, spaces, and the following special characters:
    _ . + -
  3. Enter a description for the
    synchronization
     task.
    The description can have a maximum length of 255 characters.
  4. Select the task operation that you can perform on the target.
    You can select one of the following options:
    • Insert
    • Update
    • Upsert
    • Delete
  5. Click
    Next
     to enter the source details.
    1. Select an SAP BW Reader connection from the list or create a new SAP BW Reader connection.
    2. Select an SAP BW source object from the list or click
      Select
       to search for an SAP BW source object.
      The
      Select Source Object
       dialog box appears. The dialog box displays up to 200 objects. If the objects that you want to use do not appear, enter a search string to search for the object based on its name, label, description, or type, and then click
      Search
      .
    3. Select the SAP BW source object from which you want to read data, and then click
      Select
      .
      The
      Data Preview
       area displays the first 10 rows of the first five columns in the SAP BW object, and the total number of columns in the object. To preview all source columns in a file, click
      Preview All Columns
      .
    4. To display technical names instead of business names, select the
      Display technical field names instead of labels
       option.
    5. To display source fields in alphabetic order, select the
      Display source fields in alphabetical order
       option.
      By default, fields appear in the order returned by the source system.
  6. Click
    Next
     to specify the target connection and target objects.
  7. Click
    Next
     to specify the data filter criteria.
    1. Click
      New
       to create a data filter. You can specify a simple data filter based on key characteristics.
      You cannot create an advanced data filter. You cannot specify a simple data filter based on key figures.
    2. Select the source object, key characteristic source field, and operator.
      You can select one of the following operators for the filter condition:
      • Equals
      • Not Equals
      • Less Than
      • Less Than or Equals
      • Greater Than
      • Greater Than or Equals
    3. Enter the value based on which you want to filter the data and click
      OK
      .
  8. Click
    Next
     to configure the field mappings. Perform any of the following steps based on your requirements:
    1. Click
      Edit Types
       in the Source column to edit the precision and scale of the SAP BW object.
    2. Click
      Automatch
       to match source and target fields with similar names.
    3. Click
      Refresh Fields
       to update the cache and view the latest field attributes.
    4. Click
      Edit Types
       in the Target column to edit the data type, precision, and scale of the target object. Note that this option is not available for all target types.
    5. Select a source field and drag it to the target field to map the source and target fields. Repeat for all the fields that you want to map.
    6. Click the
      Add or Edit Expression
       icon to define a field expression to transform data.
    7. Click
      Validate Mapping
       to validate all the field mappings.
    8. Click
      Clear Mapping
       to clear all the field mappings.
  9. Click
    Next
     to configure a schedule and advanced options. Perform any of the following steps based on your requirements:
    1. Click
      Run this task on schedule
       and specify the schedule that you want to use. Alternatively, you can click
      Do not run this task on a schedule
       to run the task manually.
    2. Configure the email notification options.
    3. Configure a parameter file, if needed.
    4. Configure the advanced source properties.
    5. Specify the execution mode.
  10. Save the
    synchronization
     task. You can choose one of the following save options:
    • Click
      Save and Close
       to save and close the task.
    • Click
      Save and Continue
       to save the task and continue with configuring the task.
    • Click
      Save and Run
       to save and run the task immediately.
0 COMMENTS
We’d like to hear from you!