HiT Software, Inc., A BackOffice Associate, LLC CompanyBackOffice Associates
Buy Download Contact Us


Chinese Website 
Japanese Website 


About Us
corporate overview Overview
customers Current Customers
customers Case Studies
customers Testimonials
customers White Papers
careers Careers
GSA Contract
Contact Us
White Papers : Data Integration ToolsDatabase Integration Tools

Integration Between Microsoft SQL Server 2008 and IBM i
Products, tools and solutions from Microsoft and HiT Software
for complete, transparent integration between corporate
relational databases on multiple platforms

Introduction
As the use of sophisticated development tools in the 1990s became widespread, Microsoft Windows® gained ground as the client or client-server environment of choice for accessing data stored in DB2® databases running on IBM® i (iSeries and AS/400) systems. Numerous applications, both custom and packaged, have been developed to use the de-facto standards for data access introduced by Microsoft®: ODBC, OLE DB and more recently .NET data providers.

Figure 1

In more recent years, many enterprises that use DB2 on IBM i as their corporate databases have introduced Microsoft SQL Server as an intermediate or satellite database: the corporate data store remains DB2, but data is moved to SQL Server as needed for business applications. The advantages of this approach are data security, where data is protected behind the SQL Server interface, and low Total Cost of Ownership that comes with the purchase and maintenance of a SQL Server installation over another IBM system. Additionally, Microsoft SQL Server 2008 is easy to install and manage via a powerful graphical user interface.

Register: Download entire white paper

Back: White Papers
 

 

 

 

© 2012 HiT Software, Inc., A BackOffice Associates, LLC Company. All Rights Reserved.