Click here to Skip to main content
Click here to Skip to main content

Tagged as

Go to top

BizTalk Oracle Adapter Installation

, 3 Apr 2008
Rate this:
Please Sign up or sign in to vote.
Installation of BizTalk Oracle Adapter
Screenshot - oracleadapter.jpg
Friday, August 24, 2007

Introduction

As you know, Microsoft BizTalk Server 2006 enables you to connect diverse software, then graphically create and modify process logic that uses that software. BizTalk Server also enables information workers to monitor running processes, interact with trading partners, and perform other business-oriented tasks. To install the Microsoft BizTalk Adapters for Enterprise Applications, click here at the Related Resources label, click on Download the Microsoft BizTalk Adapters for Enterprise Applications. If the link is replaced by Microsoft, then click here and search for BizTalk Adapter Pack 2.0. Most of the adapters need some tricky things to do. One of them I am explaining is Oracle adapter (the most tricky one) installing the software from the site.

The prerequisites are requirements for BizTalk Adapter for Oracle Database Microsoft BizTalk Adapter for Oracle Database uses databases registered through the ODBC Data Source Administrator.

The adapter runs on the following operating systems:

  • Windows 2000
  • Windows XP
  • Windows Server 2003

BizTalk Adapter for Oracle Database was tested against the following versions:

  • Oracle Application, Version 11.5.7

You must have an Oracle client installed to use BizTalk Adapter for Oracle Database. The Oracle client installation includes the Oracle ODBC driver, which must be updated to Oracle ODBC driver 9.2.0.5.4 after you install the client. You install Oracle client from this site, after this you need to Upgrade the Oracle Driver. After you download and open the self-extracting archive file, ORA92054.exe, check it on this page.

Get Oracle ORA92054.exe:

  1. Oracle Universal Installer 2.2.0.18.0
  2. Oracle Data Provider for .NET (9.2.0.4.01)
  3. Oracle Client (9.2.0.1.0)
  4. Oracle ODBC Driver (9.2.0.5.4)
  5. Oracle Provider for OLE DB (9.2.0.4.0)
  6. Oracle Objects for OLE (9.2.0.4.8)
  7. Oracle Services for Microsoft Transaction Server (9.2.0.4.0)

It contains all drivers but only d) Oracle ODBC Driver (9.2.0.5.4) is required. Then follow http://msdn2.microsoft.com/en-us/library/aa547982.aspx (this is most important step). Extract and open "C:\Program Files\Oracle\oui\install\setup.exe" and follow the same as given in the image:

Screenshot - oracle92054.jpg

Verify this that you have Oracle 9.02.0054 version driver installed:

Screenshot - oracle920541.jpg

If you have Oracle 10g client, then this step is not necessary. You already have upgraded odbc driver 9.2.0.5.4. Next to set the ODBC connection to the database, in Control Panel, open Administrator Tools. Click [ODBC] Data Sources. Click the System DSN tab, and then click Add. A list of data sources appears. Select Oracle in OraHome92, and then click Finish. Make sure you have valid tsnnames.ora and sqlnet.ora files and you can login into Oracle from sqlplus. You should have your sqlnet.ora and tnsnames.ora handy. sqlnet.ora should have this line NAMES.DEFAULT_DOMAIN = your domain name.

Screenshot - oracle920542.jpg

Next follow the image, go to administrative tools and click odbc source check and test for connection. The test connection Successful says it's done.

Now for the biztalk side:

Go to biztalk administrative console, see the adapters, right click and make a new adapter as given in JPEG. Similarly do for Oracle Ebusiness Adapter:

Screenshot - oracleregistration.jpg

Last step:

Screenshot - oracleebussiness.jpg

You have created sucessful receive port and generating schema from biztalk project. See the images for configuration. C:\oracle\ora92 is the path of Oracle installation. It may differ. The idea is that under this folder, the bin folder should exist. Rest write the system dns name under service name and not tns name.

Screenshot - oraclerecport.jpg

Open a biztalk project:

Screenshot - oraclesendport.jpg

Screenshot - oraclegenerateschema.jpg

Screenshot - oracledb.jpg

Select the database and it signifies you are connected to Oracle with biztalk as you can see the tables and procedures there.

Happy programming!

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

No Biography provided

Comments and Discussions

 
GeneralNice Article PinmemberChicadee6-Dec-09 16:41 
QuestionHow To Check Record Found PinmemberAunalisiraj27-Jun-08 21:43 
i am Query Oracle Using Send and Receive but i Could Not Figure it How i can Check did i get the Record Found Or Not
GeneralExcellent Article PinmemberSantosh Benjamin19-Mar-08 0:40 
GeneralRe: Excellent Article PinmemberIvan Rosales3-Apr-08 8:58 
GeneralRe: Excellent Article Pinmemberthakurjitender@gmail.com,3-Apr-08 9:51 
AnswerRe: Excellent Article Pinmemberthakurjitender@gmail.com,3-Apr-08 9:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 3 Apr 2008
Article Copyright 2007 by thakurjitender@gmail.com,
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid