Oracle Business Intelligence Publisher V1 midstream transformation in mappings
Before you configure a midstream transformation, you must create a business service. Select an Oracle Business Intelligence Publisher V1 connection and select an Oracle Business Intelligence Publisher operation when you create a business service.
Midstream transformation properties
When you configure the midstream transformation, select the business service and the operation on the Web Service tab.
When you select a midstream transformation, the Properties panel displays the following areas and information:
General
Use to configure the name and a description for the transformation.
Incoming Fields
Includes the field rules that define the data that you read from the source. Allows a preview of the source fields.
Web Service
Specifies the business service and the operation that you want to perform in the Oracle Business Intelligence Publisher application.
Request Mapping
Maps the incoming fields from a source file to elements in the request structure.
Response Mapping
Maps the selected elements from the response structure with the output fields. You can view the response structure on the Response Mapping tab. When you map the elements from the response structure to the output fields, the Secure Agent creates the output groups, along with the primary and foreign keys for the field names.
Output Fields
Displays the fields included in the mapping.
Advanced
The properties required to configure a midstream transformation.
Web Service properties
The following table describes the Web Service properties that you can configure for a transformation:
Property
Description
Connection
Name of the Oracle Business Intelligence Publisher V1 source connection.
Operation
Read operation for the source object.
The following table describes the advanced property that you can configure for a Web Service transformation using Oracle Business Intelligence Publisher V1 Connector:
Property
Description
DataFormat
The data format of the output.
You can select either the XML or CSV data format.
Ensure that you select the same format that you selected in the report output format in Oracle Business Intelligence Publisher application.
Default is XML.
Note: If you select the CSV data format for the output, you must specify the directory path value in the Output Directory connection property.
Midstream transformation advanced properties
The following table describes the advanced properties that you can configure for a midstream transformation:
Property
Description
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the request is more than 100 KB, you can increase the cache size.
Default is 100 KB.
Cache Size for Web Service Response (KB)
Memory available for the web service response. If the web service response contains many rows or columns, you might want to increase the cache size.
Default is 100 KB.
Allow Input Flush
Use this option to create XML after all the data is received.
Transaction Commit Control
Commit or rollback transactions.
Transformation Scope
Specifies the transformation logic applied to data.
Using Oracle Business Intelligence Publisher V1 Connector in a midstream transformation
To read data from an Oracle Business Intelligence Publisher V1 source, perform the following tasks:
1 Create an Oracle Business Intelligence Publisher V1 connection to read data from an Oracle Business Intelligence Publisher V1 source.
2In Data Integration, click New > Components > Business Sevices > Create.
The mapping designer appears.
3Add a Web Services transformation. Specify a name and description in the general properties.
The following image shows the source, web service, and target in the Oracle Business Intelligence Publisher V1 mapping:
4On the Web Service tab, select the business service and the operation that you configured.
The following image shows the configured web service:
5On the Request Mapping tab, map the incoming fields from the source to the elements of Request Structure to form a web service request:
The following image shows the fields that you map:
6On the Response Mapping tab, select the source details fields that you want to write to the target file on the Response Structure.
The following image shows the response structure and the output fields:
7On the Advanced tab, specify the cache size details.
The fields that you select from the Response Structure of the Web Service transformation appear as incoming fields for the target object.
8When you save and run the mapping, the Secure Agent reads the data that you map on the Request Mapping tab from Oracle Business Intelligence Publisher application and writes the data to the corresponding target.
