We performed a comparison between SSIS and TIBCO Cloud Integration based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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."
"The setup was easy. All Microsoft products are easy to set up."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The product's initial setup phase was easy."
"I am really impressed by TIBCO's integration of any level of complexity."
"I like that it is a very good integration tool with many other things. TIBCO is very good for cloud integration"
"It would be nice if you could run SSIS on other environments besides Windows."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would like to see better technical documentation because many times information is missing."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"It hangs a lot of the time."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"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."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"The deployment was rather complicated."
"TIBCO Cloud Integration is not a user-friendly tool when it comes to the installation phase or for maintaining the systems since its architecture is really complex."
"Integrations could be better. Although integration is good, we have faced some block issues."
SSIS is ranked 2nd in Data Integration with 69 reviews while TIBCO Cloud Integration is ranked 17th in Integration Platform as a Service (iPaaS) with 3 reviews. SSIS is rated 7.6, while TIBCO Cloud Integration is rated 8.4. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of TIBCO Cloud Integration writes "A product that is easy to install and offers good stability to users". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas TIBCO Cloud Integration is most compared with Azure Data Factory, Microsoft Azure Logic Apps, SAP Process Orchestration and Oracle Integration Cloud Service.
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.