DB-Tools.com - system comparision
5th December 2020, Saturday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
Comparison AWS Glue Microsoft SSIS
 Drawbacks AWS Glue provides a platform to build your own etl using programming language. Unlike big ETL players like Informatica it does not have any drag drop development i.e WYSIWYG not present Cant be installed in Linux. ETL tool cannot be able to run on one major section of servers i.e linux
 Advantages ETL tool with cataloging built into it 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 AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics. You can create and run an ETL job with a few clicks in the AWS Management Console 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 Not applicable. Its a managed service Only Windows
 Key Differentiator one for the first managed ETL tool --
 Database Model Metadata is store in DynamoDB (key value store) Metadata is a file store
 Concurrency -- High performant ETL tool