We performed a comparison between SAS Data Management and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"I am impressed with the tool's ability to customize."
"If you compare it to SQL, the memory and development times are very quick."
"The technical support is excellent."
"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."
"This is an established product with powerful data analysis and varied options for user entry points."
"The product offers very good flexibility."
"The solution is easy to use and developer friendly."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The product's deployment phase is easy."
"The setup is straightforward. It's very easy to install."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The performance is good."
"The solution is stable."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."
"The solution is quite expensive and hard to install/configure."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."
"The solution could use better documentation."
"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."
"I would like the tool to include the ability to automate the modifications of the integrations."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Video training would be a helpful addition."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The performance of this solution is not as good as other tools in the market."
"The high prices attached to the product can be an area of concern where improvements are required."
"This solution needs full support for real-time processing."
SAS Data Management is ranked 43rd in Data Integration with 15 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SAS Data Management is rated 8.4, while SSIS is rated 7.6. The top reviewer of SAS Data Management writes "A scalable solution with customer support that is responsive and diligent". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SAS Data Management is most compared with Informatica PowerCenter, Tungsten RPA, Microsoft Purview Data Governance, IBM InfoSphere DataStage and Collibra Governance, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our SAS Data Management vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
