| Author |
Message
|
| rajmq |
 Posted: Sun Jun 28, 2009 11:58 pm Post subject: Broker Connectivity ? |
 |
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
My application requirement is, getting a large volume of messages from source system and need to populate the same data to target system. (Kind of online replication from db A to db B)
Here target system is netezaa db so I would like know,
First of all, Is it broker will support netezaa?
Instead of using broker we can go for a different tool? & any suggested tools.
What are the performance constraints between the broker and netezaa db?
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Jun 29, 2009 12:07 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Is it a one time replication of data, or an ongoing task? This would influence your choice of tools.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Jun 29, 2009 12:09 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| zpat |
| Posted: Mon Jun 29, 2009 12:26 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| If we are talking DB2, it has a feature for automatic queue based replication of changes from one database to another. |
|
| Back to top |
|
|
| rajmq |
| Posted: Mon Jun 29, 2009 12:34 am Post subject: |
|
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
Thanks to All
Vitor :
1. Ongoing task. live datat online sync up.
Gaya3 :
1. yes, db to db. target is : netezaa
2. Involved less transformation but intert/update/delete to be performed while updating a target db.
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Jun 29, 2009 2:52 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rajmq wrote: |
| Ongoing task. live datat online sync up. |
If there's no requirement for transformation, you might want to consider one of the ETL tools.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rajmq |
| Posted: Mon Jun 29, 2009 4:15 am Post subject: |
|
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
Already we kept ETL is another option.
We have message broker environment for different purpose so we are planning to get the benefits from that but I am not quite sure about connectivity between broker/netezaa database.
Is it broker configuration similar to oracle/db2? & Performance?
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Jun 29, 2009 4:40 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rajmq wrote: |
| Is it broker configuration similar to oracle/db2? & Performance? |
I'd imagine it's a similar configuration to any data source, but I've no direct experience of netezaa or how it exposes connectivity.
I think a quick proof of concept will answer both of the above questions.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
