ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Informix Connection

To download the Latest driver for Informix, please visit here

http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

There is also a driver present for Informix in ODI

Driver Name – IBM Informix JDBC Driver
JDBC Driver – com.informix.jdbc.IfxDriver
JDBC URL -jdbc:informix-sqli://165.202.560. 369:1576:informixserver=infxdw;database=ftp

URL Parameters:

<host>: server network name or IP address. < 165.202.560.369 >
<port>: server port number. < 1576 >
<server name>: name of the Informix server < infxdw >
<dbname>: Informix database name <ftp>
<property>=<value>: Connection properties. Refer to the driver’s documentation for a list of available properties.

One Comment

  1. Hi!

    Well, I am facing a problem i wish you could help me to solve:
    I’m trying to execute, inside a package 1, a scenario that uses informix technology. When the scenario executes its package it returned OK, but in the log of the external package 1 it indicates the following error:

    java.sql.SQLException: Transactions not supported
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
    at com.informix.jdbc.IfxSqliConnect.rollback(IfxSqliConnect.java:1714)
    at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
    at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
    at com.sunopsis.dwg.cmd.e.i(e.java)
    at com.sunopsis.dwg.cmd.g.E(g.java)
    at com.sunopsis.dwg.dbobj.SnpScen.a(SnpScen.java)
    at com.sunopsis.dwg.dbobj.SnpScen.localExecuteSync(SnpScen.java)
    at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java)
    at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java)
    at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java)
    at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
    at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(SnpSessTaskSqlS.java)
    at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
    at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
    at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
    at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
    at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
    at com.sunopsis.dwg.cmd.e.i(e.java)
    at com.sunopsis.dwg.cmd.g.y(g.java)
    at com.sunopsis.dwg.cmd.e.run(e.java)
    at java.lang.Thread.run(Unknown Source)

    I have already read some information that mention that the problem is that informix doesn’t support “COMMIT” but I still can’t figure out how to set this option in the scenario.

    I really apreciate you help and attention in advance.

    Thanks!

    Araceli B.

Leave a Reply

Required fields are marked *.