Loading Data from BW Open Hub Table to SQL using BODS
In this job we need to import open hub table from BW system to BODS. Make sure that RFC connection from BW to BODS is established properly and is running successfully. Before executing the BODS job all the objects in BW should be activated. The steps for creating and importing open hub table from BW to BODS are:
Step 1: Log on to SAP GUI and type T-Code RSA1.
Step 2: Click on Open Hub Destination under Modelling tab which is in the left pane. Right click on the Info Area created and select Create open Hub Destination.
Step 3: Provide the name for OHD and its description. Also provide the object name which could be info cube or DSO or multi provider or info object etc., and its corresponding name. Enable create transform and DTP option, it will create transformation and DTP while we activate the OHD table. Click OK.
Step 4: Select third party tool in destination type and provide RFC destination which is running successfully from BW to BODS.
Step 5: Activate the OHD table.
Step 6: Click on OHD created and double click on DTP and activate it.
Step 7: Go to T-code RSPC. Right click on Process chains header and create display component.
Step 8: Provide a name for application component and its long description.
Step 9: Now right click on application component and select create process chain.
Step 10: Provide a name for process chain and its long description. Click ok.
Step 11: Click on the highlighted option to create process variant.
Step 12: Provide a name for process variant and its long description. Click ok.
Step 13: Select start using meta chain or API option and save it and go back.
Step 14: Click ok.
Step 15: Provide the DTP technical name which was created during the activation of OHD. Click Ok.
Step 16: Provide connection from start to DTP and activate it.
Step 17: Logon to BODS. Go to datastores tab in local object library and right click on free space and select new.
Step 18: Select datastore type as SAP BW Source. Provide the details of application server, user name and password of BW. Click on advanced option and provide details of client number, system number. Select data transfer method as RFC and provide RFC destination name. Provide routing string of BW server. Click on apply and then select ok.
Step 19: Now expand the datastore and right click on open hub tables and select import by name.
Step 20: Enter the OHD table name which we have created at BW side and select import.
Step 21: Create a job in project area after selecting a project. Drag and drop workflow inside the job. Double click on work flow and drag and drop data flow. Double click on data flow and drag and drop OHD table which we have imported as source. Create a template table as a target. Connect source and target using query transform. Map the columns from input schema to output schema inside the query transform.
Step 22: Double click on OHD table. Click on execute process chain before reading and provide the corresponding process chain name which we have created.
Step 23: Logon to Management console and select administrator. In administrator expand SAP Connections and select RFC Server Interface and select the corresponding RFC connection and click on start.
Step 24: At BW side enter T-code as SM59 and select the corresponding RFC in TCP/IP connections.
Step 25: Click on connection test. If connection test is successful then execute the job in BODS.
Step 26: After the job is executed we can see that BODS job triggers the process chain.