Informatica Grid
Moderators: chulett, rschirm, roy
Informatica Grid
I have been hearing about Informatica Grid recently as an alterantive to Ab Initio and EE. Anyone here have any working experience with it. I have used all 3 tools but have never used the Grid version of Informatica.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No experience with Informatica Grid, but there are quite a few sites happily running DataStage Enterprise Edition on a grid. The main thing you need is a dynamic configuration file - which IBM sells a service to create for you.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I don't know much about it but the challenge for Informatica is that Ab Initio and DataStage EE were built from the ground up as shared nothing parallel processing engines. It's hard to take a product that is single threaded and build that into it - which is why Ascential stopped trying with Server Edition and bought Orchestrate and turned it into DataStage parallel jobs. With the Information Server IBM have put almost everything in the suite onto the parallel engine including data quality and profiling. A lot of ETL tools now claim to have parallel processing but I wonder which of them do it well.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Hi,
Grid computing is a low cost solution that provides for high throughput processing. Most grid installations consist of 4 or more low cost Intel servers running RedHat or SuSe Linux. Resource Management software determines which servers to use to run your jobs.
So, it doesn't matter is Informatic Grid or DataStage EE Grid, as a developer you don't need to worry about the configurations of grid. You design and code your jobs as the same way as you do in non-grid environment.
Grid computing is a low cost solution that provides for high throughput processing. Most grid installations consist of 4 or more low cost Intel servers running RedHat or SuSe Linux. Resource Management software determines which servers to use to run your jobs.
So, it doesn't matter is Informatic Grid or DataStage EE Grid, as a developer you don't need to worry about the configurations of grid. You design and code your jobs as the same way as you do in non-grid environment.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
It is always a good thing to be aware of grid environment as a developer. Dynamic cofiguration file concept and additional APT parameters are some of the 'musts'.
lstsaur wrote: So, it doesn't matter is Informatic Grid or DataStage EE Grid, as a developer you don't need to worry about the configurations of grid. You design and code your jobs as the same way as you do in non-grid environment.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Ab Initio had the first massively parallel ETL tool, Orchestrate was one of the next to do it and were acquired by Ascential, Informatica grid came later.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn