We performed a comparison between Oracle Warehouse Builder [EOL] and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."OpenAPI supported me integrating Oracle Warehouse Builder with DevOps solutions like versioning (CVS, Subversion, and Git), ticket systems (Bugzilla and Jira), and test automatization (HPQC) as well as with professional ALM solutions (HP ALM and IKAN ALM)."
"It's already very user-friendly and has a good dashboard."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"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 most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The data reader is the most valuable feature."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It is easy to set up the product."
"Unfortunately, a next release of Oracle Warehouse Builder will not happen but a wide range of customers still use the available features together with the current Oracle 11g or 12c database environments."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"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."
"The solution could improve by having quicker release updates."
"We'd like them to develop data exploration more."
"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."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"It would be nice if you could run SSIS on other environments besides Windows."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
More Oracle Warehouse Builder [EOL] Pricing and Cost Advice →
Earn 20 points
Oracle Warehouse Builder [EOL] doesn't meet the minimum requirements to be ranked in Data Integration while SSIS is ranked 2nd in Data Integration with 69 reviews. Oracle Warehouse Builder [EOL] is rated 7.0, while SSIS is rated 7.6. The top reviewer of Oracle Warehouse Builder [EOL] writes "Can be enhanced with extra functionality, but no further support will be given for the solution". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Oracle Warehouse Builder [EOL] is most compared with , whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
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.