BIP TO ATP Through OIC

BIP TO ATP DB Through OIC

Connections Required

v  SOAP Connection – External Report Web Service (WSS)

v  ATP DB Connection

Process Flow

step-1: Creating Integration for Running BIP Report

step-2: Create an Integration using Scheduled Orchestration                                                                                    

  

Ø  After selecting the schedule orchestration have to provide appropriate name then click on create.

step-3: Use the SOAP Connection to connect with the External Report WSS Service

step-4: Select the "Run Report" operation to call BIP Report

step-5: Configuring the Mapper here we need to pass information which necessary to call BIP  

Ø  Attribute Format: Defines the output format of the report.(XML\CSV)

Ø  Size of Data Chunk Download: Set to `-1` to retrieve the complete report data.

Ø  Report Absolute Path: Provide the exact path of the report along with the `.xdo` extension.

 

step-6: Establish an Stage File action [To convert Base64 data{Report Bytes} into Redable format]

Ø  Use “Write File” operation

Ø  Specify the file name and output directory for temporary storage

Ø  Select XSD Document {To convert data into redable format}

Ø  Upload Opaque Schema  by downloading below link           

save below content as OpaqueSchema.xsd file 

<?xml version = '1.0' encoding = 'UTF-8'?>  

<schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/"

            xmlns="http://www.w3.org/2001/XMLSchema" >

      <element name="opaqueElement" type="base64Binary" />

    </schema>

Ø  automatically it will select the schema element

 

step-7: Again need to establish an Stage File action [To specify the particular structure to the file]

 

Ø  Use “Read Entire File” operation

Ø  Specify the file name and output directory {what ever we provided in the previous stage file action}

Ø  Choose Sample delimited document (e.g. CSV)

Ø  Here we need to choose which file we need to convert into redable format

Ø  Upload exported CSV File

Ø  As well as provide Record Name and Recordset Name

step-8: Configuring the mapper

Ø  Draw map between Report Bytes(Source) To Opaque schema(Target)

step-9: Use ATP connection [Autonomous Transaction Processing] to insert data into custom ATP tables

 

Ø  Select Perform an Operation On a Table[Based on requirement it will be change] among below options 

1.      Invoke a stored procedure 
2.      Run a SQL Statement 
3.      Perform an Operation On a Table
4.      Seselet AI for SQL 

Ø  Choose Insert To insert data into custom ATP tables 

Provide the table name what we gave in the SQL Developer [Name is casesensitive]

Ø  Select schema ADMIN [ It will be based on your connection details]

step-10: Configuring the mapper

   

step-11 : Provide business identifiers then save and active the integration

 

Step-12:run integration

and check the inserted data in the oracle SQL developer