Encrypting IBM i ODBC Connections from Linux

ODBC with Db2 for IBM iSeveral clients have asked how to encrypt ODBC connections between Linux and IBM i to keep their Db2 data safe in transit.

To encrypt ODBC data, IBM recommends the industry-standard TLS encryption protocol (the successor to SSL).

Read more

What’s in Your ODBC Driver?

ODBC with Db2 for IBM iSince IBM announced Yum support for installing the IBM i Db2 ODBC driver, as documented in our recent tutorial, users can update their driver more easily.

To help users determine what’s changed, IBM maintains a list of fixes and enhancements for each IBM i ODBC driver release.

Read more

Using Yum to Install or Update the IBM i ODBC Driver

ODBC with Db2 for IBM iThe IBM i ODBC driver for Db2 has become easier to install.

Formerly available only as a download requiring several steps, the driver can now be installed and updated on IBM i with Yum or Access Client Solutions (ACS), as easily as with other IBM i open source packages.

Here are instructions for installing the ODBC driver using Yum.

Read more

ODBC Connection Strings for IBM i Db2

ODBC with Db2 for IBM iAs ODBC gains popularity for IBM i database access, developers of web applications and APIs need information on defining ODBC database connections. This article demonstrates tips and techniques for effectively using ODBC connection strings in all programming environments, including popular languages such as PHP, Python, and Node.js.

For an example of how connection strings are used in a program, see How to Query IBM i Data with PHP and PDO_ODBC.

Read more

How to Query IBM i Data with PHP and PDO_ODBC

ODBC & Db2 for iOf the PHP extensions that can connect to IBM i Db2, we recommend PDO_ODBC whenever possible.

Although the classic extensions (ibm_db2, PDO_IBM) and older ODBC continue to work, we prefer PDO_ODBC for several reasons:
Read more

Tutorial: Integrate Node.js with RPG without a Connector

Node.js IBM iWe’ve been hearing from clients wondering whether they need commercial connectors to integrate open source technology with Db2, RPG, and COBOL data.

Liam Allan has shown the power of using open source tools that are available to everyone. He recommends accessing IBM i business logic and data using open source tools, without proprietary connectors.

Read more

Q&A: IBM i ODBC Driver

Stephanie Rabbini

I recently caught up with Seiden Group CTO Stephanie Rabbani about the ODBC driver that’s quickly becoming standard for open source and web connections on Db2 for i.

Read more

How-To Video: The Zen of Using PHP without Zend Server

Just one year away from end-of-life for no-charge Zend Server “Basic”—and six months after the release of license-free Community PHPmany IBM i shops face an important decision:

“Do we upgrade to a paid Zend Server license,
or do we migrate to RPM-based PHP?”

At a recent MAGiC User Group webinar, Alan Seiden and Richard Schoen teamed up to present a tutorial and demo on how to get started with Community “RPM” PHP, sharing several tips picked up during client migrations.

Read more

Free PHP on IBM i: from Basic edition to RPMs

open phpLast week, Perforce announced plans to withdraw Zend Server for IBM i “Basic” by June 2021. Filling the gap is license-free “community” PHP for IBM i, installable in RPM format.

Seiden Group has been assisting IBM i clients to adopt Community PHP since its introduction last year. We’ve helped with both first-time PHP installations and migrations from Basic.

Read more

Update on Free, Open PHP for IBM i

php ibm i trainingSince last month’s post about free and open PHP on IBM i, we have been helping companies to get started with it.

We’ve seen excellent results with the open PHP package, known as an RPM. Starting with the PHP repository provided by IBM and Zend (Perforce) as a base, we are able to optimize PHP for the needs of each IBM i shop.

Especially appealing to us and our clients: this PHP is 64-bit and leans toward open standards, including ODBC. In exchange for a bit of setup time, you’ll have a system that’s lightweight, flexible, and license-free.

Read more