Webservice Vs Direct Connect to DB

[Former Member]

Experts,

In our application, we're connecting to legacy application using web service call. Here, I wanted to know the benefit of using Web Service call or direct connect to DB using Open SQL.

Please advice which one is best. Here I was not able to come to any conculsion.

Regards,

Ramki.

[Former Member]

Hi,

>Here I was not able to come to any conculsion.

Maybe you could think of what will happen if there is a structure change in a table ? This might help you to come to a conclusion...

Direct external access to a database is EVIL and should be avoided at any price.

By the way, if you access SAP data directly at database level, you loose SAP support...

Regards,

Olivier

[Former Member]

Hi Olivier,

For this cases, from SAP we're connected to external Oracle DB using OPEN EXEC.

In this scenarios, how we can treat it.

Regds,

Ramki.

[Former Member]

You should stop connecting directly to the external Oracle Database and write a web service (called by SAP) to access the data.

Regards,

Olivier

[Former Member]

Hi Olivier,

Kindly provide the reason for it. I'm aware of the impact. If would be very great, if u compose some reason for it.

Regards,

Ramki.

[Former Member]

Hi,

I already gave the reason in my previous posts.

Maybe you can try to think a little bit by yourself and not asking spoon feeding from SDN forum ?

Good luck,

Olivier