differnece b/w Datastage and SAS

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vijaynaidu
Participant
Posts: 7
Joined: Wed Aug 09, 2006 4:24 am

differnece b/w Datastage and SAS

Post by vijaynaidu »

hi all

I heard that all the work done by datastage can also be done by SAS including reporting.
Is it true. Clarify abt this topic
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Difference between Ferrari to Ford...
Almost all the work done by Datastage can be Perl scripts.
SAS and Datastage are both different product involved in building Data Warehousing.
Datastage is one of the superior ETL tool. SAS is one of the product which gives end to end solution. It has many products for each cases where you need to get the license of each.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
caltog
Premium Member
Premium Member
Posts: 39
Joined: Thu May 22, 2003 7:32 am

Post by caltog »

Hi vijaynaidu,

I used to work for SAS in the past and what I can say is that basically DataStage and SAS are not really the same, if we want to compare them.

If you need a powerfull and intuivite ETL-EAI tool, this is DataStage
and if you need a fully complete solution, from data extraction up to cube reporting including many other tools, try to use SAS.

SAS provide also solutions for ETL and DataQuality, but then it is depending from your needs and budget.

They are also other vendors on the market offering "all in one" solutions.

Please clarify your question.
vijaynaidu
Participant
Posts: 7
Joined: Wed Aug 09, 2006 4:24 am

Re: differnece b/w Datastage and SAS

Post by vijaynaidu »

thks for giving ur views.

SAS is doing complete etl job and reporting both

Kumar told SAS will give end-to-end solution
so if client shoots the question why i choose Datastage instead of SAS?

reasons for datastage
1. bcz of cost
2. bcz of scalability and more
how we can suggest ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Because of flexibility. Any vendor solution like the SAS one, or the SAP one, will tend to lock you in to that vendor's products. What happens, in three or four years, when you go through a merger or acquisition, and suddenly need to support other systems? DataStage has that flexibility.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Main differentiating factor is performance. :!:
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply