 |
|
Database Connectivity for IBM i
|
Server Standard Edition
Full Support
during Trial Period
|
Ritmo/i (Server)
Ritmo/i (Server) Developer Edition
Ritmo/i Client
Ritmo/i Client Developer Edition
100% .NET DATA PROVIDER FOR WINDOWS
Ritmo/i is a Windows .NET 100% managed data provider for IBM i (iSeries, AS/400) SQL access. Ritmo/i Developer Edition is fully integrated with Visual Studio 2005 and 2008, 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, Ritmo/i integrates with Microsoft SQL Server to generate reports or import DB2 data into SQL Server. Leveraging the native IBM Optimized Database Server protocol, Ritmo/i communicates with native IBM i, i5/OS and OS/400 programs and does not require any additional DB2 server software.
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.
A complete set of data type mapping between IBM i
(iSeries and AS/400) servers and .NET environments is supported and documented.
The included Ritmo/i Toolbox allows easy data source definition and diagnostics. Additionally,
powerful trace and debugging tools help troubleshoot and optimize application
performance.
Ritmo/i licensing is available for both Windows
Client and Server platforms. A Developer Edition fully integrates with Visual
Studio designer, and allows import of DB2 data. In
addition to a C# Toolkit with source code, the Developer Edition also offers
integration with Microsoft SQL Server Reporting Services. From within Reporting
Services, users can select Ritmo as a data source to connect to IBM DB2 for i, and generate reports.
Server Standard Edition
Full Support
during Trial Period |
Server Developer Edition
Full Support
during Trial Period |
Client Standard Edition
Full Support
during Trial Period |
Client Developer Edition
Full Support
during Trial Period |
| 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 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/i5 toolbox integration with Visual
Studio .NET
|
|
|
Data source and trace management
|
|
| C# Toolkit |
|
|
Reduces development time |
|
Full integration with Visual Studio .NET 2005
|
|
|
Increased productivity in developing .NET
applications |
|
| Data Types |
|
| 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:
For Server Version
· Windows Server 2008, Windows Server 2003, Windows Server 2000 or
Windows NT Server 4.0 (32/64 bit)
· TCP/IP connection to i, iSeries or AS/400 Server
· OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1)
. Microsoft .NET Framework
For Client Version
· Windows Vista/XP/2000 (32/64 bit)
· TCP/IP connection to i, iSeries or AS/400 Server
· OS/400 V3R1 through IBM i 6.1 (i5/OS V6R1)
. Microsoft .NET Framework
Server Standard Edition
Full Support
during Trial Period |
Server Developer Edition
Full Support
during Trial Period |
Client Standard Edition
Full Support
during Trial Period |
Client Developer Edition
Full Support
during Trial Period |
| |
Server Version
View
Std. Edition
