COZYROC vs. SAS/Access

[COZYROC] is a powerful tool and [extends] what you are able to do when it comes to ETL. It allows you to accomplish a lot of things that are very common now, but very difficult to implement with the out of the box functionality of SSIS.

Incentivized

SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.

Incentivized

• Dynamic SOQL is very advantageous with Salesforce source task.
• Connecting to SharePoint is simple and seamless.
• Script Component Plus is also a very good task that we can do a lot through, that what we can't do with Script Task.

Incentivized

• Secure connections to databases
• Managed access to databases and data
• Customized access to databases

Incentivized

• Smaller set of useful transform tasks than some competitors
• Upgrade process could be smoother (though similar to others in this space)

Incentivized

• Syntax for the connection string can be tricky
• Specification of the data source driver can be tricky

Incentivized

Easy to use and easy to implement into ETL solutions with Microsoft SQL Server Integration Services.

Incentivized

Their support is fast and responsive. Their devs work on resolving the issues quickly. We usually will have a release of a fix within a few days.

Incentivized

I have always received excelled service working with SAS technical support. Additionally, the tool is used so widely that there are many online resources and use cases that allow you to see many other uses or support routes.

Incentivized

We tested several other SSIS add-on packages as well. Only a few had DB2 support. And from those few COZYROC's support was the most responsive and helpful. They practically added the functionality we needed if it was not already there.

Incentivized

Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.

Incentivized

• It is my belie that I have thrown away $3.7k

• Bring usable data together quickly for downstream consumption e.g. modelling and reporting.

Incentivized