After you set the connection parameters, you can browse an Oracle Database system's tables, views, and procedures in the Adapter Wizard.

1. In the Adapter Wizard, enter a value for the Max Concurrent Calls.

   This number represents the max number of concurrent calls, for example 200. The Max Concurrent Calls parameter activates an overload protection if the back-end server cannot process the amount of data. A concurrent call means a request for which the adapter does not yet have a reply.

   Set Max Concurrent Calls in instances where the throughput exceeds back-end processing capabilities. The default value for this field is 5, which means that no protection occurs. If BizTalk Server submits a request to the Transmit adapter, and the number of concurrent calls equals or exceeds the value set for Max Concurrent Calls, the thread submitting the request is saved until the concurrent calls number decreases to below the set value.

2. Select Yes for Refresh Agent to force the runtimeagent.exe and browsingagent.exe processes to restart automatically when required.

   For example, you want the process to restart automatically if it loses connection with the server, or if you add something to the server and it does not appear in the Microsoft Adapter Wizard for selection.

   The Refresh Agent parameter updates both the browsing and the run-time agents.

   Note
   The browsingagent.exe does not update until you exit the current browsing session. For example, you must exit the Add Generated Item browsing session and reenter to update browsingagent.exe.

3. Expand the Adapter Required Properties and enter all required information for connection to the Oracle Database server.

   • Connection: Maximum number of sessions: You must set session parameters for BizTalk Adapter for Oracle Database when you access the server system. This number sets the maximum number of sessions that can be connected to the server. The default value is 40.
     
     
   • Environment: If you did not set global environment variables, you can do so here. This is the path to the Oracle Client DLLs required by the Oracle ODBC driver (for example, C:\oracle\ora92\bin).
     
     

     Note
     You can set global environment variables in Control Panel, under System.

   • Adapter Required Properties – Password: If you did not select Use SSO, you must set credential parameters for BizTalk Adapter for Oracle Database to access the server system. The password corresponds to the user name. The password determines the permissions you are granted when you access the database.
     
     
   • Adapter Required Properties - User Name: If you did not select Use SSO, you must set credential parameters for BizTalk Adapter for Oracle Database to access the server system. The user name is used for exploring the Oracle server and creating Web services.
     
     
   • Adapter Required Properties - Service Name: Identifies Oracle Database. The Service Name is linked to a router that directs you to the server that you can access. Use the same Data Source and Service Name that you entered when configuring the ODBC driver. Each service has its own user name and password.
     
     

4. Provide credentials using Single Sign-On (SSO).

   1. To use Single Sign-On, select Yes.
      
      

      Note
      For more information, see Using Single Sign-On.

   2. Select an affiliate application from the list.
      
      An affiliate application, created by Enterprise Single Sign-On tools, represents an application such as Oracle Database. The adapter uses the credentials of an application user. These credentials are retrieved from the SSO database for the server system for a specified affiliate application. The credentials are those of the user (the application user) who launched the BizTalk Server project.
      
      

      Note
      For more information, see Creating Affiliate Applications.

5. Set Use Transaction if this logical system supports transactions.

   If you set the Use Transaction property to true, messages will not be duplicated.

6. Click Apply, and then click OK.

Concepts