| Author |
Message
|
| madrox |
 Posted: Sat Apr 01, 2017 11:23 am Post subject: IIB Vs Informatica. What to use when? |
 |
|
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 |
|
 |
| timber |
| Posted: Sun Apr 02, 2017 12:35 pm Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| 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 |
|
|
| madrox |
| Posted: Sun Apr 02, 2017 3:24 pm Post subject: |
|
|
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 |
|
|
| gbaddeley |
| Posted: Sun Apr 02, 2017 4:20 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
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 |
|
|
| madrox |
| Posted: Sun Apr 02, 2017 4:28 pm Post subject: |
|
|
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 |
|
|
| mpong |
| Posted: Sun Apr 02, 2017 8:18 pm Post subject: |
|
|
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 |
|
|
| mqjeff |
| Posted: Mon Apr 03, 2017 4:10 am Post subject: |
|
|
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 |
|
|
| madrox |
| Posted: Mon Apr 03, 2017 8:32 am Post subject: |
|
|
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 |
|
|
| mqjeff |
| Posted: Mon Apr 03, 2017 8:38 am Post subject: |
|
|
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 |
|
|
| Vitor |
| Posted: Mon Apr 03, 2017 8:45 am Post subject: |
|
|
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 |
|
|
|
|
