Skip to main content

SOA 12c : How to read a file using File Adapter


In this post I will explain how to read, delete, and archive a file from any location. This post will also explain reading content of file in 12c and configuration of NXSD (Native Format Builder). This post can be applicable for SOA 11g also.


File Adapter Configuration :

Drag File Adapter to Exposed Services section :























Enter file adapter JNDI Name






















File Adapter have multiple operations read, write, sync and chunked read operations. Here we are using read operation.






















Enter file source and archive location. If you don't want to archive any file, uncheck the Archive check box.
























Specify File name pattern to read files based on any pattern.
























Set Polling frequency. Polling frequency is the interval in which adapter will read the file from the particular location.






















Now we need to define an NXSD schema, to convert the file data to XML format.






















Click on the icon to define schema for Native format.





















We are using here a comma separated file. So choose Delimited option here.




















Select sample file to generate xsd.


























































Schema will be generated based on input file.




















Click finish. And finish the adapter configuration.





Create a Bpel process to read get data from file adapter.
Drag a BPEL Process Under Components section. Change Bpel name and assign your input variable and click Ok.




















Drag a wire from readFile adapter to BPEL process to connect it.



Deploy the composite to SOA server. Now we are ready to test our service.
Put a file into your source location.









The file will be picked up in 1 minute as our polling frequency is 1 minute.
The file should be deleted and archived in the archived folder mentioned while configuring file adapter.








File has been archived.








Now login to SOA EM console and check for the instance created





Comments

Popular posts from this blog

Difference between OSB 11g And OSB 12c

In this blog I will walk  you  through from the new features of OSB 12c as well as the difference between OSB 11g and 12c. Following are the differences between OSB 11g and 12c : In the new version Oracle Service Bus (OSB) is renamed as Service Bus. Eclipse tool is needed to develop an interface in OSB 11g where as JDeveloper tool is needed to develop an interface in OSB 12c.  Oracle has integrated OSB 12c with JDeveloper. Now there is no need of Eclipse to develop an interface in 12c. Graphical representation of OSB components are similar to SOA BPEL components. Pipeline is separated from proxy service and it is separate component in 12c. To perform operations on database, ftp and files, it is no longer required to configure adapters in JDeveloper and copy it to Eclipse, because OSB 12c service is developed using JDeveloper only.

How to generate a unique id in XSLT

In this post I will explain you how to generate a unique Id in XSLT. To Generate a unique id in XSLT use oraext:generate-guid() function. See below screen shot to generate unique id in XSLT : Result of XSLT : The function oraext:generate-guid() has generated a unique Id as 2d333136303937343532313436323038. Similarly for each run this function will generate different unique Ids.