We performed a comparison between Oracle Data Integrator (ODI), SAS Data Integration Server, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It is an ETL tool, which does the extract, transform, and load."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution offers very good data manipulation and loading."
"The solution is very stable."
"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 debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"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."
"The setup is straightforward. It's very easy to install."
"It is easy to set up. The deployment is also very quick."
"The product's deployment phase is easy."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The most important features are it works well and provides self-service BI."
"The solution lacks some functions and features."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"Technical Support could be better."
"It needs easier security."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The initial setup is a bit complex compared to other tools."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"The initial setup of SAS Data Integration Server was complex."
"So I would like to see improved integration with other software."
"The transform tool has limited access. They should make it more flexible."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"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."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"The solution could improve by having quicker release updates."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."