Database Connection to a DB2 iSeries database

Hi,

Has anyone experience in installing a database connection to a DB2 iSeries database? I have tried to create a new “Relational Database Provider” in Dashboard “Farm Administration => Global settings” and then create an new “Data Connection” in Dashboard “Applications Administration => Data Connections”. But I don’t know the correct settings. I am working in an on prem environment.

Siggi

Find more posts tagged with

FAQs, How-To's, and Best Practices

Comments

Mauricio Mendoza

Hi Siggi,

I faced something similiar some years ago. I did..

1. Install the iSeries Access ODBC Driver on the EPM server. Then, add a new connection.

2. Farm Administration / Global Settings / Relational Database Providers / Add a Relation DataBase provider / Example: DB2

3. Application Administration / Data Connections / Application / Add Connection / Connection / Provider DB2 / Connection String

DSN=<DSN name>;SYSTEM=<iseries name>;Uid=<user>;Pwd=<Password>;DATABASE=<databasename>;DBQ=<libraries>;NAM=0;

Example:

DSN=System 21;SYSTEM=system21.domain.com.;Uid=USER;Pwd=PASSWORD;DATABASE=s10eb95c;DBQ=QGPL,AULT1F3,AULT2F3;NAM=0;

Regards,

Mauricio Mendoza

siegfried-fleig

Hi Mauricio

Many thanks. And which settings have you used in the database provider. I have no example for DB2. I have tried it with:

Parameter Prefix = ";"

ODBC Driver = "IBM i Access ODBC Driver"

OLE DB Driver = "IBMDASQL"

Is this correct?

Regards

Siggi

PHX VISUAL MFG IMPLEMENTATION.pdf

siegfried-fleig

Hi Mauricio

Everything is ok. It works fine.

Regards Siggi

Copyright © 2025 Infor. All rights reserved.