Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: legSPINNER on 12 Jul 2005 09:17:48 PM

Poll
Question: As an overall ETL tool, which package rates best?
Option 1: DecisionStream/Data Manager votes: 10
Option 2: Informatica votes: 7
Option 3: DataStage votes: 0
Option 4: DTS/Integration Services votes: 1
Option 5: Data Junction votes: 0
Title: DecisionStream vs Informatica
Post by: legSPINNER on 12 Jul 2005 09:17:48 PM
Should we include any others?
Title: Re: DecisionStream vs Informatica
Post by: Blue on 13 Jul 2005 07:23:04 PM
Perhaps.  But Informatica appears to be the "flavour of the month" right now and as this is a forum about Cognos products I feel a comparison of just these tools is warranted.  I would like to hear from people who have used both tools professionally.
Title: Re: DecisionStream vs Informatica
Post by: COGNOiSe administrator on 13 Jul 2005 09:13:32 PM
Great topic, i surfed for comparisons between the two and there aren't any
Title: Re: DecisionStream vs Informatica
Post by: nrh on 25 Jul 2005 10:27:14 AM
Quote from: legSPINNER on 12 Jul 2005 09:17:48 PM
Should we include any others?

Ascential DataStage recently re-branded as IBM WebSphere DataStage should be included. However, I've only had experience of DataStage so cannot offer any comparison with the other tools mentioned.

nrh.
Title: Re: DecisionStream vs Informatica
Post by: Ethas on 25 Jul 2005 07:17:00 PM
I agree, I think we should have a new poll that includes DataStage, DTS, Data Junction, Oracle Warehouse Builder, are there any others?
Title: Re: DecisionStream vs Informatica
Post by: Blue on 01 Sep 2005 04:56:21 PM
In 2000 I did some investigation for GE on ETL and EAI tools available in the marketplace.  There were over 400!

I think that we should just sick to comparing 2 tools at a time based on forum member's interests.
Title: Re: DecisionStream vs Informatica
Post by: NetSpace on 23 May 2006 12:08:51 PM

If data sources are Xml, flat files and relation DBs then it better to use Informatica to load data into relation DB(not DM). Correct?
After data is loaded and processed, it is better to use DecisionStream:
--to build data marts and
--to extract data and load data into data marts
--to build cubes
Correct?
Can DS load xml files into relational DB(Oracle)?(No)
Title: Re: DecisionStream vs Informatica
Post by: COGNOiSe administrator on 28 Mar 2007 10:21:46 AM
XML is not one of the data sources DS recognizes. I wonder if one could pipe it through Composite Server?
Title: Re: DecisionStream vs Informatica
Post by: MFGF on 03 Apr 2007 07:33:25 AM
Something like the DataDirect ODBC driver should give DS/DM the capabilities to bring in XML data and deliver it to Oracle.

MF
Title: Re: DecisionStream vs Informatica
Post by: COGNOiSe administrator on 03 Apr 2007 08:38:33 AM
Well, I take it back. I think DS could actually "load" XML to ORACLE. Can't we execute external processes in DS and using ORACLE utils to do the job?
Title: Re: DecisionStream vs Informatica
Post by: jesebell on 24 Sep 2007 12:56:58 PM
Hi all,

I love DS.
But, Informatica is a powerfull tool for Mainframe Extractions.
Title: Re: DecisionStream vs Informatica
Post by: COGNOiSe administrator on 26 Sep 2007 04:23:12 PM
Interesting statement. Which mainframe and DB?

PS. Nice picture!
Text only | Text with Images