DB-Tools.com - system comparision
3rd December 2021, Friday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
Comparison DatasStage Microsoft SSIS
 Drawbacks IBM Product hence comes with bells and whistles like a big infosphere platform. Not good in handling XML, WebService Cant be installed in Linux. ETL tool cannot be able to run on one major section of servers i.e linux
 Advantages ETL tool at par with Informatica on RDBMS workloads SSIS is part of a BI ecosystem with SSRS
 Website https://www.ibm.com/products/infosphere-datastage https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver15
 Brief description IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destination
 Operating System Supported Linux, Windows Only Windows
 Key Differentiator Used to be one of the Most popular ETL tools in the market --
 Database Model Propertiery data store as files. Metadata Cannot be queried using sql Metadata is a file store
 Concurrency -- High performant ETL tool