Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Kettle Repository with Informix

  1. #1

    Default Kettle Repository with Informix

    Hi all,

    I'm trying for use a Kettle repository with Informix DB. The repository was created succesfully but when I try to save one transformation the system shows this error:

    Invalid character to numeric conversion.

    I think is a datatype problem between Informix and MySQL.

    Some solution for this problem?. Is possible use Informix with Kettle repository. The repository needs any change or specially configuration.

    Thank you in advance
    Enric Biosca
    Project Director at ICA

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Informix is dead. There are some known 'old' problems with the JDBC driver of Informix. Don't use Informix as repository database.

    Regards,
    Sven

  3. #3
    DEinspanjer Guest

    Default

    Do you mean that support for Informix in Kettle is dead? It seems like IBM is still supporting and developing the product:
    http://en.wikipedia.org/wiki/Informix#Current_Plans
    http://www-01.ibm.com/software/data/informix/

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Then I'm running behind... the last I saw is an IBM announcement they had put some pieces of DB2 in Informix, and some pieces of Informix in DB2, and that customers of Informix had an upgrade path to DB2, with the idea of phasing out informix.

    Maybe things changed in the meantime.

    Regards,
    Sven

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.