I have a CRM purchase order application from my end (internal) its database is SQL. The IBM mainframe application is at the end client site (external).

Currently the CRM application is talking directly to the IBM mainframe application, it is sending purchase orders LIVE. The way it is communicating is by IP address and Port number.

I need to integrate both applications with biztalk 2010. Any ideas how to accomplish this task? What kind of adapters do I use? 

Also, Does the back end client that supports the IBM mainframe application need to have biztalk environment

Is this the only integration requirement for the mainframe app? IF this is then it is OK to leave it as a Point-to-point interface. On the other hand, if you wish to expand the interface to be usable and called by other applications as well then it'd be worthwhile to understand the TCP/IP communication that is currently happening between the CRM App and the mainframe app. You might want to create a custom adapter on this or try and evaluate if the mainframe app can leverage other things such as the DB2 Adapter (available with the Host Integration Services) or leverage IBM WebSphere MQ for the purposes of inter-app communication. Once you understand the provider and its capabilities then you can decide on the best mechanism to interface with it and then you'd know how BizTalk can support the integration requirements.

Regards.

• Marked as answer by Christiane0696 Monday, March 02, 2015 7:02 PM

Is this the only integration requirement for the mainframe app? IF this is then it is OK to leave it as a Point-to-point interface. On the other hand, if you wish to expand the interface to be usable and called by other applications as well then it'd be worthwhile to understand the TCP/IP communication that is currently happening between the CRM App and the mainframe app. You might want to create a custom adapter on this or try and evaluate if the mainframe app can leverage other things such as the DB2 Adapter (available with the Host Integration Services) or leverage IBM WebSphere MQ for the purposes of inter-app communication. Once you understand the provider and its capabilities then you can decide on the best mechanism to interface with it and then you'd know how BizTalk can support the integration requirements.

Regards.

• Marked as answer by Christiane0696 Monday, March 02, 2015 7:02 PM

Hi Christiane,

When you said The IBM mainframe application is at the end client site (external), then I assume your client who use IBM mainframe is not with your organisations network boundary and I would check whether the mainframe app at your client has any Web service exposed to provide interface with their IBM mainframe service. If so then BizTalk does have WCF adapter for you to integrate with their web service to interact with IBM mainframe.

Or if the IBM mainframe is an internal system within your network, I will find what type of IBM server programs you have to connect i.e IBM mainframes cics, ims, vsam dataset, WebSphere MQ. Then using the appropriate Microsoft BizTalk Server 2010 adapters for host systems you can connect to appropriate IBM mainframe systems

Following article gives details about the adapter and its relevant IBM mainframe systems.

http://www.microsoft.com/es-es/biztalk/adapters-host-overview.aspx

Regards,

M.R.Ashwin Prabhu

M.R.Ashwin

It is VSAM mainframe so should I use Microsoft BizTalk Adapter for Host Files? Is that adapter provided with Biztalk 2010 adapter installation or do I have to download from a Microsoft website?

M.R.Ashwin

It is VSAM mainframe so should I use Microsoft BizTalk Adapter for Host Files? Is that adapter provided with Biztalk 2010 adapter installation or do I have to download from a Microsoft website?