DecisionStream vs Informatica

[legSPINNER]

Should we include any others?

[Blue]

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.

[COGNOiSe administrator]

Great topic, i surfed for comparisons between the two and there aren't any

[nrh]

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.

[Ethas]

I agree, I think we should have a new poll that includes DataStage, DTS, Data Junction, Oracle Warehouse Builder, are there any others?

[Blue]

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.

[NetSpace]

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)

[COGNOiSe administrator]

XML is not one of the data sources DS recognizes. I wonder if one could pipe it through Composite Server?

[MFGF]

Something like the DataDirect ODBC driver should give DS/DM the capabilities to bring in XML data and deliver it to Oracle.

MF

[COGNOiSe administrator]

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?

[jesebell]

Hi all,

I love DS.
But, Informatica is a powerfull tool for Mainframe Extractions.

[COGNOiSe administrator]

Interesting statement. Which mainframe and DB?

PS. Nice picture!