How to work with FTP (File transfer protocol) in Oracle SOA



WINSCP (or) FILEZILLA à using for creating username and password

  1. Request to the admin

Admin 2 a. Create folder

  1. Permission to folder(read and write)
  2. access user name and password
  3. IP address
  4. Console 2FTP adapter(configuration)

Host name :


User name:


  1. J developer 2 FTP adapter
  2. get 2 read
  3. put 2write
  4. synchronous get2 syn read
  5. List files 2 list files

FTP Adapter configuration:

  1. Install filezilla (or) WINSCP

Open – filezilla    2

4th option   2 general

Click add    2users(username)  ex: filezilla243

Password : welcome1 (note: 3 characters)

Click   2shared folders(left side)  2 Add  2

Folder path(ex: D:// FTP _ Remote)  2

  • Read
  • Write
  • Delete
  • Append
  • Create
  • Delete
  • List
  • Sub dirs   2ok

  1. :7001/console  2

Deployment2 FTP adapter 2 configuration  2

Out band connection pool 2 new  2

Javax.  2

JNDI Name(eis.FTP.Ramesh1) 2finish  2

  • à expand  2

Eis .FTP.Ramesh1  2 click

Use next button multiple times and set the property value of user name, password, port, host name

Interested in mastering Oracle SOA Training?

Enroll now for FREE demo on Oracle SOA Training.

Note: In case of no pass word, FTP uses public/private key

  1. Authentication type
  2. Host
  3. Private key file
  4. User name
  5. Use stop


  1. User name = filezilla user name (ex: file Zilla 243)
  2. Password = filezilla Password (ex: welcome1)
  3. Port = 21 (default)
  4. Host name = local host / (default) 2

Save  2 Deployment  2FTP adapters  2 update  2

Deployment port path : C:/Oracle /middle ware/Oracle SOA1/SOA/connectors/plan.XML

Next  2Next  2 finish



i/p 2 invoke i/p


o/p 2 “success”

FTP – put adapters:

5-8 2 put file

6-8 2 direction path for o/p, file name (put.txt), append

7-8 2 native format

Sample txt:

123 sai  teja

143  Ramesh Reddy

Project: (FTP _get ) poll


FTP get adapters:

6-10 2Directory for incoming files (physical path)

9 -10 2 Native format incoming file

Transform 1:

Receive i/p ? invoke i/p variable




o/p 2directory size 2 string

file name 2 string

Directory 2 string

Modified time 2string

Creation time 2string

File size 2string


i/p 2 invoke i/p


Invoke o/p 2 o/p

FTP 2 list files Adapters:

6-82 incoming file path


We want to write the o/p in our system then we add invoke between “invoke _ FTP”  and “A2”.


Project (FTP _synchronous get)


MDS (Meta Data service)

  1. File Based MDS
  2. CB based MDS

File Based MDS:

C:/oracle /middle ware/ J developer/ integration /seed/apps

Note: this ”apps” folder creates our self and folder name must give apps doesn’t five other name.

Apps sub folders(XML, XSD, XSLT, WSDL)


  1. XML (fault buildings.XML, fault policies .XML)
  2. XSD (PO.XSD, Internal order.XSD)


If the server is not working, then we are using “file-based mds”

File Based MDS creation:

View 2resource palette2 New connection ----> SOA – MDS

Connection name(file based – MDS) , connection type (file based MDS) 2 browse 2(C:/oracle/middleware/ j developer/..../seed)2select ‘seed’ 2 text connection àok

XML,XSD,XSLT,WSDL(central repository 2 reused assets/artefacts)

Note: All projects WSDL keeping in OER folder(11g)

DB Based MDS:

  1. Jar (java archives) XSD’s, XML’s, XSLT’s, WSDL’s
  2. SOA Bundle
  3. Deploy into server
  4. Jar:

Create new project2 Select – generic project

Project name (DB based - MDS)2  finish

Note: this name doesn’t show is server, only files shows in server

Right click on project2new 2 click

Select 2Deployment + profiles

Select 2 JAR file 2ok

Deployment profile name (DB Based – jar ) 2ok

Click on 2 contributors and unmark  project o/p directory 2 project dependencies

Add 2browse2 (c:/oracle/middle ware /...../apps)


Click on 2filters2 ok 2 ok

Note : select or remove XML,XSD....

  1. SOA Bundle:

Select – project(DB based - mds) 2 Click 2 New 2 click2

Select – deployment profiles, SOA bundle 2 ok 2

Deployment profile name/DB Based – bundle -2ok 2

Select – dependences, DB based _ jar 2 ok 2ok

  1. Deploy into the server:

Select project (DB based _ MDS) 2

Click 2Deploy – DB Based 2

(Deploy to SOA Bundle) 2next 2next 2 Finish

Select project (DB Based _MDS)2 Click 2

Deploy – DB Based – Bundle 2 Deploy to application server 2 next 2next 2

App_ server _ Ramesh1 2 next 2 default2 next 2finish.

DB Based MDS creation:

View ----> resource palette 2 data base -2right click 2 new DB connection 2 connection name(RCU_ MDS), Username(dev_ MDS), pass word(welcome1)

Test connection 2  ok

View 2 resource palette

Click 2new connection 2  SOA _MDS

Connection name(DB Based _MDS), connection Type(DB Based MDS), connection (RCU_MDS), select MDS Partition(SOA _ Infra )2 test connection 2ok


MDS -2 Only one server

OER (11g) Oracle Enterprise Repository à multiple server (or) MDS(Total company)

BSR(10g) Business service repository à multiple server (or) MDS(Total company)

Unit Testing (in project it shows test suites)

2 types of testing

  1. Auto mation testing
  2. Manual testing(our doing)

  • Actual value = Expected value à test case pass
  • Actual value = ! Expected value à test case


  • Assertion is must in real time
  • Input not given to the process we are given “Dummy input”.

If the client (or)DB – select is not ready to use but, we want to test the process that time we will use “unit testing”.

Project: CC validation


  • It automatically creates tests, inside test suites

Double click on valid _1234 .XML


Case 1:

Double click on CCvalidation _client

Generate sample à click


<CC number>1234-1234-1234-1234</CCnumber>



Case 1: we are giving dummy input to the process

Case 2: Data not send to the DB _select, but it gives dummy o/p



For In-depth knowledge on Oracle SOA, click on below