cancel
Showing results for 
Search instead for 
Did you mean: 

Databse as a Service

Former Member
0 Kudos

Hi,

I want to do a Oracle database to SAP scenario which will be synchronous but want to model database as a web service . Is it possible ? if so how ?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I want to do a Oracle database to SAP scenario which will be synchronous but want to model database as a web service . Is it possible ? if so how ?

Yes, it is possible. But why you not using JDBC to connect to DB? Any specific reason for such a design?

Regards,

Neetesh

Former Member
0 Kudos

reason is to move towards a more SOA sort of architecture and This service can be called by multiple legacy systems via PI ?

can we achieve this ?

Thanks

Former Member
0 Kudos

This service can be called by multiple legacy systems via PI ?

Well, no matter how you connect PI to that DB (JDBC / SOAP), still that DB system can talk to multiple legacy systems through PI

Former Member
0 Kudos

But how can SOAP be used to connect to a database.

Oracle - PI - SAP sync scenario

Former Member
0 Kudos

But how can SOAP be used to connect to a database.

Oracle - PI - SAP sync scenario

Basic steps are:-

1. create service description file (service.xml)

2. deploy the service file - after deployment, you will be able to see the WSDL

3. invoke the service

There will be a class which will have the code to open / close the DB connection. This will also be deployed along with the service file.

Get in touch with the web service team (if you have any in your company), to get this implemented properly.

Still I am not convinced for using DB as a web service

Hope this answers your query.

Regards,

Neetesh

Former Member
0 Kudos

in this case does PI need to generate wsdl or no ? since i guess sender soap adapter we would be utilizing

Former Member
0 Kudos

If it's an incoming message to PI, then PI will be generating and providing the WSDL to the web service team.

Former Member
0 Kudos

so in this case I generate wsdl ( send todatabase /web service team )since it is a message from database ( web service to to PI to SAP ) synch . On SAP side we might use Proxy or RFC to pull data.

Former Member
0 Kudos

Yes.

Former Member
0 Kudos

Not a good idea to use database as web service. but if you still want to do that, better ask your web service group to create the service for you.

if your queries has been answered, close this thread.

--Abhi

Answers (0)