Business Trends
Creating an ODP ECC Source System
Operational Data Provisioning (ODP) provides a technical infrastructure to support data extraction and replication. For example, used to connect an SAP ECC system as the source system to a BW system. Communication is performed using remote function calls (RFC).
This article simply covers the creation of an ODP ECC source system within the SAP Business Warehouse (BW) system. I’ll produce follow-on articles that will cover the advantages and benefits of the ODP extractors from a data extraction and replication perspective.
The following are the steps to create an ODP ECC source system in a SAP Business warehouse system. Please note these steps need to be executed in all SAP BW systems across your landscape from Development to Production.
Open the BW Client.
Execute transaction SCC4 (Client Administration) and enter the following settings.
-
Changes and transports for client specific objects = Changes without automatic recording.
-
Cross-Client Object Changes = Changes to repository and cross client customizing allowed
Set system to modifiable
Execute transaction SE06 (Set Up Transport Organizer) and enter the following settings
-
Global settings = Modifiable
-
All Software components = Modifiable
-
All Name Spaces = Modifiable
Create a new Logical Systems
Execute transaction BD54 (Maintaining Logical Systems) and enter a new logical system. The naming convention should be in aligned with the existing ECC system name. For example, if the existing ECC system is REDCLNT100 then the new source system name could be REDODPC100. For this step you need to create a new entry and enter the following in BD54.
-
Log. System = REDODPC100
-
Name = REDODPC100
Create RFC connections
Execute transaction SM59 (RFC Destinations (Display/Maintain)) to create a new standard RFC connection and a new dialog RFC connection. Under the ABAP Connections folder, create a new standard RFC connection with the following (using example name above):
Header
-
RFC Destination = REDODPC100
-
Connection Type = 3 (ABAP Connection)
-
Description = ODPC Connection to RED 600
Technical Settings Tab
-
Load Balancing = Yes
-
Target System = RED
-
Msg Server = Message server of RED (can get this from SM59 connection details for REDCLNT100).
-
Group = server group (can get this from SM59 connection details for REDCLNT100).
-
Save to Database as = Select Host and enter message server details above.
Logon & Security
-
Client = 100
-
User = BIODPECC_RFC (can use existing RFC user from existing ECC connection or create a new one (clone of existing one) – for our scenario we created a new one to avoid issues with existing RFC user).
-
Pwd = Password for above RFC user
Under the ABAP Connections folder, create a new dialog RFC connection with the following (using example name above):
Header
-
RFC Destination = REDODPC100 _DIALOG
-
Connection Type = 3 (ABAP Connection)
-
Description = ODPC DIALOG Connection to RED 600
Technical Settings Tab
-
Load Balancing = Yes
-
Target System = RED
-
Msg Server = Message server of RED (can get this from SM59 connection details for REDCLNT100).
-
Group = server group (can get this from SM59 connection details for REDCLNT100).
-
Save to Database as = Select Host and enter message server details above.
Logon & Security
-
Client = 100
-
User = BIODPECC_RFC (can use existing RFC user off existing ECC connection or create a new one (clone of existing one) – for our scenario we created a new one to avoid issues with existing RFC user).
-
Pwd = Password for above RFC user
Create a new source system
Execute transaction RSA1 (Administrators workbench) to create a new source system. Select source system and ODP – SAP (Extractors) folder. On this folder right hand click and select create and enter the following parameters:
-
Logical System Name = REDODPC100
-
Source System Name = REDODPC100
In the following window select the following:
-
OPD Context = SAPI Data sources/extractors
-
BW Background User: ALEREMOTE
-
Password : ALEREMOTE Password.
On the next screen, the system asks – “Do you want the generated content versions to be updated now or later”. Please choose now.
Conversion of logical system names
Execute transaction RSA1 (Administrators workbench) and select tools from the menu and the Select Conversion of logical system names option. Create a new entry with the following values:
-
Original Source System = REDODPC100
-
Target Source System = ODP source system for test system or production (depending on what system you’re currently executing these steps in).
Assignment of Source system to Source system ID
Execute transaction RSA1 (Administrators workbench) and select tools from the menu and the Assignment of Source system to Source system ID option. Create a new entry with the following values:
-
Source system = REDODPC100
-
Source system ID Text = ECC Client 100
-
Source system ID = RB
Close the BW Client.
Execute transaction SCC4 (Client Administration) and enter the following settings.
-
Changes and transports for client specific objects = No Changes allowed
-
Cross-Client Object Changes = No Changes to Repository and Cross-Client Customizing allowed
Set system to not modifiable
Execute transaction SE06 (Set Up Transport Organizer) and enter the following settings
-
Global settings = Not Modifiable
-
All Software components = Not Modifiable
-
All Name Spaces = Not Modifiable
You have just set up a new ODP ECC Source System connection within your BW system!!
Hi,
Thanks for the article. Whay woudl be the difference if choose "ODP - BW" Folder.
Thanks,
Lucas
Hi Donal,
It is also crucuial to add the auth required for the user performing the setup and for the BW/source system users used in the RFCs.
Regards,
Jennah
Hello ,
should this step be done in ECC or in BW site?
Create a new Logical Systems
Execute transaction BD54 (Maintaining Logical Systems) and enter a new logical system. The naming convention should be in aligned with the existing ECC system name. For example, if the existing ECC system is REDCLNT100 then the new source system name could be REDODPC100. For this step you need to create a new entry and enter the following in BD54.
Log. System = REDODPC100
Name = REDODPC100
Thank you in advance
Elizabeth
Hi,
thanks for the article.
Just a question concerning the ODP_DIALOG connection.
You have inserted a user/PW which seems a kind of weird for me as in general for a dialog connection the current user is choosen. Otherwise it isn´t really a dialog connection, just a fix RFC connection.
Do you maybe have a hint where SAP provides a documentation how to setup this ODP_DIALOG connection and if the user/PW is really necessary?
Thanks in advance.
Marcus