What do you do when your team is tasked with integrating multiple applications from multiple vendors with your organization's own in-house applications? What does integration mean to the users of the applications, to your technical team, and to the 3rd parties vendors? This session is a review of a real-world example of the approaches considered and the path took on such a project. We'll cover the constraints of the project, discuss the pro's and con's of the approach taken, and also cover what has worked, what could be better, and how it will be improved.
This session will be a high-level discussion on the use of SSIS (SQL Server Integration Services) as a data integration tool, SQL Server as an integration database, DB2 as the in-house application database, ASP.net as a user front end, and finally the integration tools provided by various 3rd party vendors. Please join to learn from this projects teams experiences and to share your own.