Andy Piper wrote:
> 4 Integration wrote:
>> We have a need for accessing a database from a message flow in WMB 6.
>> What is your experience in using ODBC versus WBI Adapter?
>>
>> Performance?
>> Stability?
>> Functionality?
>> ....?
>>
>
> Firstly - try asking the mqintegrator forum, this is for WebSphere MQ
> Workflow.
>
> What database?
> What context?
>
> WMB can do most things you need in ODBC with Oracle, DB2, etc. from
> either ESQL or Java. Can you tell us anything about your thoughts on why
> you want/need to use an adapter?
>
> Andy
>
Hello,
The database(s) is mainly Oracle but DB2 can also be the case.
The database is part of a COTS application and the standard interface of
the application is staging tables. Then the application have processes
that moves data from the staging tables to the core tables.
Today we are using MQ and Informatica, but we have requirements to
remove Informatica in this scenario due to cost reasons.
We will use Java in the broker, as our first option.
--
// 4 Integration