Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website


About Us
corporate overview Overview
Case Studies
Testimonials
White Papers
Careers
HiT Software
User Group (HSUG)
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
 
IBM Advanced Business Partner W3C Member

 

 

 

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