HiT Software Open up your Data
Buy Download Contact Us

Chinese Website 
Japanese Website 


Products and Services
Products Overview
DBMoto Replication
DB2 Connectivity
Allora Database
XML Mapping
SafeConduct
Data Security
XML Utilities
Downloads
White Papers
Case Studies
and Testimonials
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
 

 

 

 


All Rights Reserved © 2008 HiT Software, Inc.
All other trademarks or registered trademarks herein are the property of their respective owners.