DecipherMiddleware

 In SOA, we can connect with databases using a database jca adapter and configuring the data source and connection factory in the WebLogic server . Sometimes, we may want to query the database directly within the BPEL component or XSLT without configuring a database jca adapter. For such use cases, we can take leverage of database functions that can be used within BPEL Assign Activity or XSLT transformations . We have 3 different database functions available, that can be used in different use cases. oraeext:sequence-next-val() oraext:lookup-table() oraext:query-database() 1. oraext:sequence-next-val() Syntax: oraext:sequence-next-val(sequence as string, dataSource as string) sequence:  Specify the sequence available in the database for which the next value needs to be extracted. dataSource:  Specify the Data source JNDI name as configured in WebLogic server or JDBC string in the format  jdbc:oracle:thin:usern...

In cases, when we have many connections created on the OIC instance, it becomes hard to manage connections using the OIC console. Also, to achieve automation, manually going and updating each and every connection is never a feasible task. OIC provides various REST APIs to fetch connection details, update connection properties and delete connections. With the help of these APIs, we can overcome such scenarios. In this blog, we will be discussing how to use various OIC connections REST APIs. A postman collection in the public workspace, which contains some of the use cases for this and can be forked, updated, and used accordingly. Below are various REST APIs, that are covered in this blog. Retrieve Connections Retrieve a Connection Update a Connection Test a Connection Refresh Metadata for a Connection Delete a Connection In this blog, we will be using Postman to test and run various APIs. Below is the link to the Postman collection, w...

This tutorial is intended for the audience who are completely new to OSB and want to try a simple hello world kind of application. Instead of sending and receiving Hello World! . We will be using simple temperature conversion i.e. from Celsius to Fahrenheit and vice versa. We will be using simple Xquery to do all conversion and logic. High Level: In this case, our OSB component will contain 2 parts proxy service and pipeline. Proxy service will expose SOAP endpoint to the client application and pipeline will perform various operations on input payload. Since this is just a Hello World application, we will not be using business services. XQuery will be used to implement mathematical logic and conditional logic. Service will take temperature as input and will perform either Fahrenheit to Celsius (FtoC) or Celsius to Fahrenheit (CtoF) temperature conversion. If the conversion type is invalid, then the service will return a failure status. Mathematical Calculations: Let temperature in Fahr...

 While testing an XML response in postman, we need to convert XML data to JSON in order to traverse child nodes of an XML document. XML documents can be with/without namespaces. If XML documents have namespaces, then those are declared as attributes to the XML tag. There may or may not be prefixes associated with XML tags containing namespaces. There are different methods or ways to convert XML to JSON, a few of which are described in this blog. XML to JSON without namespaces -- using xml2Json XML to JSON with namespaces  -- using xml2js Postman version : 8.0.7 Libraries : xml2Json, xml2js XML to JSON without namespaces Let's assume we are getting the below XML response from Webservice. <ROOT> <Account> <name>Name1</name> <id>123123</id> <addres...

We can poll files at regular intervals from a remote ftp/sftp server location using Oracle JCA adapter for FTP , with help of GET operation. We can integrate oracle JCA FTP adapter with BPEL, mediator, or OSB 12c. In this article, we will be creating one OSB project that will demonstrate polling of files from remote FTP location using FTP adapter and writing the files to our local server location Note:  Using JDeveloper 12c (12.2.1.4). Pre-requisites: Connection factory configured in Weblogic server. User, configured in connection factory has the access to read and write files to target/from ftp location Steps: Let's start by creating a new project with the name "FTP_Polling". 1. Open "servicebus.sboverview" and drag FTP adapter from components palette to proxy services side. 2. Enter the adapter name and click on next. 3. In the next step, select Define from operation and schema (specified later). 4. Specify the JNDI of the connection factory (e.g. eis/Ftp/...