How to consume WCF service in Oracle and siebel server ?

Question

User-1354082659 posted

Hi,

 I am newbie to WCF and now I am creating a new WCF service application where i have a requirement to use these services using webserver,oracle server and siebel server  .I am using Xml serialization instead of data serializattion. Which Binding I should prefer ,Is there any extra configuration required to achieve this ?

Answer 1

User2090018953 posted

Have you checked this article 

http://www.c-sharpcorner.com/uploadfile/anavijai/how-to-create-wcf-service-to-retrieve-data-from-the-oracle-database/

Answer 2

User-1354082659 posted

This is not my requirement.I want to create wcf Service and  to access the service   from oracle applications .Oracle apps will be my wcf client.

Answer 3

User220959680 posted

want to create wcf Service and  to access the service   from oracle applications .Oracle apps will be my wcf client.

This tutorial covers developing WCF Data Services and Open Data Protocol (OData) applications for the Oracle Database using Visual Studio. Any WCF service that is interacting with Oracle database can be consumed in Oracle client application that is Interacting with Oracle database. 

In other words 'WCF service is middle layer between the Oracle database and Oracle client application.

Refer http://download.oracle.com/oll/obe/EntityFrameworkWCF/WCFEntityFramework.htm

Answer 4

User-1354082659 posted

I will explian in detail.I want to create gateway application using wcf to perform message sending service.Three type of clients will use my service webserver,oracle server and siebel server.I will get xml request from these client servers and I will perform the tasks.I am using 'wshttp binding' .Planning to host Service in IIS.

Is there any extra configuration required in my web config other than this ?

 

<system.serviceModel>
<behaviors>
<serviceBehaviors>
<behavior name="MyServiceTypeBehaviors">
<serviceMetadata httpGetEnabled="true"/>
<serviceDebug includeExceptionDetailInFaults="false"/>
</behavior>
</serviceBehaviors>
</behaviors>
<services>
<service name="Gateway.Gateway" behaviorConfiguration="MyServiceTypeBehaviors">
<endpoint address="" binding="wsHttpBinding" contract="Gateway._IEmail"/>
<endpoint contract="IMetadataExchange" binding="mexHttpBinding" address="mex"/>
</service>
</services>
</system.serviceModel>

Answer 5

User-488622176 posted

Please check these:

• http://www.oracle.com/technetwork/articles/soa/oracle-msft-interoperate-183511.html
• http://wingdspur.com/2013/02/wcf-custom-binding-client-setup/
• http://wcf.codeplex.com/wikipage?title=WCF%20Express%20Interop%20Bindings%20Walk%20Through
• http://msdn.microsoft.com/en-us/library/dd787909(v=bts.10).aspx

Other direction:

• http://www.oracle-base.com/articles/10g/utl_dbws-10g.php
• https://forums.oracle.com/thread/1119627

Using basichttpbinding & soap should od the trick. The complexity is much more on oracle side...