Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



Database Connectivity Overview

pdfPDF
Case Studies

case studiesView

Download
(Server Version)


Ritmo/i (Server) Std. EditionStd. Edition

Ritmo/i (Server) Dev. EditionDev. Edition

Download
(Client Version)


Ritmo/i Client Std. EditionStd. Edition

Ritmo/i Client Dev. EditionDev. Edition

Download
(Mobile Version)


Ritmo/i MobileMobile Edition


Purchase

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

ADO .NET data provider for as400, ibm i and iseries

.NET Connectivity for IBM DB2 - i, iSeries and AS/400  


.NET Connectivity for IBM DB2 for i

Ritmo - Family of .NET Managed Providers
 
The Ritmo family of products consists of .NET Managed Providers that provide access to all DB2 servers from .NET Framework-based applications, and between Windows-based mobile devices and .NET Framework-based applications. When used in conjunction with HiT Software's SafeConduct product, Ritmo products provide 256-bit encryption and digital certificate authentication.

All Ritmo products support full SQL functionality for maximum application performance including stored procedures, multiple result sets, static SQL/packages, multi-threading support. Direct connectivity architectures ensure superior performance and simplified support. Ritmo database schema support is based on the ANSI SQL92 specification. Both Ritmo for DB2 and Ritmo for i fully support Entity Framework, providing native access to DB2 data.

The HiT Ritmo .NET data providers are a native fit for developers working in a .NET application development environment. The included Ritmo/DB2 Toolbox allows easy data source definition and diagnostics. Additionally, powerful trace and debugging tools help troubleshoot and optimize application performance.

New Features

  • Full integration with Visual Studio 2012, including backward compatibility to previous versions of Visual Studio
  • Support for Entity Framework (in both Ritmo/DB2 and Ritmo/i)
  • Support for .NET Framework version 4.x

Ritmo .NET  product family
Ritmo/i for IBM i Systems
Ritmo/DB2 for DB2 LUW
Ritmo .NET Mobile for Windows Mobile OS


Ritmo/i : .NET data provider

Advantages

  • Packaged for flexible deployment
  • High performance
  • Implement native DB2 protocols and do not require additional software installed
    on the DB2 host
  • Support for .NET Framework 4.0
  • Support for stored procedures, multiple result sets, Static SQL and packages
  • Secure data transmission when used with HiT Software's SafeConduct Server
  • Tools for data source configuration and fast diagnostics
  • Support for double-byte and Middle Eastern character sets
  • Developer Editions to reduce development time
  • Tight integration with Visual Studio 2012, with backward compatibility to previous versions
    of Visual Studio
  • Integration with Microsoft Reporting Services and SQL Server
  • Support for Entity Framework (both Ritmo/DB2 and Ritmo/i)
download : includes full support during trial

Ritmo/i Client
 
Ritmo/i Client is a 100% managed Windows .NET data provider for application access to IBM i, iSeries and AS/400 platforms. It offers the same core functionality as Ritmo/i Server, but is packaged for distribution with client applications.

Ritmo/i Server
 
Ritmo/i Server runs on Windows Server platforms and is used by custom or third party product applications. Ritmo/i accepts application SQL statements that more efficiently access, retrieve, and update DB2 for i (iSeries, AS/400) data. Leveraging the native IBM Optimized Database Server protocol standard, Ritmo/i does not require any additional software at the DB2 server.

For maximum application performance, Ritmo/i (.NET provider for IBM DB2 on i, i5, iSeries or AS/400) supports full SQL functionality (including stored procedures, multiple result sets, bulk inserts, and connecting pooling) as well as data compression. Multi-threading support ensures scalability for applications. Ritmo/i communicates over TCP/IP connections.

Developer Editions

Developer Editions for both the Client and the Server versions can drastically cut .NET application development time by providing developers with working C# samples that demonstrate how to make connections, then query and update DB2 tables, execute stored procedures and display results. Ritmo provides support for Entity Framework 5.0 in both Ritmo/i and Ritmo/DB2 versions.

Ritmo/i Developer Edition includes the core Ritmo/i functionality and is fully integrated with Visual Studio 2012 and earlier versions, enabling developers to quickly build forms and reports that communicate with DB2 for i (iSeries, AS/400) servers to access, retrieve, and update data. Additionally, the Developer Edition includes Visual Studio .NET integration via designers and wizards, plus a C# Toolkit with source code and integration with Microsoft SQL Server Reporting Services to generate reports or import DB2 data into SQL Server. Users can select Ritmo as a data source from within Reporting Services, to connect to IBM DB2 for i.

Key Features   Benefits
ADO.NET compliance   Latest tools accessibility
Stored procedures and multiple result sets
support
  Fast data access
 
Multi-threading support   Performance and scalability
Support for Entity Framework 5.0 and
earlier versions
  Reduces development time in accessing
DB2 data
Multiple i, i5/OS and OS/400 version support   Flexible deployment
Trace tools   Fast diagnostics
TCP/IP connectivity support   Common network transport
Double-byte and Middle Eastern
language support
  International DB2 server access
 
ODBS Native protocol support
  Server Stability
Complete set of data types supported
and documented
  Seamless translation between EBCDIC and
ANSI character sets
Ritmo/i toolbox integration with Visual
Studio .NET
  Data source and trace management
 
C# Toolkit included with Developer Editions   Reduces development time

SUPPORTED Data Types
A complete set of data type mapping between IBM i (iSeries and AS/400) servers and .NET environments is supported and documented.
In rowsets and as parameter values, Ritmo/i maps IBM DB2 for i data types to .NET-defined data types. The following DB2 data types are supported:
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/CLOB   BIGINT


System Requirements:
    HiT Ritmo/i
(installed on client operating systems)
  HiT Ritmo/i Server
(installed on server operating systems)
Installation
Requirements

  Windows 32 and 64-bit client platforms
Microsoft Data Access Components
  (MDAC) v2.5 or higher
  Windows 32 and 64-bit server platforms
12Mb Disk Space
Network card operable with network
  protocols
TCP/IP or APPC connection to the
  IBM i
Connectivity
  Support for TCP/IP network protocol
DB2 Server Requirements   OS/400 or IBM i operating system V3R7 or higher


download : includes full support during trial

 
IBM Advanced Business Partner
 
MSFT Silver ISV
 
Oracle Gold Partner
 

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