dbTalk Databases Forums  

Cognos DecisionStream info

comp.databases.olap comp.databases.olap


Discuss Cognos DecisionStream info in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jamie
 
Posts: n/a

Default Cognos DecisionStream info - 04-14-2004 , 09:23 AM






Hello,
I have been tasked with researching DecisionStream. What it can/can't
do etc...

It would be very helpful if anyone here could provide answers to the
following questions:

1) Can it access data natively on all of the "big" RDBMSs (i.e.
Oracle, SQL Server, Sybase, Informix, DB2, Teradata)?
2) Can it access ODBC data sources?
3) Is there any support for OLE DB?
4) Can it access flat files?
5) Can you load the data to any RDBMS or does it store stuff in its
own proprietary RDBMS?
6) Are there any platforms that it doesn't run on?
7) Any support for parallelism (a la Ab Initio)?
8) I've read that there is a connector for SAP R/3? Are there
connecotrs for anything else.
9) How doe it compare against other ETL tools (Informatica, DTS, Ab
Initio, Acta etc...) Any analyst reports would be useful here.
10) What are its big selling points (e.g. I've seen they are pushing
the auto SK generation feature)?
11) Anything that it can't do?


Any advice would be very much appreciated.

Thanks
Jamie Thomson
Conchango UK

Reply With Quote
  #2  
Old   
P. Mushubi
 
Posts: n/a

Default Re: Cognos DecisionStream info - 04-15-2004 , 09:34 AM






jamiekthomson (AT) blueyonder (DOT) co.uk (Jamie) wrote in message news:<6007d4b6.0404140623.762a992 (AT) posting (DOT) google.com>...

Jamie,
See replies within.

Quote:
Hello,
I have been tasked with researching DecisionStream. What it can/can't
do etc...

It would be very helpful if anyone here could provide answers to the
following questions:

1) Can it access data natively on all of the "big" RDBMSs (i.e.
Oracle, SQL Server, Sybase, Informix, DB2, Teradata)?
Yes.
2) Can it access ODBC data sources?
Yes.
3) Is there any support for OLE DB?
Yes with MS SQL server, not sure about others.
4) Can it access flat files?
Yes. Very well actually.
5) Can you load the data to any RDBMS or does it store stuff in its
own proprietary RDBMS?
Can deliver to data to all supported RDBMS, natively or via ODBC.
6) Are there any platforms that it doesn't run on?
Engine runs on Windows, SOlaris, AIX and HP-UX. Designer runs on
Windows only.
You can work on UNIX exclusively if that is your preference using
their scripting language.
Quote:
7) Any support for parallelism (a la Ab Initio)?
Yes.
8) I've read that there is a connector for SAP R/3? Are there
connecotrs for anything else.
Like what?
9) How doe it compare against other ETL tools (Informatica, DTS, Ab
Initio, Acta etc...) Any analyst reports would be useful here.
No experience with the others. Nagel?
10) What are its big selling points (e.g. I've seen they are pushing
the auto SK generation feature)?
That and support for SDC, ease of use generally
11) Anything that it can't do?

Mow your lawn :-). Seriuosly I have found little it can't do as far as
ETL is concerned.

Quote:
Any advice would be very much appreciated.

Thanks
Jamie Thomson
Conchango UK
paschal.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.