How to work with FTP (File transfer protocol) in Oracle SOA
Tool:
WINSCP (or) FILEZILLA à using for creating username and password
- Request to the admin
Admin a. Create a folder
- Permission to a folder(read and write)
- access user name and password
- IP address
- Console
FTP adapter(configuration)
Hostname :
Port:
User name:
Password:
- J developer
FTP adapter
- get
read
- put
write
- synchronous get
syn read
- List files
list files
FTP Adapter configuration:
1. Install Filezilla (or) WINSCP
Open – Filezilla
4th option general
Click add users(username) ex: filezilla243
Password : welcome1 (note: 3 characters)
Click shared folders(left side)
Add
Folder path(ex: D:// FTP _ Remote)
- Read
- Write
- Delete
- Append
- Create
- Delete
- List
- Sub dirs
ok
2. 7001/console
Deployment FTP adapter
configuration
Out band connection pool new
Javax. Resource.cd
JNDI Name(eis.FTP.Ramesh1) finish
- Resource.cd à expand
Eis.FTP.Ramesh1 click
Use the next button multiple times and set the property value of user name, password, port, hostname
Inclined to build a profession as Oracle SOA Developer?
Then here is the blog post on Oracle SOA Training Online.
Note: In case of no password, FTP uses public/private key
- Authentication type
- Host
- Private key file
- User name
- Use stop
Ex:
- User name = filezilla user name (ex: file Zilla 243)
- Password = filezilla Password (ex: welcome1)
- Port = 21 (default)
- Hostname = localhost /192.168.121.3 (default)
Save Deployment
FTP adapters
update
Deployment port path : C:/Oracle /middleware/Oracle SOA1/SOA/connectors/plan.XML
Next Next
finish
A1:
i/p invoke i/p
A2:
o/p “success”
FTP – put adapters:
5-8 put file
6-8 direction path for o/p, filename (put.txt), append
7-8 native format
Sample txt:
123 sai Teja
143 Ramesh Reddy
Project: (FTP _get ) poll
FTP get adapters:
6-10 Directory for incoming files (physical path)
9 -10 Native format incoming file
Transform 1:
Receive i/p ?
invoke i/p variable
Project:
XSD:
o/p directory size
string
filename string
Directory string
Modified time string
Creation time string
File size string
A1:
i/p invoke i/p
A2:
Invoke o/p o/p
FTP list files Adapters:
6-8 incoming file path
Note:
We want to write the o/p in our system then we add invoke between “invoke _ FTP” and “A2”.
MISSING LINE PG:117
Project (FTP _synchronous get)
MDS (Meta Data service)
- File-Based MDS
- CB based MDS
File-Based MDS:
C:/oracle /middleware/ J developer/ integration /seed/apps
Note: this ”apps” folder creates ourselves self and the folder name must give apps don’t five other names.
Apps subfolders(XML, XSD, XSLT, WSDL)
Example:
- XML (fault buildings.XML, fault policies .XML)
- XSD (PO.XSD, Internal order.XSD)
Note:
If the server is not working, then we are using “file-based mds”
File-Based MDS creation:
View resource palette
New connection ----> SOA – MDS
Connection name(file-based – MDS) , connection type (file-based MDS) browse
(C:/oracle/middleware/ j developer/..../seed)
select ‘seed’
text connection àok
XML,XSD,XSLT,WSDL(central repository reused assets/artefacts)
Note: All projects WSDL keeping in the OER folder(11g)
DB Based MDS:
- Jar (java archives) XSD’s, XML’s, XSLT’s, WSDL’s
- SOA Bundle
- Deploy into server
1. Jar:
Create new project Select – generic project
Project name (DB based - MDS) finish
Note: this name doesn’t show is a server, only files show on the server
Right-click on projectnew
click
Select Deployment + profiles
Select JAR file
ok
Deployment profile name (DB Based – jar ) ok
Click on contributors and unmark project o/p directory
project dependencies
Add browse
(c:/oracle/middleware /...../apps)
Ok
Click on filters
ok
ok
Note : select or remove XML,XSD....
2. SOA Bundle:
Select – project(DB based - mds) Click
New
click
Select – deployment profiles, SOA bundle ok
Deployment profile name/DB Based – bundle -ok
Select – dependences, DB based _ jar ok
ok
3. Deploy into the server:
Select project (DB based _ MDS)
Click Deploy – DB Based
(Deploy to SOA Bundle) next
next
Finish
Select project (DB Based _MDS) Click
Deploy – DB Based – Bundle Deploy to application server
next
next
App_ server _ Ramesh1 next
default
next
finish.
DB Based MDS creation:
View ----> resource palette database -
right-click
new DB connection
connection name(RCU_ MDS), Username(dev_ MDS), password(welcome1)
Test connection ok
View resource palette
Click new connection
SOA _MDS
Connection name(DB Based _MDS), connection Type(DB Based MDS), connection (RCU_MDS), select MDS Partition(SOA _ Infra ) test connection
ok
Note:
MDS - 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 the project it shows test suites)
2 types of testing
- Auto motion testing
- Manual testing(our doing)
- Actual value = Expected value à test case pass
- Actual value = ! Expected value à test case
- An assertion is a 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
Change:
<CC number>1234-1234-1234-1234</CCnumber>
<Amount>20,000</amount>
Ok
Case 1: we are giving dummy input to the process
Case 2: Data do not send to the DB _select, but it gives dummy o/p
For In-depth knowledge on Oracle SOA, click on below
- Oracle SOA ATA (Application Integration architecture)
- Oracle SOA Interview Questions & Answers
- Oracle SOA Admin Interview Questions
- Oracle SOA Tutorials