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 IndexWebSphere Message Broker SupportIIB Vs Informatica. What to use when?

Post new topicReply 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

Apprentice

Joined: 11 Mar 2015
Posts: 41

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

Yatiri

Joined: 25 Aug 2015
Posts: 614

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

Apprentice

Joined: 11 Mar 2015
Posts: 41

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

Padawan

Joined: 25 Mar 2003
Posts: 1638
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

Apprentice

Joined: 11 Mar 2015
Posts: 41

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

Centurion

Joined: 22 Jan 2010
Posts: 108

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: 17174

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.
_________________
Read, Think, Try, Repeat
Back to top
View user's profile Send private message
madrox
PostPosted: Mon Apr 03, 2017 8:32 am Post subject: Reply with quote

Apprentice

Joined: 11 Mar 2015
Posts: 41

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: 17174

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..
_________________
Read, Think, Try, Repeat
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: 24297
Location: Ohio, 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 topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB 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.