Activating the ABAP Extraction Program in SAP for Multiple DataSources
Activating the ABAP Extraction Program in SAP for Multiple DataSources
Informatica ships a
DataSourceMassActivation.xml
mapping that you can use to simultaneously activate the ABAP extraction program in SAP for multiple DataSources.
Before you use the DataSource mass activation mapping, create an SAP ECC connection to connect to the SAP source from which the listener session extracts data. You must also create an SAP RFC/BAPI connection to make BAPI/RFC function calls and activate the ABAP extraction program in SAP for multiple DataSources.
The DataSource mass activation mapping contains the following components:
Sources
The mapping contains a flat file and the SAP ROOSOURCE table as sources. You must create a flat file source in the PowerCenter source directory and list the names of the DataSources for which you want to activate the ABAP extraction program in SAP.
Transformations
The mapping contains a Joiner transformation, an Expression transformation, and a BAPI/RFC transformation.
The Joiner transformation joins the flat file source and the SAP ROOSOURCE table to fetch the DataSource details. It matches the DataSource name in the flat file with the SAP ROOSOURCE table to fetch DataSource details such as the DataSource type.
The Expression transformation contains details such as the language, transfer mode, and logical system that you use to activate the ABAP extraction program in SAP. It contains the following ports that you can edit:
SCALAR_INPUT_I_TFMETHODE
Defines the transfer mode. Default is T. To use the IDoc transfer mode, enter the value as I.
SCALAR_INPUT_I_LANGU
Defines the language. Default is E, which stands for English. To use a different language, enter the relevant language code.
SCALAR_INPUT_I_RLOGSYS
Holds the $$RLOGSYS mapping variable. You must create a parameter file and define the $$RLOGSYS mapping variable in the file. Set the variable value to the name of the SAP source from which the listener session extracts data. To change the logical system value, update the value of the $$RLOGSYS mapping variable in the parameter file.
The BAPI/RFC transformation makes the BAPI/RFC function calls to activate the ABAP extraction program in SAP.
Target
The mapping contains a flat file target to record the errors that are encountered in the DataSource mass activation process.
When you import the DataSource mass activation mapping, an associated session also gets imported. After you import the mapping, you must generate and install the R/3 code in SAP. Then, edit the session to include the SAP ECC connection and RFC/BAPI connection. Run the session to simultaneously activate the ABAP extraction program in SAP for multiple DataSources.
Import the
DataSourceMassActivation.xml
mapping from the Repository Manager.
Navigate to the PowerCenter source directory and create a flat file source.
In the flat file source, enter the names of the DataSources for which you want to activate the ABAP extraction program in SAP.
Open the session that is associated with the DataSource mass activation mapping.
In the session properties, set the source filename property to the name of the flat file source.
Create a parameter file and define the $$RLOGSYS mapping variable in the file. Set the variable value to the name of the SAP source from which the listener session extracts data.
Click
Mappings
Generate and Install R/3 Code
.
The
Generate and Install
dialog box appears.
Enter the connect string, user name, password, client, and language to connect to the SAP source system.
Click
Connect
.
The DataSource mass activation mapping appears.
Select the DataSource mass activation mapping and click
Direct Installation
.
In the session properties, select the SAP ECC and RFC/BAPI connections.
Start the listener workflow.
Run the listener session.
The ABAP extraction program is activated in SAP for the DataSources that you specified in the flat file source.