Export (0) Print
Expand All

Connecting to the Oracle Database in Visual Studio

This section provides information about how to use the Consume Adapter Service Add-in, the Add Adapter Metadata Wizard, and the Add Adapter Service Reference Plug-in.

  • The Consume Adapter Service BizTalk Project Add-in is available in BizTalk Server projects. You use the Consume Adapter Service Add-in to generate message schemas (XSDs) for operations that you want to target in your BizTalk solution. For more information about developing solutions with BizTalk Server, see Developing BizTalk Applications.

  • The Add Adapter Metadata Wizard is available in BizTalk Server projects. You use the Add Adapter Metadata Wizard to generate message schemas (XSDs) for operations that you want to target in your BizTalk solution. For more information about developing solutions with BizTalk Server, see Developing BizTalk Applications.

    Dd788121.note(en-us,BTS.70).gifNote
    Because the Oracle Database adapter is exposed both as a WCF-Custom binding and as BizTalk adapter, you can use either the Consume Adapter Service Add-in or the Add Adapter Metadata Wizard from a BizTalk project to connect to SQL Server.

  • The Add Adapter Service Reference Visual Studio Plug-in is available in non-BizTalk programming projects. You use the Add Adapter Service Reference Plug-in to generate a WCF client class or a WCF service callback interface when you develop solutions using the WCF service model. For more information about developing solutions with the WCF service model, see Developing Applications by Using the WCF Service Model.

To use the Consume Adapter Service Add-in, the Add Adapter Metadata Wizard, or the Add Adapter Service Reference Plug-in, you must first connect to the Oracle database. All three methods present a dialog box through which you configure a connection by setting the following:

  • Connection parameters. These are the parameters that are used to build the connection URI. You must specify a data source (Oracle net service name).

  • User name password credentials for the Oracle database. These are used to authenticate you on the Oracle database when the connection is established. You must specify a user name and password.

  • Binding properties. Binding properties are optional at design-time, that is, while generating metadata for operations. For more information about binding properties, see Working with BizTalk Adapter for Oracle Database Binding Properties.

At a minimum, when you configure the connection to the Oracle database, you only have to specify binding properties and connection parameters that are needed to establish the connection and that affect the metadata returned by the Oracle Database adapter for the operations you want to target. However, you might also want to specify values for any additional binding properties and connection parameters that will be used at run time. This is because:

  • The Consume Adapter Service Add-in creates a BizTalk port binding file from the binding properties and connection parameters that you specify when you configure the connection, and adds this file to your project. Later, you can use this binding file to create a port in the BizTalk Server Administration console. For more information about the binding file, see Configuring a Physical Port Binding by Using a Port Binding File.

  • The Add Adapter Service Reference Plug-in creates an app.config file from the binding properties and connection properties that you specify when you configure the connection, and adds this file in your project directory.

Show:
© 2014 Microsoft