Preface
Informatica Resources
Informatica Documentation
Cloud Data Integration Web Site
Cloud Data Integration Communities
Cloud Data Integration Marketplace
Cloud Data Integration Connector Documentation
Informatica Knowledge Base
Informatica Cloud Trust Site
Informatica Global Customer Support
Part I: Introduction to SAP Connector
Introduction to SAP Connector
SAP Connector Overview
Informatica Cloud and SAP Integration Methods
Data Integration using SAP Tables
Data Integration Using BAPI/RFC Functions
Data Integration Using IDocs
Communication Interfaces
SAP Metadata Utility
Part II: SAP Connector Administration
SAP Connector Administration
SAP Connector Administration Overview
SAP Table Connector Administration
Step 1. Verifying if the Required Licences are Available for SAP Table Connector
Step 2. Downloading and Installing the Microsoft Visual C++ Redistributable
Step 3. Downloading and Configuring the Libraries for Table Read and Write
Step 4. Configuring sapnwrfc.ini
Step 5. Configuring SAP User Authorization
Step 6. Installing SAP Table Connection Transport Files
Step 7: Configuring HTTPS
Step 8: Configuring the Secure Agent as a Whitelisted Host in SAP (Optional)
SAP IDocs and RFCs/BAPI Connector Administration
Step 1. Verifying if the Required Licences are Available for SAP IDocs and RFCs/BAPI Connector
Step 2. Downloading and Installing the Microsoft Visual C++ Redistributable
Step 3. Downloading and Configuring SAP Libraries for IDoc and BAPI/RFC
Step 4. Configuring sapnwrfc.ini
Step 5. Defining SAP Connector as a Logical System in SAP
Step 6. Configuring SAP User Authorizations
Step 7. Installing and Configuring the SAP IDocs Metadata Utility
SAP BW Connector Administration
Step 1. Verifying if the Required Licences are Available for SAP BW Connector
Step 2. Downloading and Configuring the Libraries for SAP BW Data Extraction
Step 3. Installing SAP BW Reader Transport Files
Step 4: Configuring HTTPS
SAP BW BEx Query Connector Administration
Step 1. Verifying if the Required Licences are Available for SAP BW BEx Query Connector
Step 2. Downloading and Configuring the Libraries for SAP BW BEx Query Data Extraction
Part III: Connections
SAP Connections
SAP Connections Overview
SAP Table Connections
SAP Table Connection Properties
SAP Connection Rules and Guidelines
SAP IDoc and BAPI/RFC Connections
SAP RFC/BAPI Interface Connection Properties
SAP IDoc Reader Connection Properties
SAP IDoc Writer Connection Properties
SAP BW Reader Connections
SAP BW Reader Connection Properties
SAP BW BEx Query Connections
SAP BW BEx Query Connection Properties
Creating an SAP Table Connection
Creating an SAP IDoc Reader Connection
Creating an SAP IDoc Writer or SAP RFC/BAPI Interface Connection
Creating an SAP BW Reader Connection
Creating an SAP BW BEx Query Connection
Troubleshooting
Troubleshooting
SAP Table Connection Errors
Part IV: Data Integration Using SAP Table
SAP Table
SAP Tables and Views
Rules and Guidelines for SAP Sources and Targets
Data Synchronization Tasks with SAP Table
Data Synchronization Tasks with SAP Table Overview
SAP Table Sources in Data Synchronization Tasks
SAP Table Lookups in Data Synchronization Tasks
Configuring a Data Synchronization Task with a Single SAP Object as the Source
Configuring a Data Synchronization Task with Multiple SAP Objects as the Source
Monitoring a Data Synchronization Task
Data Synchronization Task Example
Step 1: Define the Data Synchronization Task
Step 2: Configure the SAP Table Source
Step 3: Configure the Flat File Target
Step 4: Configure the Field Mapping
Mappings and Mapping Configuration Tasks with SAP Table
Mapping and Mapping Configuration Tasks with SAP Table Overview
SAP Table Sources in Mappings
SAP Table Lookups in Mappings
Configuring a Mapping with an SAP Table Source
Creating a Mapping Configuration Task
Mapping with an SAP Table Source Example
Step 1: Define the Mapping
Step 2: Configure the SAP Table Source
Step 3: Configure the Flat File Target
Step 4: Save the Mapping and Create a Mapping Configuration Task
Part V: Data Integration Using BAPI/RFC Functions
BAPI/RFC Mapplets
BAPI/RFC Mapplets Overview
BAPI/RFC Mapplet Parameters
BAPI/RFC Parameter Properties
BAPI/RFC Functions with Nested Structures
System Variables
Integration ID in BAPI/RFC Mapplet
Target Object for BAPI/RFC Error Output
Rules and Guidelines for BAPI/RFC Mapplets in Mappings
Mapping and Mapping Configuration Tasks Using BAP/RFC Functions
Mapping and Mapping Configuration Tasks Using BAPI/RFC Functions Overview
Generating a BAPI/RFC Mapplet
Configuring a Mapping with a BAPI/RFC Mapplet
Mappings with BAPI/RFC Function Example
Step 1: Generating a BAPI/RFC Mapplet in Informatica Cloud for the BAPI_SALESORDER_CREATEFROMDAT1 BAPI Function
Step 2: Configuring a Mapping with the bapi_salesorder_createfromdat1 Mapplet
Part VI: Data Integration Using IDocs
IDoc Mapplets
IDoc Mapplets Overview
Segments and Groups
Segment and Group Status
IDocs Properties
Outbound Mapplet
Outbound Mapplet Ports
Target Object for Outbound Mapplet Error Output
Inbound Mapplet
IDoc Primary and Foreign Keys
Importing IDoc Metadata
Mapping and Mapping Configuration Tasks Using IDocs
Mapping and Mapping Configuration Tasks Using IDocs Overview
IDoc Reader Sources in Mappings
Importing an IDoc Mapplet to Informatica Cloud
Configuring an Outbound Mapping to Read IDocs from SAP
Configuring an Inbound Mapping to Write IDocs to SAP
Outbound Mapping to Read IDocs from SAP Example
Step 1: Importing MATMAS IDoc Metadata
Step 2: Importing the MATMAS04_Interpreter_Mapping Mapplet to Informatica Cloud
Step 3: Configuring an Outbound Mapping with the MATMAS IDoc
Inbound Mapping to Write IDocs To SAP Example
Step 1: Importing MATMAS IDoc Metadata
Step 2: Importing the MATMAS03_Prepare_Mapping Mapplet to Informatica Cloud
Step 3: Configuring an Inbound Mapping with the MATMAS IDoc
Part VII: SAP BW Data Extraction
Data Synchronization Tasks with SAP BW
Data Synchronization Tasks with SAP BW Overview
SAP BW Sources in Data Synchronization Tasks
Configuring a Data Synchronization Task with a Single SAP BW Object as the Source
Monitoring a Data Synchronization Task
Mappings and Mapping Configuration Tasks with SAP BW
Mappings and Mapping Configuration Tasks with SAP BW Overview
SAP BW Sources in Mappings
Configuring a Mapping with a Single SAP BW Source
Creating a Mapping Configuration Task
Monitoring a Mapping Configuration Task
Part VIII: SAP BW BEx Query Data Extraction
Mappings and Mapping Configuration Tasks with SAP BW BEx
Mappings and Mapping Configuration Tasks with SAP BW BEx Overview
Prerequisites
SAP BW BEx Sources in Mappings
Advanced Source Properties in Mappings
Configuring a Mapping with a Single SAP BW BEx Source
Creating a Mapping Configuration Task
Monitoring a Mapping Configuration Task
Mapping and Mapping Configuration Task Example with SAP BW BEx Query
Rules and Guidelines for SAP BW BEx Query Operations
SAP Data Type Reference
SAP Data Type Reference Overview
SAP and Transformation Data Types
SAP BW and Transformation Data Types
Preface
SAP BW and Transformation Data Types