SAS DI queries

[abhityagi]

Hi SAS Experts,

Could you explain me the given queries about SAS DI on the basis of given points.

#1. Commercial or Open source -- does SAS DI open source available ?
#2. History --> what is the history of SAS DI ?
#3. Pricing --> what is the basic cost of SAS DI ?
#4. Popularty --> How popular SAS DI as compare to other tool ? how it is better as copare to other tools ?
#5. Platform --> In which platform SAS DI works ?
#6. Custom Codes --> How to write customs codes in sas ?
#7. Learning --> How easy to learn sas as compare to other ETL tool such as talend ?
#8. Deployment --> How's deployment process of SAS DI. Is it easy as compare to other ETL tools.
#9. Re- usability --> Do the SAS DI transformations are reusable
#10. Scheduling --> is it possible to do the scheduling in SAS DI and how we do that
#11. Parallelism --> Does SAS DI support parallelism and how it works?
#12. Backup & Recovery --> Does backup and recovery possible in SAS DI and how ?

Thanks in advance !

Thanks,

Abhishek

[LinusH]

#1. Commercial or Open source -- does SAS DI open source available ?

Di Studio is clearly not open source. Is that what you are asking?

#2. History --> what is the history of SAS DI ?

It's been around for +10 years. What kind of story do you want?

#3. Pricing --> what is the basic cost of SAS DI ?

Check with your SAS representative.

#4. Popularty --> How popular SAS DI as compare to other tool ? how it is better as copare to other tools ?

Are you serious? Are you actually thinking that someone can give a objective answer to this? How do you even measure?

#5. Platform --> In which platform SAS DI works ?

The cleint (the least important part of the architecture) is installed on Windows client/terminal server. It uses SAS9 Intelligence Platform as server, so Windows; Linux, UNIX...and it can access and process data on literally any platform/database.

#6. Custom Codes --> How to write customs codes in sas ?

Manly using SAS (SQL, data step, SAS macro, SASprocedures)

#7. Learning --> How easy to learn sas as compare to other ETL tool such as talend ?

No clue.

#8. Deployment --> How's deployment process of SAS DI. Is it easy as compare to other ETL tools.

Of the tool or the system you are building using the tool?

#9. Re- usability --> Do the SAS DI transformations are reusable

Yes, you can build reusable transformations/jobs.

#10. Scheduling --> is it possible to do the scheduling in SAS DI and how we do that

"Yes", it's actually done in Management Console, which uses metadata from DI Studio. Direct integration with crontab, Windows Task and IBM LSF.

#11. Parallelism --> Does SAS DI support parallelism and how it works?

Yes. First and simplest - multi threading processing.

Then parallelism of steps, either by simple forking, or via SAS Grid Manager which uses LSF for cost based allocations among grid servers.

#12. Backup & Recovery --> Does backup and recovery possible in SAS DI and how ?

Backup is initiated by default of DI metadata. For disaster recovery, these backup just need an OS level bakup routine.

Clarify if you meant other type of backup/recovery.