Get data from Informix

[Former Member]

Hi All

I need to read data from a Informix database using XI, has anybody done this, is this possible?

Thanks

Clinton

[Former Member · Accepted solution]

Yes It is possible.

I never have done it, but it is similar like accessing Oracle database, you will need to deploy Informix JDBC driver first, I read similar thread before:

• Download the jar files from informix,

• Get Package from your existing XI application server: aii_af_jmsproviderlib.sda

• Unzip the the package

• Modify Provide.xml: add jar tags that include your downloaded jar files

• Copy infomix JDBC Jar file(s) to existing structure

• Zip it to new package aii_af_jmsproviderlib.sda

• Ask your BASIS guy to deploy the new package using SDM

• Restart your J2EE Engine

After the above step, you can create JDBC adapters, searching SAP doc, you will know how to fill out the connection parameters.

Hope give you some clues.

Liang

[Former Member · Accepted solution]

Hi

Thanks for your response.

How/where do I get the following:

-Download the jar files from informix,

-Get Package from your existing XI application server: aii_af_jmsproviderlib.sda

Thanks

Clinton

[Former Member · Accepted solution]

Download the jar files from informix

check: http://www.minq.se/products/dbvis/doc/drivers.jsp#Informix_JDBC_Driver;jsessionid=917E4FCE9637D15FF2...

-Get Package from your existing XI application server: aii_af_jmsproviderlib.sda 

check: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards.

Liang