Step 3: Test the migrated application to Oracle Database adapter
Time to complete: 5 minutes
Objective: In this step, you will test the migrated application by performing an Insert operation on the SCOTT.CUSTOMER table. To do this, you drop a request message that conforms to the schema generated using the vPrev Oracle Database adapter.
Prerequisites
Configure the BizTalk application by mapping the logical ports in the BizTalk orchestration to physical ports in the BizTalk Server Administration console.
Configure the BizTalk application to use the WCF-Custom send port for the WCF-based Oracle Database adapter.
To test the migrated application
From the Oracle_Migration folder, copy the OracleInsert.xml request message. This request message conforms to the schema generated by the vPrev Oracle Database adapter. Using the outbound map, the WCF-Custom send port converts this to conform to the schema for the WCF-based Oracle Database adapter and sends it to the Oracle database.
<ns0:Insert xmlns:ns0="http://schemas.microsoft.com/[OracleDb://ADAPTER/SCOTT/Tables/CUSTOMER]"> <ns0:Rows> <ns0:InsertRecord> <ns0:NAME>Customer_1</ns0:NAME> <ns0:STREET>Street_1</ns0:STREET> <ns0:CITY>City_1</ns0:CITY> </ns0:InsertRecord> <ns0:InsertRecord> <ns0:NAME>Customer_2</ns0:NAME> <ns0:STREET>Street_2</ns0:STREET> <ns0:CITY>City_2</ns0:CITY> </ns0:InsertRecord> </ns0:Rows> </ns0:Insert>
Paste the request message to the folder mapped to the file receive location.
The orchestration consumes the request message and sends it to the Oracle database. The response from the Oracle database is received in the schema that conforms with the schema of the WCF-based Oracle Database adapter. Using the inbound map, the WCF-Custom send port converts this to the schema for the vPrev Oracle Database adapter. The response from the Oracle database is saved to the other file location defined as part of the orchestration. The response for the preceding request message is:
<?xml version="1.0" encoding="utf-8"?> <ns0:InsertResponse xmlns:ns0="http://schemas.microsoft.com/[OracleDb://ADAPTER/SCOTT/Tables/CUSTOMER]"></ns0:InsertResponse>