We performed a comparison between Actian Pervasive Data Integrator [EOL], Oracle Data Integrator (ODI), and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The initial setup is easy."
"It has the ability to easily load slowly changing dimensions."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The most valuable feature is Data movement."
"Oracle provides great documentation."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The setup was easy. All Microsoft products are easy to set up."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The most important features are it works well and provides self-service BI."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"SSIS' best feature is SFTP connectivity."
"The simplicity of the solution is great. The solution also offers excellent integration."
"SSIS is easy to use."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"If you have something like Cisco on top of it, you will have endless problems."
"The initial setup is a bit complex compared to other tools."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Technical Support could be better."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
"I would like to see better integration with Power BI."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
Earn 20 points