We performed a comparison between SSIS, TIBCO BusinessWorks, and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"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."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The technical support is very good."
"Stability-wise, I rate the solution a ten out of ten…On a scale from one to ten, where one is difficult, and ten is easy, I rate the initial setup a nine."
"Areas for improvement would be the cloud fitness of the product and the ease of migrating to newer versions."
"The ability to link to different technologies is valuable to us."
"Good TIBCO BusinessWorks features are the admin console and the ability to roll back to the previous version."
"The high availability, tolerance, and load balancing features are top-notch. Its scalability features are also pretty cool."
"BusinessWorks reduces development time, helping developers to focus on business logic."
"I work in operations, so I value BusinessWorks' performance the most."
"We use the solution to develop applications."
"Support is absolutely excellent, efficient, and timely."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Data transformations and rollups are easy to accomplish."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"I found the initial setup very easy."
"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."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"We have issues with SSIS connectors while extracting data from Excel sources."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Scaling with the solution is costly because if we need to scale up, we have to buy more memory. That means more money. Solutions like Camel or Pulsar come with built-in options to scale horizontally, vertically, region-wide or country-wide."
"TIBCO BusinessWorks could be improved with cloud support."
"The technical support's turnaround time is an area where TIBCO needs to consider improvements...Getting support from TIBCO on a particular issue takes a lot of turnaround time."
"There are not many plugins available to integrate the databases. We have to write it in Java and integrate it. The developers should have more knowledge. These are the three main aspects that they could improve."
"Could be more user friendly in the development area."
"The Business Studio tool can be improved, which is the tool for designing the processes. Improving the Business Studio tool will make this solution more stable. It has a steep learning curve, and it is pretty tough to learn."
"The container-based image is too large and this makes auto-scaling difficult."
"Technical support is average. It's not the best."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Improve the object renaming ability (it works, but it could be more automated)."
"Technical support isn't the best."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"No support for change data capture or delta detection - that must be custom coded ."
Earn 20 points