We performed a comparison between Actian Pervasive Data Integrator [EOL], HiT Software DBMoto, 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 most valuable features are that is easy to install and it is user-friendly."
"DBMoto was very simple to set up and move our tables to the Oracle DB."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"SSIS integrates well with SQL servers and Microsoft products."
"The data reader is the most valuable feature."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"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 most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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)."
"This product would be improved with additional built-in functions for simpler date conversion, as well as for data type transformations."
"Pricing is an area that needs improvement."
"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."
"The creation of the measure in the DAC's model could be improved."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The high prices attached to the product can be an area of concern where improvements are required."
"Tuning using this solution requires extensive expertise to improve performance."
"It needs more integration tools, so you can connect to different sources."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
Earn 20 points
Earn 20 points