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.
Prerequisite 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 version: · 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 18.104.22.168.4 after you install the client.
You install Oracle client from this site
http://www.oracle.com/technology/software/products/oracle9i/index.html 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
http://bbs.webyanhai.com/simple/index.php?t6010.html get oracle ORA92054.exe (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
Verify this that you have oracle 9.02.0054 version driver installed
If you have oracle 10g client then this step is not necessary. you already have upgraded odbc driver 22.214.171.124.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 you sqlnet.ora and tnsnames.ora handy sqlnet.ora should have this line NAMES.DEFAULT_DOMAIN = your domain name Next follow the image go to administrative tools and click odbc source check and test for connection
The test connection Successful says its done . Now for biztalk side :
Go to biztalk administrative console see the adapters right click and make a new adapter as given in jpeg .
Similary do for Oracle Ebussiness Adapter
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 Idea is that under this folder bin folder should exist.Rest write the system dsn name under service name and not tns name.
Open a biztalk project . Right click add generated Items select oracle adapter there at port you should have atleast one oracle port configured to same oracle database whose schema you are going to extract.
select the database and it signifies you are connected to oracle with biztalk as you can see the tables and procedures there