Integrate Any Data Source with IBM DB2 through ODBC Wrapper

basesprocketΔιαχείριση Δεδομένων

31 Οκτ 2013 (πριν από 4 χρόνια και 9 μέρες)

103 εμφανίσεις

O
P E N
A
C C E S S
U
S E
C
A S E


Integrate Any Data Source with IBM DB2 through
ODBC Wrapper
Introduction
Many organizations are using the power of products like IBM DB2 to implement a
federated data management solution where data can reside in various sources but be
exposed as a virtual database for querying by client applications.
A DB2 federated system is a special type of distributed database management system
(DBMS). A federated system consists of a DB2 instance that operates as a federated
server, a database that acts as the federated database, one or more data sources, and
clients (users and applications) that access the database and data sources. With a
federated system, you can send distributed requests to multiple data sources within a
single SQL statement. For example, you can join data that is located in a DB2
Universal Database table, an Oracle table, and your custom application data in a single
SQL statement.
IBM DB2 allows access to data sources through the various pre-built wrappers and by
allowing the implementation of custom wrappers. The use of the pre-built ODBC
wrapper allows the DB2 to pass portions of a SQL query down to an ODBC/SQL
enabled data source for processing.
The use of DataDirect® OpenAccess™ to implement a custom ODBC driver with full
SQL capability is a viable solution for implementing efficient federated database
management systems based on IBM DB2.
How to Quickly Implement a DB2 Federated System
OpenAccess SDK provides the framework and pre-built components to quickly allow
the implementation of a virtual SQL layer with ODBC support over any data source
using C, C++, Java, or .NET development environment (Figure 1).
IBM ODBC Wrapper
1) IBM DB2 receives requests
for data and if required uses
the ODBC wrapper to
complete the request.
3) The Interface Provider code
is coded in .NET, Java, or C/C++
and interacts with the
OpenAccess layer to execute
the query. A request to fill rows
of a virtual table are performed
by executing row-level requests
to the data source.
OpenAccess
(ODBC, SQL, Client/Server)
Adapter Code (IP)
Your Data Source
IBM DB2
2) OpenAccess implements a
virtual SQL layer with ODBC
API over any data source. It
accepts requests from DB2
and processes them using the
Interface Provider.

Figure 1: OpenAccess Based Solution


I
N T E G R A T E
A
N Y
D
A T A
S
O U R C E W I T H
I B M

D B 2
T H R O U G H
O D B C

W
R A P P E R


For example, to integrate a Java object-based application with DB2, all that is required
is the implementation of glue code in Java (< 500 lines of code) to tie in the application
to the OpenAccess SQL engine to support schema and data access requests. The
Java application can be on the same system as the DB2 or on any other system
supported by OpenAccess. OpenAccess includes client/server support to allow the
ODBC driver and the server to reside on separate systems.
OpenAccess is supported on IBM AIX, Sun Solaris, Microsoft Windows, Linux, HP HP-
UX, HP OpenVMS, HP Tru64, SCO Unix, IBM OS/390, and others.
ODBC enabling a data source has value even if you are not implementing a federated
data store but want to be able to put business logic into the DB2 as stored procedures
and have those stored procedures invoke requests to your data source.
Your Development Effort
1. Design and code the adapter code in either C, C++, Java, or .NET (14 days)
2. Do your QA (4 days)
3. Package up for distribution (2 days)
Expected time of completion: 20 man days
Conclusion
The ability to expose any data source as a virtual SQL database with an ODBC API
allows IBM DB2 to access it for processing distributed queries. Use of OpenAccess
allows you to implement an enterprise quality custom ODBC driver by leveraging the
OpenAccess platform, which includes 99% of what you need and allows you to code in
the language of your choice to tie in the specific data source.
2
O F
3
D A T A D I R E C T T E C H N O L O G I E S
A
P R I L
2 0 0 8



I
N T E G R A T E
A
N Y
D
A T A
S
O U R C E W I T H
I B M

D B 2
T H R O U G H
O D B C

W
R A P P E R

3
O F
3
D A T A D I R E C T T E C H N O L O G I E S
A
P R I L
2 0 0 8



FOR MORE INFORMATION

800-876-3101


Worldwide Sales
Belgium (French)..............0800 12 045
Belgium (Dutch)................0800 12 046
France.............................0800 911 454
Germany, Austria & Switzerland .......
0800 181 78 76
Japan..............................0120.20.9613
Netherlands..................0800 022 0524
United Kingdom..........0800 169 19 07
United States..................800 876 3101

DataDirect Technologies is the software industry's only
comprehensive provider of software for connecting the world’s
most critical business applications to data and services, running
on any platform, using proven and emerging standards.
Developers worldwide depend on DataDirect® products to
connect their applications to an unparalleled range of data
sources using standards-based interfaces such as ODBC,
JDBC™ and ADO.NET, XQuery and SOAP. More than 300
leading independent software vendors and thousands of
enterprises rely on DataDirect Technologies to simplify and
streamline data connectivity for distributed systems and to
reduce the complexity of mainframe integration. DataDirect
Technologies is an operating company of Progress Software
Corporation (Nasdaq: PRGS).
www.datadirect.com

© 2008 Progress Software Corporation. All rights reserved.
DataDirect, DataDirect Connect, and SequeLink are
registered trademarks of Progress Software Corporation.
Other company or product names mentioned herein may be
trademarks or registered trademarks of their respective
companies.