Prerequisite:-
Bellow components should be installed on your system:-
1)
Oracle Data Integrator 11g
2)
Oracle
Weblogic 10.3.6
About this
project:-
One of the most striking features in ODI is its
ability to fully integrate into a SOA (Service Oriented Architecture)
environment. Data services expose the enterprise data and make it
available to users in the form of a web service. Using ODI, you can both
create data services and then consume them via web services. I will explain to
how to create and deploy a data service in Oracle Data Integrator.
Connect to ODI_STAGE schema by using sqldeveloper
Create table
create table
KSTUDENT(
studentid int primary
key,
studentname
varchar(20)
);
Then
create physical and logical schema for oracle technology in ODI.
Under Technologies
in the topology navigator, select JAX-WS and create a new data server,
physical and logical schema as follows
Create new JDBC data source for schema
Start the
weblogic server and make sure it is in Running mode. Log on to the
Weblogic console
Start the weblogic
server and make sure it is in Running mode. Log on to the Weblogic
console (the default URL for the Weblogic console is http://localhost:7001/console)
and navigate to Services –> Data Sources
Create a new Generic Data Source
and name it JDBC KE. AS JNDI name we mention jdbc/KE
Click on both
server
Now you can
see your Data Source you just created(JDBC KE)
Then import
knowledge module as shown in given image.
Click on
ODI_STAGE model folder
Go to the
service tab and add the following details.
Finally, click the Generate and deploy
option and your data service will be successfully deployed in the autodeploy folder!
Click on the
Deployment options in EM console of weblogic.
Click on
below lick
By clicking
first link you can see WSDL file for your Data Service & By using second link
you can test your service.
Add Operation
Add Operation
Update
operation
Delete
Operation
