IBM InfoSphere Information Server vs SSIS comparison

"The integration with different technologies is the most valuable feature."

"Stability-wise, I rate the solution a ten out of ten."

"This solution is extremely flexible and scalable."

"IBM InfoSphere Information Server is stable."

"SSIS is easy to use."

"It's a competent product."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"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."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"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 the solution is performance."

"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."

"There are certain shortcomings in the cloud side of the solution, where improvements are required."

"IBM InfoSphere Information Server should be more scalable. It should have the option to change the configuration to run on a single, non-multiple node, or multi-threading processing."

"Their technical support needs improvement."

"This solution would benefit from the engine being made more lightweight."

"At one point, we did have to purchase an add-on."

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"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."

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."

"The solution could improve on integrating with other types of data sources."

"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."

"Video training would be a helpful addition."

"The licensing cost of IBM InfoSphere Information Server depends on how many users there are."

"The solution comes free of cost."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"SSIS' licensing is a little high, but it gives good value for money."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."