Does FME support version 7.3 of Informix? If not, can I write some python code to bring the data in through a script? What versions of it does it support from?
Cheers
Does FME support version 7.3 of Informix? If not, can I write some python code to bring the data in through a script? What versions of it does it support from?
Cheers
@paulhallett I had a quick look and couldn't see an obvious answer for the version. You could try asking Safe directly using the zopimchat widget "Ask us anything" to the bottom right of this screen.
Thanks @mark_1spatial,
Pinged them something so hopefully I'll resolve it. I was thinking about using a python script and dsn to load the features in memory direct into the FME workbench as a second resort, or maybe even stream them in; any comments on those approaches?
Cheers
Paul
I had a look and the only info I could find was that this is quite an old version of Informix, it *might* work, but we hadn't tested against that version. If you pinged us then let's wait for the support folk to go query the developer, but I expect the response won't be a lot different; basically we haven't tested and you'll be entering uncharted terratory.
If that doesn't workout, something else that might be worth taking a look at is the JDBC driver. I think it is for non spatial only, but possible ways around it are using Well Known Text (WKT).
Article here https://knowledge.safe.com/articles/701/using-the-...
Hi Paul,
From Development, we have tested FME and Informix version 11.5,
If you end up testing FME and Informix version 7.3, we would
be very interested in any feedback you have to offer: https://support.safe.com/knowledgeSubmitCase?
Kind regards,
Natalie
Product Support Specialist
Safe Software Inc.
@NatalieAtSafe - OK, we've got in to the Informix 7.3 by using the ODBC reader. It allows us in after installing the correct (32bit) IBM drivers on the server/client machine. One issue that you do have to contend with is setting the DB_LOCALE and CLIENT_LOCALE settings to align with your data. It had defaulted at first to US and I started getting an Architecture mismatch error (Database Error Message: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application) which was resolved by editing the DSN information and running it again.
Seems to be running ok, although we're testing it as we think using ODBC is a bit of a risk, albeit necessary one.