Table of Contents
Overview ... 2
Configuring Informix on UNIX ... 2
Steps to Install and Configure Informix on UNIX ... 2
Testing the Informix Connection on UNIX ... 3
Configuring Informix on Windows ... 5
Steps to Install and Configure Informix on Windows ... 5
Testing the Informix Connection on UNIX ... 6
Creating an ODBC Connection to Informix ... 7
Configuring ODBC Connectivity on Windows... 7
Configuring ODBC Connectivity on UNIX... 8
Testing the ODBC Connection on UNIX ... 9
Configuring a Connection Object in the Workflow Manager... 10
Overview
You can connect to an Informix database through PowerCenter to create Informix source or target definition. You can also run sessions the extract data from and load data to Informix.
The Designer uses ODBC to connect to Informix to import definitions. The Integration Service uses either native connectivity or ODBC to communicate with Informix. Use native connectivity for increased performance.
You need to install and configure Informix client software on the machines where the Integration Service process runs and the machines where you install the PowerCenter Client.
The following rules and guidelines apply to Informix:
y The Informix client is not available on Linux. Use ODBC to connect to Informix from Linux.
y Effective in PowerCenter 8.0, PowerCenter no longer supports Informix as a repository. If you want to upgrade an Informix repository, you must back up the repository and then restore the repository in an IBM DB2, Sybase, Oracle, or Microsoft SQL Server database using your current version of PowerCenter. After you restore the repository, upgrade the repository in PowerCenter.
Configuring Informix on UNIX
Before you can connect to Informix on UNIX, you need to configure the Informix database. After you configure Informix, you can test the connection to the Informix database.
Steps to Install and Configure Informix on UNIX
To install and configure Informix on UNIX:
1. Install the Informix client software. 2. Set the following environment variables:
Environment Variable Value
INFORMIXDIR Location of the Informix client installation. For example:
INFORMIXDIR = /u01/informix/inf290
INFORMIXSERVER Name of the Informix server. SHLIB_PATH | LIBPATH |
LD_LIBRARY_PATH
Set to: $INFORMIXDIR/lib/<Informix client library>
For example:
SHLIB_PATH:$INFORMIXDIR/lib/esql
TERMCAP Set to: $INFORMIXDIR/etc/termcap
TERMINFO Set to: /usr/lib/terminfo
TERM Set to: vt100
3. Edit the sqlhosts file in the $INFORMIXDIR/etc directory. 4. Add the following entry to the sqlhosts file:
<Informix Server Name> <Protocol> <Hostname> <Port> For example:
informix94 onsoctcp tsinformix 6633
Note: This is required or else you will not be able to connect to Informix. If you cannot connect in a session, check the log for the Domain for specific environmental errors.
5. Execute the following command to check for the client version of Informix:
esql -V
This command returns the following:
IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.TC1
Software Serial Number RDS#N000000
6. Execute the following command:
check_version csdk
This command returns the following message:
Currently installed version: 2.90.HC4
Testing the Informix Connection on UNIX
Use the Informix dbaccess utility to test the connection to the Informix database. The utility is console based. You can navigate the utility the scroll keys on the keyboard.
To test the Informix database connection on UNIX:
1. At the command prompt, enter “dbaccess.” 2. Select the Connection tab and press Enter.
The utility prompts you to connect, disconnect or exit. 3. Select Connection.
4. Select the database you want to connect to. The following example connects to informix94:
5. Enter the user name and password.
In the following example, the username is ‘guest’. When you enter the password, you do not see the password on the screen:
After you have provided the connection credentials for the server, you can connect to the databases for that user. The utility lists all of the databases in the informix94 server for user "guest".
Configuring Informix on Windows
Before you can connect to Informix on Windows, you need to configure the Informix database. After you configure Informix, you can test the connection to the Informix database.
You use the setnet32 utility to configure the Informix client. Setnet32 lets you interactively change environment variables and configure servers with different parameters. You can save the information in a registry or to a file. ESQL/C refers to the information that is saved in the registry.
Steps to Install and Configure Informix on Windows
To install and configure Informix on Windows:
1. Install the Informix client software.
2. From the Windows Start menu, select Programs > Informix Client > Setnet32. 3. On the Environment tab, set any environment variables you need.
For example, you can set the following environment variables:
- BIG_FET_BUF_SIZE. Allows you to override the default size of the fetch buffer.
- CONTIME. Specifies the number of seconds an SQL CONNECT statement continues to try establishing a connection before it generates an error. Default is 15 seconds.
5. On the Host Information tab, set the run-time values of the database host-related variables. 6. Click OK.
Testing the Informix Connection on UNIX
Use the Informix setnet32 utility to test the connection to the Informix database on Windows.
To test the Informix database connection on Windows:
1. From the Windows Start menu, select Programs > Informix Client > Setnet32. 2. Select DBPing.
4. On the Native Connect tab, enter the user and login information. Click Native Ping.
Creating an ODBC Connection to Informix
Configure an ODBC data source name to import database object definitions in the repository and create database objects using the PowerCenter Client.
Configuring ODBC Connectivity on Windows
Use the DataDirect Informix ODBC driver installed with PowerCenter to connect to Informix.
To configure the Data Direct Informix ODBC driver:
1. In the ODBC Data Source Administrator, create a new System DSN. 2. Select the DataDirect 5.2 Informix Wire Protocol driver.
3. On the General tab, enter the following information: - Data Source Name
- Description (Optional) - Database Name
4. On the Connection tab, enter the following information: - Database List (Optional)
- Default User Name - Host Name - Service Name - Server Name - Protocol Type
5. Click Test Connect.
If the connection is successful, the following dialog box appears:
Configuring ODBC Connectivity on UNIX
Use the DataDirect Informix ODBC driver installed with PowerCenter to connect to Informix.
To configure the Data Direct Informix ODBC driver:
1. Set the following environment variables: Environment
Variable Value
ODBCHOME Location of the ODBC driver installation. For example:
ODBCHOME = ODBCHOME
/home/dmeister/IS_181457371_feluda_8.5.1_32/8.5.1/ODBC5.2
ODBCINI Location of the ODBC configuration file. For example:
ODBCINI = ODBCINI $ODBCHOME/odbc.ini
SHLIB_PATH | LIBPATH |
LD_LIBRARY_PATH
Set to: $INFORMIXDIR/lib/<library path variable>
For example:
SHLIB_PATH:$INFORMIXDIR/lib/SHLIB_PATH
PATH Add: $ODBCHOME/bin:$PATH
TERMCAP Set to: $INFORMIXDIR/etc/termcap
TERMINFO Set to: /usr/lib/terminfo
TERM Set to: vt100
2. Modify the ODBC.ini file to use the DataDirect drivers and provide the correct connection credentials:
[INFORMIX_TEST]
Driver=/home/dmeister/IS_181457371_feluda_8.5.1_32/8.5.1/ODBC5.2/lib/DWifcl22.soD escription=DataDirect 5.2 Informix Wire Protocol
AlternateServers=
ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=<database> HostName=<hostname> LoadBalancing=0 LogonID=guest Password=guest PortNumber=6633 ReportCodePageConversionErrors=0 ServerName=informix10 TrimBlankFromIndexName=1
Testing the ODBC Connection on UNIX
After you have made these changes, you can test the ODBC connection.
To test the ODBC connection:
1. Download a copy of ssgodbc from http://my.informatica.com.
When you download ssgodbc, you need to select the correct media for your operating system.
2. Run env | sort | more to source the environment variables and verify that they have been set correctly.
3. At the command line on the UNIX server, connect to the Informix database with ssgodbc. ssgodbc -d dsn -u username -p password [-t user] [-v] [-g]
The following table lists the command parameters: Command Parameter Description
d Required. Data source name
u Required. ODBC user name
p Required. ODBC user password
t Required. Time SQLTablesW for the user.
v Optional. Verbose output.
g Optional. Get array size only.
For example:
feluda% ./ssgodbc.solaris32 -d <Connection Name> -u guest -p guest -v Connected
ODBC version = -03.52.0000- DBMS name = -20101-
DBMS version = -09.50.FC8 .0000- Driver name = -DWifcl22.so-
Driver version = -05.20.0032 (b0029, u0018)- Driver ODBC version = -03.52-
Enter SQL string: select * from test; a
10 0
Configuring a Connection Object in the Workflow Manager
Configure a connection object in the Workflow Manager for the Integration Service to connect to Informix to extract source data or load target data. The following example shows an Informix connection object in the Workflow Manager:
Author
David MeisterTechnical Support Engineer
David Meister is a four-year veteran of Informatica Global Customer Support. His current interests are Unstructured Data, Data Transformation, and B2B Data Exchange.
