Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



Database Connectivity Overview

pdfPDF
Case Studies

case studiesView
Download

HiT ODBC/400 Std. EditionODBC for i


Purchase

USA and Canada
sales@hitsw.com
+1-408-345-4001
 
Asia
Australia
Europe
Latin America

as/400 iseries odbc driver for sql server : db2 connectivity

ODBC driver for IBM i, iSeries and AS/400  


ODBC Database Connectivity for IBM DB2 for i


The HiT ODBC family of Windows SQL middleware for access to IBM DB2 databases support full SQL functionality for maximum application performance including stored procedures, multiple result sets, static SQL/packages, multi-threading support. ODBC level 3.x conformance offers developers catalog functionality, access to environmental attributes, extended data types, SQL batch support, error reporting, and ANSI SQL-92 alignment.   HiT OLEDB Family
  ODBC for i
  ODBC for DB2 LUW
 
 

For both third-party commercial applications and custom applications, the HiT ODBC family of products provides high-performance, secure, reliable access to DB2 data. Enterprises looking for an ODBC solution to access DB2 data should consider HiT ODBC products for the following reasons:

  • Effective use of native IBM protocols for performance and reliability
  • Non-invasive approach with no software to install on DB2 servers
  • Secure data transmission when used with HiT SafeConduct for data encryption and digital certificate authentication
  • Tools for diagnosing problems and monitoring server activity
  • Developer editions with source code examples

Overview of HiT ODBC for IBM i, iSeries, AS/400

The HiT ODBC family of products for IBM i (called HiT ODBC/400 and HiT ODBC Server/400) can be used with all major application development tools that support the Windows ODBC standard. Additionally, hundreds of third-party software products can use HiT ODBC/400 products for business intelligence, decision support, query/reporting, data replication, and data mining. Support is included for single- and double-byte as well as Middle Eastern character sets. As ninth generation middleware, HiT ODBC/400 products are extremely reliable and have evolved a robust feature set.

HiT ODBC/400 products are used by custom or third party product applications to access data residing on IBM DB2 for IBM i, iSeries, or AS/400 systems. HiT ODBC/400 products support the Windows Open Database Connectivity (ODBC) standard to access, retrieve, and update DB2 data. All communication with the IBM i platform can also be optionally encrypted and authenticated via SSL with HiT SSL Server.

Leveraging the IBM Optimized Database Server (ODBS) protocol standard, HiT ODBC/400 products use native IBM OS server programs and do not require any additional software to run on the IBM i platform.

HiT ODBC/400 products support the following database standards: ODBC core and level 3 conformance, ANSI SQL-92, X/Open and ISO CLI catalog function column name standards, ADO and ADO.NET. For networks, HiT ODBC Server/400 supports TCP/IP and APPC connectivity transports to IBM i servers.

Family of Products   When to Select
HiT ODBC/400 (Client version)   Application is running on Windows desktop system*
HiT ODBC/400 (Client version)
Developer Edition
  Application is running on Windows desktop system, and you need Developer Tools
HiT ODBC Server/400   Application is running on Windows server system**
HiT ODBC Server/400
Developer Edition
  Application is running on Windows server system, and you need
Developer Tools

*  HiT ODBC/400 (Client version) runs on Windows 7, Windows XP, Windows Vista,
    Windows 98/95, Windows NT Workstations.

** HiT ODBC Server/400 runs on Windows Server 2008/2003/2000 and Windows
    NT servers.

Key Features   Benefits
ODBC level 3.x conformance
ADO level 2.x compliance
.NET framework compliance
  Latest tools accessibility
 

Stored procedures and multiple result sets
support
 
Static SQL/package support
  Fast data access
 
 
 
Distributed Transaction Support
 
  Complex transactions support over multiple
databases
Multi-threading support   Performance and scalability
dbXpress   Performance
SSL v3.x encryption and authentication
support
  Secure data transmission
 
Multiple OS version support   Flexible deployment
Debug/trace tools   Fast diagnostics
Silent install support
  Fewer IT support issues during deployment
TCP/IP connectivity support   Common network transport
Double-byte and Middle Eastern
language support
  International DB2 server access
 
IBM ODBS Native protocol support
  Server Stability
Distributed program call support CL
Command Execution
  Business logic and utility access
 
Complete set of data types supported and
documented
  Seamless translation between EBCDIC and
ANSI character sets
C# toolkit included with Developer Editions
HiT Server Manager included with Server
Developer Edition
  Development time reduced
 
 

 

HiT ODBC for i: 
            Client and Server Edition
 

Improve performance with ODBC Level 3.x
 
HiT ODBC/400 products support full SQL functionality (via ODBC level 3.x conformance) for maximum performance of client applications. Functionalities include stored procedures, multiple result sets, static SQL/packages, multi-threading and dbExpress. ODBC level 3.x conformance offers developers powerful data access techniques, catalog functionality, access to environmental attributes, extended data types, SQL batch support, error reporting, and ANSI SQL-92 alignment.

HiT ODBC/products are particularly useful for developers working with custom applications. Silent installation support allows the middleware to be installed by calling custom setup applications. HiT Toolbox, included with both the Standard and Developer Editions, is a sophisticated ODBC diagnostic tool for network administrators who need to resolve network issues. HiT ODBC/400 products contain tracing and debugging tools that help developers with examination and modification of SQL passed to the IBM DB2 for i server.

HiT ODBC/400 products include extensive on-line documentation covering ODBC data source configurations, ODBC functions, SQL grammar, using stored procedures, static SQL/package use, tracing, debugging, and diagnostics.

Security
 
HiT ODBC/400 products can be used with HiT SSL Server, an all-Java, standards-based encryption and authentication server to secure SQL data flows over TCP/IP networks. It prevents unauthorized access to data by transparently enabling the Secure Socket Layer (SSL) protocol between HiT ODBC for IBM i and the system where HiT SSL Server is installed.

HiT ODBC/400 products also support IBM DB2 for IBM i password expiration security. A read-only version driver is included for query-only client applications.
 

download : includes full support during trial

Developer Edition
 
In addition to the features supported by HiT ODBC/400 and HiT ODBC Server/400 Standard Edition, the Developer Edition includes a special C# toolkit, with a sample project and forms demonstrating working source code.

Using ADO.NET, C# toolkit samples show you how to query and update IBM DB2 for i tables, control related i OS subsystems, and retrieve DB2 data for redirection to web applications. The source code demonstrates connections using ADO.NET recordsets, executing stored procedures, retrieving table data, inserting table data, and displaying results. All samples work with any OS/400 or IBM i operating systems V3R7 or higher.

Server Version
 
HiT Software provides both a client version and a server version of the HiT ODBC/400 product family, distinguished by whether the middleware is installed on a client system or a server system.

Configurations

HiT ODBC Server/400 can be used in two configurations:

  • Server ODBC Applications
     
    A Windows NT server application or service locally uses the ODBC service to access IBM i data and redirect it where necessary. For example, using the Microsoft IIS web server and Active Server Pages, downstream web browser clients can access IBM i data.
     
  • For Client ODBC Applications
     
    A thin client presents the ODBC API to a Windows client application and transports the ODBC commands to the ODBC service. Only server-defined data sources are available to client ODBC applications. For example, a custom Visual Basic application uses the thin client ODBC API to access IBM i data via the ODBC service.

In the Client version (HiT ODBC/400), HiT Software provides all the above features (based on Standard or Developer Editions).

In the Server version (HiT ODBC Server/400), HiT Software provides some additional management features (based on Standard or Developer Editions):

The HiT Server Manager allows a remote developer or administrator to see ODBC connections by IBM i server, calling application and user ID, start time of connections, status of connection, traffic volume over connection, and memory utilization. IBM i server connections can be pooled and reused to optimize performance. The HiT Server Manager can define the time-out and dropping of these pooled connections. Developer and administrators can now monitor the IBM i middleware access layer to ensure maximum Windows server application performance.
 
Supported Data Types
DATE   FIXED GRAPH
TIME   VARGRAPH
TIMESTAMP   LONG VARGRAPH
CHAR   VARCHAR
LONG VARCHAR   CHAR FOR BIT DATA
VARCHAR FOR BIT DATA   LONG VARCHAR FOR BIT DATA
DECIMAL   NUMBERIC
INTEGER   SMALLINT
REAL   FLOAT
BLOB   GRAPHIC
CLOB   BIGINT
TINYINT   BIT
DOUBLE PRECISION   BINARY
VAR BINARY   LONG VAR BINARY

System Requirements:
    HiT ODBC/400
(installed on client operating systems)
  HiT ODBC Server/400
(installed on server operating systems)
Platforms   Runs on Windows 7, Windows XP,
Windows Vista, Windows 98/95,
Windows NT Workstations
  Runs on Windows Server 2008/2003/
2000 and Windows NT servers
 
Installation
Requirements

  Windows 7 (32/64-bit), Vista
  (32/64-bit),XP, Windows 98/95,
  Windows NT Workstation
Microsoft Data Access Components
  (MDAC) v2.5 or higher
  Windows Server 2008 (32/64-bit),
  Windows Server 2003 (32/64 bit),
  Windows Server 2000 or Windows NT
  Server 4.0
12Mb Disk Space
Network card operable with network
  protocols
TCP/IP or APPC connection to the
  IBM i
Connectivity
  Support for TCP/IP and APPC network protocols
DB2 Server Requirements   OS/400 or IBM i operating system V3R7 or higher


download : includes full support during trial

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