- This topic has 4 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
Hi…
I’m new to BizTalk, and was hoping someone might be able to answer a
couple of questions that I have around adaptors and scalability:1)I understand that BizTalk is able to connect to UNIX, mainframes,
SAP, Oracle, etc, etc. Can anyone explain how exactly the adaptors do
this? For things like oracle does BizTalk just use ODBC? To understand
how BizTalk connects to SQL Server is easy to comprehend. But I’m
struggling to understand how BizTalk would connect to a Unix system,
for example.2)Does anyone know how much data BizTalk can handle? If you were to use
BizTalk for, amoung other things, data transformations – could it
manipulate say 5 million SQL Server records in the same time as a DTS
package?Any comments are welcome…
Thanks
Jeremy -
Thank you for the reply. I appreciate some of these are basic questions, so I appreciate that you’ve taken the time to answer them.
I’m starting to get a clearer picture now of how it works. So, am I correct in understanding that to connect to Oracle you must have the Orcale software installed on the BizTalk server? Or will BizTalk connect ‘out of the box’ to Oracle without the need to install anything else apart from the Oracle adaptor?
With regard to Unix, is BizTalk able to connect to the Unix file system directly? Or does it rely on things like FTP, HTTP (as mentioned) to pick up the files/messages that it needs?
Thanks
Jeremy-
To be honest I’m trying to evaluate what exactly BizTalk can do. Its obviosuly designed to integrate different systems, and hence my thinking was we have a better business case for using it if it the more systems it can connect to.
So I was just thinking that if you can connect to UNIX files quickly and easily then all the better. FTP is all very well, but I was thinking if you can access it without using FTP then all the better. I will investigate the FILE adaptor that you mentioned, that seems to be what I’m looking for…..thanks for you help.
Jeremy
-
Biztalk comes with a lot of adapters, some protocol level, some application.
There are a number of Oracle adapters. The Microsoft Oracle Adapter uses the Oracle Client software on the Biztalk server to access an Oracle database. Just as the SQL Adapter uses the SQL Client software to access a SQL database.
Access to a Unix Server can be accomplished in a number of ways. The FTP adapter can be used for file level access, HTTP adapter can connect to an Apache web server, SOAP/WSE adapters can connect to published web services. There are a number of application adapters that can connect to applications running on a Unix Server, SAP, JDEdwards, Peoplesoft, Oracle E-Business Server…
Biztalk Server is primarily developed for message based processing, not large scale batch processing. It can handled thousands of discrete messages per second but it would not be the tool I would use to process 5 million SQL records. DTS or SSIS would be far better suited to this job
.-
Yes you need the Oracle client software on the Biztalk server that hosts the Oracle adapter.
The alternative would be for the Adapter to replicate all the Oracle database connection/transport software which it does not do. Or having a Biztalk adapter proxy on the Oracle database server and this does not happen.Not sure what you mean by connecting to the Unix File System directly. The connection options are limited by what the Unix server can support.
You can use SAMBA on the Unix server and a FILE adapter on Biztalk. NFS is another possibility but I have never tried it.
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.