Configuring a Database Connection
You must set several ODBC variables before you can configure Microsoft BizTalk Adapter for Oracle Database. This section provides a basic overview of the database configuration process. You can also refer to the individual instructions for more database-specific information.
Two of the selections in the Driver Manager are System DSN and Connection Pooling.
System DSN: System DSN is used if you are running processes under separate users and are not necessarily the user who is installing and configuring BizTalk Server. The System DSN name is configured as ServiceName in the send port configuration.
System DSN is the recommended way of defining the ODBC source.
Connection Pooling: Connection pooling is not required from the Driver Manager because the Oracle database pools connections to the database. The maximum number of connections that the adapter uses is configurable per port using the Transport Properties window.
It is recommended that you use Test Connection wherever it is provided by the ODBC driver to verify the ODBC source connectivity to the database. If the ODBC source is not correctly set up, BizTalk Adapter for Oracle Database cannot retrieve the metadata for the database.
After verifying you have the database client installed on your BizTalk Adapter for Oracle Database computer, you can set the ODBC connection to a database.
|The ODBC drivers provided by the database vendors are those which BizTalk Adapter for Oracle Database has been tested against. The adapter has not been tested against third-party ODBC drivers.|
Follow these steps to set the ODBC connection to a database.To set the ODBC connection to the database
In Control Panel, open Administrative Tools.
Click Data Sources (ODBC).
Click the System DSN tab, and then click Add.
A list of data sources appears.
Select Oracle in OraHome92, and then click Finish.
Follow these steps to complete the identification of your data source.To identify the data source
Open the Oracle ODBC Driver Configuration panel.
Enter the connection parameters, and then click OK.
Click Test Connection to verify that you can connect to the database.
Click OK to exit.
You are now ready to use the Oracle database, through the BizTalk Adapter for Oracle Database in your orchestrations using the Adapter Wizard.
When you create an ODBC source, you must tell the driver which database to use. The list of table owners is retrieved from the database and is used to populate the top level of the browser. In Oracle, this is known as the list of schemas.