| Author |
Message
|
| dfl93 |
 Posted: Fri May 22, 2015 11:51 am Post subject: WMB (or IIB) and the use of ODBC... (...again? Sorry!) |
 |
|
Newbie
Joined: 06 Jan 2014
Posts: 8
Location: Chile
|
Recently some people questioned the use of ODBC connections in WMB arguing that it isn´t good (ODBC) for large groups of transactions and saying things like ODBC, who uses ODBC today...?
Do you have any comparation about ODBC vs JDBC?
Must I think in JDBC instead of ODBC nodes when I go to create any flow with many access to DB? For example, imagine a flow that have to do 5 selects query and 2 inserts and a load of 2tps. With Sybase like DB... and a server with enough memory and cpu... |
|
| Back to top |
|
 |
| zpat |
| Posted: Fri May 22, 2015 12:19 pm Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Short answer, no.
ODBC is fine, ignore the Java bigots. Tell them to use WAS not WMB.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error. |
|
| Back to top |
|
|
| ruimadaleno |
| Posted: Mon May 25, 2015 8:51 am Post subject: |
|
|
Master
Joined: 08 May 2014
Posts: 274
|
i'm also interested in this discussion,
here we run WMB 8.0.0.4 on windows 2008 server R2 enterprise, several execution groups, several message flows deployed, supporting several projects on Sql server + Oracle databases
Each project is supported by a set of message flows, for each project one datasource is created (as needed by project: some projects have 3 odbc datasources - connecting to 3 distinct databases)
We haven't see no performance issues on using ODBC (ok .. some problematic querys --> tune the querys) , from message flow statistics:
| Quote: |
Snapshot time 2015-05-25 17:48:07 - 2015-05-25 17:48:27
Broker BRKESB01A
ExecutionGroup name ExecuteSuccess ExecuteFailure ActiveConnections ClosedConnections ConnectionErrors
eg_utili summary 0 0 0 0 0
eg_bat summary 36758 0 12 33 0
eg_bat DSN_RRR 36758 0 12 33 0
default summary 2479496 0 10 33002 0
default DSN_XXXX 2327449 0 10 19986 0
default DSN_YYYY 151692 0 0 12670 0
default DSN_ZZZZ 3328 0 0 327 0
default DSN_TTTT 27 0 0 19 0
|
_________________
Best regards
Rui Madaleno |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue May 26, 2015 6:10 am Post subject: Re: WMB (or IIB) and the use of ODBC... (...again? Sorry!) |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| dfl93 wrote: |
imagine a flow that have to do 5 selects query and 2 inserts and a load of 2tps. With Sybase like DB... and a server with enough memory and cpu... |
Seems like you are trying to implement ETL in ESB,
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue May 26, 2015 6:12 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The use of ODBC or JDBC depends entirely and only on what transformation node in Broker you are using.
It is possible to use ODBC from within a JCN, but for many of the prebuilt database nodes, you can only use one or the other. |
|
| Back to top |
|
|
| dfl93 |
| Posted: Wed May 27, 2015 5:55 am Post subject: |
|
|
Newbie
Joined: 06 Jan 2014
Posts: 8
Location: Chile
|
Thank you all.
Gaya3, it's interesting your comment. Why you say that?
Do you think a flow like that could not be in the Broker?
Are you using the Broker only for transformation and routing but not for implementing some kind of services?
Thank you in advanced. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 27, 2015 6:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| dfl93 wrote: |
| Gaya3, it's interesting your comment. Why you say that? |
Because that's a lot to build in a single flow. My eyebrows raised as well.
| dfl93 wrote: |
| Do you think a flow like that could not be in the Broker? |
Of course it could. It could equally be an ETL process, or could be a Java process in WAS. The question which I think @Gaya3 is driving at, and certainly the one that occurred to me, is where is the best place?
| dfl93 wrote: |
| Are you using the Broker only for transformation and routing but not for implementing some kind of services? |
What kind of generic, reusable service (the sort of thing typically hosted in Broker) has that number of selects and inserts in a single flow? It sounds a lot more like a fairly specific process performing a fairly specific task, and that sounds rather more like ETL than Broker.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| dfl93 |
| Posted: Wed May 27, 2015 7:55 am Post subject: |
|
|
Newbie
Joined: 06 Jan 2014
Posts: 8
Location: Chile
|
| Vitor wrote: |
What kind of generic, reusable service (the sort of thing typically hosted in Broker) has that number of selects and inserts in a single flow? It sounds a lot more like a fairly specific process performing a fairly specific task, and that sounds rather more like ETL than Broker. |
Ok, ok... that was only an hipotetical case, this topic is about ODBC, therefore I put to many DB access... ok? However, it was good for introduce a very hot topic.
Recently I proposed the use of the Broker to read from a table in one DB, put each record in a queue where another flow would read and inserted into a different DB ...
Ohhh I burned in hell!
That's ETL !!!
Still I think that two simple flows are better than WAS+SpringBatch+Task+Steps and so on. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed May 27, 2015 8:44 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| dfl93 wrote: |
| Still I think that two simple flows are better than WAS+SpringBatch+Task+Steps and so on. |
 |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 27, 2015 8:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| dfl93 wrote: |
| Still I think that two simple flows are better than WAS+SpringBatch+Task+Steps and so on. |
|
So do I. Now let's work on agreeing a definition for "simple" ... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| inMo |
| Posted: Wed May 27, 2015 1:04 pm Post subject: |
|
|
Master
Joined: 27 Jun 2009
Posts: 216
Location: NY
|
| Based on the dialogue it sounds like you are dealing with a group that sees everything as a Java or ETL candidate. How is IIB purposed within your group? |
|
| Back to top |
|
|
| dfl93 |
| Posted: Thu May 28, 2015 5:03 am Post subject: |
|
|
Newbie
Joined: 06 Jan 2014
Posts: 8
Location: Chile
|
| inMo wrote: |
| Based on the dialogue it sounds like you are dealing with a group that sees everything as a Java or ETL candidate. How is IIB purposed within your group? |
In my case, that´s true. IIB is only used for transformations.
I feel they are locked in the old concept of routing, transformation and enrichment of message. The old concept of an ESB that, IBM among others, ¿trumpeted? so much...?
It is also true that there are many more java programmers than IIB developers. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu May 28, 2015 5:50 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| dfl93 wrote: |
| inMo wrote: |
| Based on the dialogue it sounds like you are dealing with a group that sees everything as a Java or ETL candidate. How is IIB purposed within your group? |
In my case, that´s true. IIB is only used for transformations.
I feel they are locked in the old concept of routing, transformation and enrichment of message. The old concept of an ESB that, IBM among others, ¿trumpeted? so much...?
It is also true that there are many more java programmers than IIB developers. |
In that case your java developers working with the bus better learn the different iib interfaces and classes real quick... (MbElement, MbMessage, etc...) Otherwise you're going to have such a mess on your hands...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
