• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

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




WINSCP (or) FILEZILLA à using for create 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. Resource.cd  2

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

  • Resource.cd à 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 shown 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 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 Indepth knowledge on Oracle SOA, click on below

Review Date
Reviewed Item
How to work with FTP(File transfer protocol) in Oracle SOA
Author Rating

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on How to work with FTP(File transfer protocol) in Oracle SOA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.