IDS Forum

Informix Enterprise Gateway

Posted By: Cesar Martins
Date: Friday, 28 October 2016, at 12:39 p.m.

Hi,

We are doing a PoC to validate our goals using Informix Enterprise Gateway.
Executing together with IBM BP, since it's a trial release.
After a few days testing it, we identified a few defects and some lack of
resources.

Our BP is having difficults to get some answers from IBM about the
following questions,
which will be decisive for the acquisition:

1) There are some identified defects which directly affects our usage.
We do not plan to pay for a product with defects and then wait for a fix.
So, to close the deal we need the guarantees that these defects will be
solved asap...
How is IBM managing such situations?

2) The roadmap for this product appears to be "freeze" about new features
or improvements.
How is IBM managing such requests for this product?
Will we buy an old product with no future plans?

The version we're using, according to the BP, it's the most recent
available, is that correct?
IBM INFORMIX Enterprise Gateway Manager Version 7.31.UD3 (32 bits, running
over 64 bits AIX)

One defect identified :
This is the data at the remote database (not Informix)
COD_CEST DESCRICAO
--------------------------------------------------------------
0302000 Bebidas alimentares prontas a base de soja, leite
0302100 Cerveja
0302200 Cerveja sem alcool
0302300 Chope
0400100 Charutos, cigarrilhas e cigarros, de tabaco ou dos
0400200 Tabaco para fumar, mesmo contendo sucedaneos de ta
0500100 Cimento

This is the same data whitin Informix, thru EGM.
Looks like there's a very dummy defect where the \0 isn't take into account
as EOL (or just miss zeroing the variable)
cod_cest descricao
--------------------------------------------------------------
0302000 Bebidas alimentares prontas a base de soja, leite
0302100 Cerveja alimentares prontas a base de soja, leite
0302200 Cerveja sem alcool prontas a base de soja, leite
0302300 Chope a sem alcool prontas a base de soja, leite
0400100 Charutos, cigarrilhas e cigarros, de tabaco ou dos
0400200 Tabaco para fumar, mesmo contendo sucedaneos de ta
0500100 Cimento ara fumar, mesmo contendo sucedaneos de ta

The resources missing, which can help a lot:
*) implement an easier way to register the usermap, today we need to
register manually, user by user DSN w/ a very poor interface.
*) allow mapped user access using masks or groups, like, any access to DSN
remote database will be with user XYZ, it won't matter the user in the
informix side.
*) implement a PASSTHRU resource, allowing native SQLs to be executed in
the remote database.
*) allow to connect more than one remote database within the same session
using the same EGM instance.
Regards
Cesar

--001a11353e8a1af378053fef8085

Messages In This Thread

• Informix Enterprise Gateway
  Cesar Martins -- Friday, 28 October 2016, at 12:39 p.m.
  • Re: Informix Enterprise Gateway
    Art Kagel -- Friday, 28 October 2016, at 12:47 p.m.
    • Re: Informix Enterprise Gateway
      Carlton Doe -- Friday, 28 October 2016, at 1:50 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.