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.
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 in Ritmo version 5!
- Full integration with Visual Studio 2010, including backward compatibility to previous versions of Visual Studio
- Support for Entity Framework (Ritmo v.5 for IBM DB2 LUW and mainframe only)
- Support for .NET Framework version 4.0
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 2010, with backward compatibility to previous versions
of Visual Studio
- Integration with Microsoft Reporting Services and SQL Server
- Support for Entity Framework (Ritmo/DB2 v.5 only)
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 v.5 (DB2 LUW/zOS version) provides
support for Entity Framework.
Ritmo/i Developer Edition includes the core Ritmo/i functionality and is fully integrated with
Visual Studio 2005, 2008 and 2010, 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 |
|
| 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) |
|
| 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
|
|
| |
PDF
View
Std. Edition
