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 Abinitio 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 Data Cataloging built into it. Basically Data catolog with crawl different types of input files automatically SSIS is part of a BI ecosystem with SSRS
 Website https://aws.amazon.com/glue/ 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