DB2 for i
Use DB2 for i from your .NET projects, just like any other relational database.
Learn more — DB2 for i- 100% ADO.NET
- SQL, transactions
- Stored procedures
- Parameterized queries
- Cursors & LOBs
- All data types
Get started in under 5 minutes with NTi Data Provider.
Access your DB2 for i data, call your RPG programs and run your CL commands directly from .NET.
No driver, no installation and no dependencies on the IBM i side.
1using Aumerial.Data.Nti;
2
3var conn = new NTiConnection("server=IBM;user=USER;password=PWD");
4conn.Open();
5
6conn.ExecuteClCommand("ADDLIBLE SALESLIB");
7conn.CallProgram("SALESLIB", "NEWORDER");
✓Connection established, no driver or installation on the IBM i
✓CL command executed from C#
✓RPG program called like a .NET method
Evolving your IBM i can become long, costly and risky, and replacing everything would be a mistake.
NTi lets you reuse all of your IBM i resources from .NET, one of the most complete and mature ecosystems on the market. Build everything you need, web apps, mobile apps, APIs, on top of your existing application assets while keeping control and consistency of your information system.
Every new IBM i project can quickly run into the same problems: fragile integration, a pile-up of components, scarce skills and ever-longer lead times.
NTi simplifies this access layer with a single .NET component. Your .NET developers take over with no specific learning curve, and your projects start faster, on an architecture that is simple to master and to evolve.
One NuGet package, one connection string, and you’re set.
NTi gives you access to all your IBM i resources, DB2 for i, RPG programs and CL commands, using the syntax you already know: ADO.NET, EF Core, async, LINQ…
Nothing to install on the server, nothing to configure on the client. You keep your tools, your habits and your ways of working. IBM i becomes a resource like any other in your .NET project.
Getting started
Sign up on the Aumerial portal and follow the guided steps.
02Enter the serial number and LPAR partition ID of your IBM i.
03Download the generated SQL script and run it on your IBM i.
❯ dotnet add package Aumerial.Data.Nti ✓ Package installé avec succès
1using Aumerial.Data.Nti;
2
3var connection = new NTiConnection("server=Host;user=USER;password=PWD");
4connection.Open();
5
6
7
Features
Use DB2 for i from your .NET projects, just like any other relational database.
Learn more — DB2 for iTake advantage of the full power of EF Core on DB2 for i to build your .NET applications faster.
Learn more — Entity Framework CoreBeyond data, NTi lets you call your RPG programs and run your CL commands directly from .NET.
Learn more — Programs & commandsDeploy your applications wherever your architecture requires. NTi adapts to your .NET runtime, with no constraints on the IBM i side.
Learn more — Cross-platformNTi connects to IBM i through existing ports and services. Each user’s own security policy applies natively.
Use NTi in your existing projects as well as in new developments, from .NET Framework to .NET 10.
Demo
Discover our tools built in .NET with NTi, ready to use immediately with a single command.
Use cases
Evolve your IBM i applications in short iterations, with visible results from the first few weeks. IBM i remains the back end, while your new features are built in .NET.
Learn more — IBM i modernizationBuild new applications around your IBM i using .NET standards. Data, processing and programs become directly usable in your projects, with no change to the way you develop.
Learn more — .NET for IBM iOne Docker image that runs anywhere: Linux, ARM, Power, cloud... .NET applications scale independently of IBM i, which remains the system of record, with no direct exposure.
Learn more — Containers & cloudExtend your IBM i all the way to the user’s device. Mobile apps, business tablets, connected devices: your IBM i data and processing stay accessible in real time, as close to the action as possible.
Learn more — Mobile, edge computing and IoTFeedback
Setting up AUMERIAL’s NTi in our STR-iCT application was quick and easy. Our teams were won over by how simple it is to install and get started with.
Compared with its competitors, NTi offers a solution that connects quickly to IBM i, whether for database access, running CL commands or calling RPG programs.
In addition, because NTi follows the ADO.NET standard, our code has become more compact and more readable.
As a leader in IBM i security software, we needed a high-performance, secure solution such as NTi.
i.gayte.it — Mobile, edge computing and IoTStart now. Decide later.
30-day trial, no commitment and no credit card. You start the trial yourself, instantly.
Start the free trialAre you an integrator or an ISV? Contact us for a custom offer with a redistribution license.
NTi Data Provider
| NTi Data Provider | iSeries Access ODBC driver* | IBM Data DB2 iSeries** | IBM DB2 Connect | |
|---|---|---|---|---|
| No IBM i installation | Yes | Yes | Yes | No |
| 100% .NET provider | Yes | No | No | No |
| ADO.NET support | Yes | Yes | Yes | Yes |
| EF Core support | Yes | No | No | Yes |
| RPG calls / CL commands | Yes | No | No | No |
| Cloud & container ready | Yes | No | No | No |
| Active vendor support | Yes | No | No | No |
Another question? Write to us at contact@aumerial.com.
License: One license per IBM i (AS/400) partition, regardless of server power, with an annual subscription for unlimited use:
A free 30-day trial is also available to test NTi and its extensions.
Maintenance: Updates for NTi and its extensions (EF Core and NTi Toolbox) are free and delivered through the NuGet package manager, with guaranteed backward compatibility.
NTi, EF Core and Toolbox require no special technical assistance. These tools rely on universal skills (C#, SQL, HTML) and install through NuGet into your .NET projects, with no dependency on third-party software such as ACS or ODBC.
Client side (.NET):
IBM i side:
NTi is ready to use in under 10 minutes.
The license key is renewed on the IBM i only: simply run an SQL script provided by Aumerial on the relevant partition.
No action is needed on the client (.NET) side: your existing applications keep running with no recompilation or redeployment.
You can choose to buy licenses valid for 1, 3 or 5 years, which avoids an annual renewal if you pick the longest term.
Although NTi needs no specific technical assistance, Aumerial remains available to answer your questions and to help you if a problem arises.
In rare, specific cases, an issue may occur. If it does, we quickly analyze the situation to identify the cause. If necessary, we develop and release a fix or update through NuGet as soon as possible, to keep your operations running.
To help you use NTi and its extensions, complete and regularly updated documentation is available, or write to us at contact@aumerial.com.
IBM i compatibility: NTi, EF Core and NTi Toolbox work with all versions of AS/400, IBM i and iSeries that have a TCP/IP connection and an RJ45 port. While it is possible to work with older versions, we recommend V5R4 (February 2006) or later for enterprise operations.
.NET compatibility: NTi and its extensions are compatible with:
NTi is also compatible with containerized environments such as Docker or OpenShift.
NTi offers enhanced security:
Yes, NTi was designed to get the most out of your IBM i resources while making it easy to integrate with other databases.
Absolutely, NTi extends .NET capabilities to IBM i:
NTi, EF Core and NTi Toolbox are designed to complement your existing tools (ACS, iNavigator, etc.):
NTi supports all DB2 for i data types, including:
Yes, NTi lets you:
* August 2026 measurements: reading 200,000 rows (SELECT *) from a production table, NTi v5 (.NET 10) versus the IBM i Access ODBC driver with default settings, IBM i V7R4 on a local network. Performance varies with queries, data types, network and configuration, and may be comparable in other use cases. Results are not contractual.