Microsoft SQL Server Integration Services to Alation
Information Asset, LLC.Reviews from AWS customer
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
83 reviews
from
External reviews are not included in the AWS star rating for the product.
Useful tool for data integration and migration.
What do you like best about the product?
* Helpful in connecting to various data sources and loading the combined data
* More cost-efficient than other ETL tools of the same stature
* Reduces the need for coding scripts
* More cost-efficient than other ETL tools of the same stature
* Reduces the need for coding scripts
What do you dislike about the product?
* Not much scope for creating user-required automation
* Some tasks require manual labour like exporting numerous tables in csv format has to be done one by one.
* Some tasks require manual labour like exporting numerous tables in csv format has to be done one by one.
What problems is the product solving and how is that benefiting you?
* Integration of data from numerous sources and combining it
* No extra requirement of learning anything other than SQL itself
* Helps in analysing customers' data by collecting them at a single place
* No extra requirement of learning anything other than SQL itself
* Helps in analysing customers' data by collecting them at a single place
Overall good security to prevent hacking
What do you like best about the product?
Data is secure with end-to-end encryption; easy to use
What do you dislike about the product?
sometimes there are bugs/errors. the UI can be better
What problems is the product solving and how is that benefiting you?
Prevention of data leaks of clients' personal information.
Tool for sql server query and Data migration
What do you like best about the product?
While querying our SQL server it was the goto tool to create stored procedures, table or query any table from any database. It provides good ui and is easy to get started. With ssis we can query create logics and export the result into csv for data analysis and even this is good for on prem sql servers for data migrations.
What do you dislike about the product?
Many things need to do manually it's really hard to create any automations there. I remember in one scenario where we need to export 100's of table as csv so need to do that one by one, was unable to create any automations to do it at one shot.
What problems is the product solving and how is that benefiting you?
Firstly for this no extra learning required if you know sql and have worked on any of its tool before you're good to go. Compared to oracle developer i find this way helpful and easy to work. Features offered by ssis are really good and once you work on it if you switch to another you'll miss it.
Recommendations to others considering the product:
Before all this cloud data migration tool people used to work on ssis for data migration data analysis and SQL query. If you working on sql server you must try this out it's really provides small features which are really helpful at the same time impactful.
showing 81 - 83