Assign the following expression to SAPSIEBEL element. This assign activity will be used to retrieve the corresponding xref values for Custom xref tables. Add an assign activity before invoke activity which will be used to retrieve the values from xref table. Xref:populateXRefRow("SAP_SIEBEL_ORDER.xref","SAP",bpws:getVariableData(‘inputVariable’,’payload’,’/ns2:customer/ns2:SAP’),"SIEBEL",bpws:getVariableData(‘inputVariable’,’payload’,’/ns2:customer/ns2:SIEBEL’),"ADD") Add the following expression language to upload to XREF custom table. Here status of the xref upload will be stored. Assign xpression language to STATUS variable. Here you will push the data into xref tables Create an Assign activity between receiveInput and invoke write activity. Create a File adapter to write the details into local folder. Create a BPEL process with the following details. This will create the xref definition as shown below. Click on Run and select the connection – the table should be created under the SOAINFRA schema. 
If the table exist already then select the option Generate Drop DDL also.
Save the DDL to a file and run it through a SQL tool or Click on Run to directly run it from here. Table name should begin with ‘xref_’ and cannot be ‘xref_data’ or ‘xref_deleted_data’ which are reserved table names for XREF runtime. From the Optimize list, select Yes in the Cross Reference Editor. In the End System fields, enter the end system names(SIEBEL and SAP). In the File Name field, specify the name of the cross reference file(SAP_SIEBEL_ORDER.xref). Select Cross Reference (XREF) from the Items section. 
Select SOA Tier from the Categories section, and then select Transformations.Right-click the project and select New.
0 kommentar(er)
