Performance of MFT Cloud Service (MFTCS) with File Storage Service (FSS) using a Hybrid Solution Architecture in Oracle Cloud Infrastructure (OCI)

Executive Overview MFT Cloud Service clusters in Oracle Cloud Infrastructure Classic (OCI-C) are provisioned with database file storage system (DBFS) for shared storage as discussed in one of our earlier blogs[1]. In Oracle Cloud Infrastructure (OCI), customers also have the option of using File Storage Service (FSS) for shared storage. FSS can be used for […]

Hybrid Cloud Integration with MFT Cloud Service and VPN Gateway in Oracle Public Cloud

Executive Overview MFT customers often receive files via SFTP in the MFT Cloud Service (MFTCS) and have a need to send those file across to an on-premise server. This can be achieved by using a secure VPN tunnel between the MFTCS Compute VM and the on-premise server. This blog describes a possible way to setup such a […]

Setup of PaaS Computes (SOACS/MFTCS/DBCS) over IP Network for VPN Connectivity

Executive Overview PaaS customers, in the past, have been able to provision their instances only over the flat network of Oracle Public Cloud (OPC). However, at present, support for PaaS computes with IP networks has been released. As a result, customers now have a choice to provision PaaS instances, e.g. SOA Cloud Service (SOACS), MFT […]

Remounting DBFS Shared Storage in SOACS and MFTCS Clusters

Executive Overview Oracle Database File System (DBFS) is used in providing shared storage mount points within SOACS and MFTCS clusters. DBFS provides a standard file system interface for directories and files on top of database tables[1] . So, by using the database running in the DBCS instance associated with any SOACS or MFTCS instance, DBFS […]

Configuring MFT WebCenter Content (UCM) Endpoints with SSL for Fusion Applications

Executive Overview Oracle MFT (Managed File Transfer) is a product component within Oracle Fusion Middleware Service Integration Platform. It can be effectively used to implement file-based use cases with HCM (Human Capital Management) application within Fusion Apps. Furthermore, MFT release 12.2.1 now has support for integrating Oracle Webcenter endpoints. This feature can be used for […]

EDI Processing with B2B in hybrid SOA Cloud Cluster integrating On-Premise Endpoints

Executive Overview SOA Cloud Service (SOACS) can be used to support the B2B commerce requirements of many large corporations. This article discusses a common use case of EDI processing with Oracle B2B within SOA Cloud Service in a hybrid cloud architecture. The documents are received and sent from on-premise endpoints using SFTP channels configured using […]

SOA Cloud Service – Quick and Simple Setup of an SSH Tunnel for On-Premises Database Connectivity

Executive Overview With the current release of SOA Cloud Service (SOACS) a common requirement often requested is to connect to an on-premise  database from the cloud SOACS instance. This article outlines a quick and simple method to establish the connectivity between the single-node SOACS instance and the on-premise database server using an SSH tunnel. Solution […]

MFT – Setting up SFTP Transfers using Key-based Authentication

Executive Overview MFT supports file transfers via SFTP. Often MFT customers receive a public key from their partners and want to use them to receive files via SFTP. This blog describes the setup required to enable such an MFT flow that would receive files from partners using key-based authentication. MFT includes an embedded SFTP server. […]

B2B Event Queue Management for Emergency

Executive Overview Many customers face a crisis in production system when, for some reason, they end up with several B2B messages stacked up in the system, that may not be of a high priority to be processed at that point in time. In other words, it would greatly help many customers if, in such critical […]

Running Built-In Test Simulator with SOA Suite Healthcare 11g in PS4 and PS5

Background SOA Suite for Healthcare Integration pack comes with a pre-installed simulator that can be used as an external endpoint to generate inbound and outbound HL7 traffic on specified MLLP ports. This is a command-line utility that can be very handy when trying to build a complete end-to-end demo within a standalone, closed environment. The […]

B2B Agreement Life-Cycle Management, Part 2 – Best Practices for High Volume Deployment of Agreements

Introduction In Part 1 of the B2B Agreement Life-Cycle Management Series, we looked at the best practices to import high volume of agreement metadata into the repository [1]. In this post, we will take a look at the best practices to deploy the agreement metadata for run-time processing. Background B2B 11g supports the notion of […]

SOA Suite for Healthcare Integration startup errors due to expired passwords.

Background
SOA Suite for Healthcare integration involves starting up the managed servers, which are in turn, dependent on valid connections to databases. In many low-maintenance environment like Virtualbox images distributed for training and worksh…

B2B Agreement Life-Cycle Management, Part 1 – Best Practices for High Volume CPA Import Operations with ebXML

Background

B2B 11g supports ebXML messaging protocol, where multiple CPAs can be imported via command-line utilities. 

This note highlights one aspect of the best practices for import of CPA, when large numbers of CPAs in the excess of several hundreds are required to be maintained within the B2B repository.

Symptoms

The import of CPA usually is a 2-step process, namely creating a soa.zip file using b2bcpaimport utility based on a CPA properties file and then using b2bimport to import the b2b repository.  The commands are provided below:

  1. ant -f ant-b2b-util.xml b2bcpaimport -Dpropfile=”<Path to cpp_cpa.properties>” -Dstandard=true
  2. ant -f ant-b2b-util.xml b2bimport -Dlocalfile=true -Dexportfile=”<Path to soa.zip>” -Doverwrite=true

Usually the first command completes fairly quickly regardless of the number of CPAs in the repository. However, as the number of trading partners within the repository goes up, the time to complete the second command could go up to ~30 secs per operation. So, this could add up to a significant amount, if there is a need to import hundreds of CPA in a production system within a limited downtime, maintenance window. 

Remedy

In situations, where there is a large number of entries to be imported, it is best to setup a staging environment and go through the import operation of each individual CPA in an empty repository. Since, this will be done in an empty repository, the time taken for completion should be reasonable. 

After all the partner profiles have been imported, a full repository export can be taken to capture the metadata for all the entries in one file. 

If this single file with all the partner entries is imported in a loaded repository, the total time taken for import of all the CPAs should see a dramatic reduction.

Results

Let us take a look at the numbers to see the benefit of this approach. With a pre-loaded repository of ~400 partners, the individual import time for each entry takes ~30 secs. So, if we had to import another 100 partners, the individual entries will take ~50 minutes (100 times ~30 secs). On the other hand, if we prepare the repository export file of the same 100 partners from a staging environment earlier, the import takes about ~5 mins.

The total processing time for the loading of metadata, specially in a production environment, can thus be shortened by almost a factor of 10.

Summary

The following diagram summarizes the entire approach and process.

Acknowledgements

The material posted here has been compiled with the help from B2B Engineering and Product Management teams.

Bidirectional Translation Web Services are now available in B2B 11g PS5 Release

Starting from SOA Suite PS5, bi-directional translation via web service is now available within the
base install of B2B 11g. The note here describes the basic usage details.

Tuning B2B Server Engine Threads in SOA Suite 11g

B2B Server Properties from EM console can be used to tune the thread configuration of the B2B engine to improve overall B2B performance.