ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB Vs Informatica. What to use when?

Post new topic  Reply to topic
 IIB Vs Informatica. What to use when? « View previous topic :: View next topic » 
Author Message
madrox
PostPosted: Sat Apr 01, 2017 11:23 am    Post subject: IIB Vs Informatica. What to use when? Reply with quote

Acolyte

Joined: 11 Mar 2015
Posts: 71

My question is on a architectural stand point when do we use informatica and when do we use IIB. I know IIB could do what Informatica can do. But whats the right path to take
Back to top
View user's profile Send private message
timber
PostPosted: Sun Apr 02, 2017 12:35 pm    Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1280

Informatica is a company, not a product. Which product are you asking about? Please supply more information about the decision that you are trying to make.
Back to top
View user's profile Send private message
madrox
PostPosted: Sun Apr 02, 2017 3:24 pm    Post subject: Reply with quote

Acolyte

Joined: 11 Mar 2015
Posts: 71

Sorry about that, when i mentioned informatica i meant powercenter. It could be datastage or a similar ETL tool. So bascially when can i use one vs the other
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Sun Apr 02, 2017 4:20 pm    Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2492
Location: Melbourne, Australia

IBM IIB is a real-time data transformation and routing product, not ETL.
DataStage (another IBM product) is ETL.
What integration architecture problem are you trying to solve?
_________________
Glenn
Back to top
View user's profile Send private message
madrox
PostPosted: Sun Apr 02, 2017 4:28 pm    Post subject: Reply with quote

Acolyte

Joined: 11 Mar 2015
Posts: 71

I am just trying to understand what to use when. I know IIB can read from a DB, transform the data and write. What i'm trying to understand is if you are given both these products when would i use one or the other
Back to top
View user's profile Send private message
mpong
PostPosted: Sun Apr 02, 2017 8:18 pm    Post subject: Reply with quote

Disciple

Joined: 22 Jan 2010
Posts: 164

If you think your requirement can be achieved thru ETL tool, then you should go with ETL.

IIB got so much to offer and not meant to be an ETL
Back to top
View user's profile Send private message
mqjeff
PostPosted: Mon Apr 03, 2017 4:10 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Where are you moving the data?

From a DB into another DB or file? use ETL...

From a DB or large file into a set of messages on one or more transports (HTTP, MQ, TCPIP, SOAP, MQTT, etc. etc. etc.) ? Use IIB. But make sure you deal with the large file or a DB one record at a time in your IIB flow.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
madrox
PostPosted: Mon Apr 03, 2017 8:32 am    Post subject: Reply with quote

Acolyte

Joined: 11 Mar 2015
Posts: 71

Thank you! But please feel free to chime in your experiences and whats the right way to go
Back to top
View user's profile Send private message
mqjeff
PostPosted: Mon Apr 03, 2017 8:38 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

madrox wrote:
Thank you! But please feel free to chime in your experiences and whats the right way to go


The right way to go is the one that meets your technical and business requirements.

I'm not sure what you mean by "experiences" ? Are you asking for specific information about solutions that were built, and issues that were run into?

That's rather a lot of information to give here.

You've received a fair amount of advice on how to choose one type of engine (ETL/Powercetner) over another (Broker/IIB).

The remaining work is understanding your business and technical requirements, and matching those against the capabilites of the products you have available to use.

Again, if you are going to use IIB to process large amounts of data, you should do it one record at a time, rather than as one giant block of data..
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon Apr 03, 2017 8:45 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

FWIW we distinguish by the amount of transformation and/or routing involved. If it's a straight "lift and shift" to or from a database with a single end point then the pattern says to use ETL. If the requirement is more complex, with transformation / reformatting of the data and some decision as to target, then the pattern says to use IIB.

But as others have said, what you choose to do is very much dependent on your individual circumstances.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB Vs Informatica. What to use when?
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.