Great ETL tool
February 15, 2018
Great ETL tool
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
We currently use SSIS for imports of purchase orders into our ERP - SYSPRO. These purchase orders come in various file formats: EDI, XML and excel spreadsheets. SSIS helps us aggregate these various files into a common import platform and apply business logic such as ship date calculations, SKU availability checks, customer hold checks etc.
- Great for parsing data from various file formats into SQL server. As an example, we use it to extract data from XML, EDI and other flat files.
- Great for applying custom business logic in the ETL process. These business logic could be built into functions, stored procedures and applied through the SSIS packages.
- I like it's exception handling capabilities and how it's able to show the module that threw up the exception by highlighting it in red.
- Works very well with Visual Studio and as a matter of fact, you can build all your SSIS packages right from SQL without even opening up SQL server or BIDS.
- Not sure if it has JSON support but if it does, that would be awesome! Basically, the ability to consume data from a JSON data set.
- In as much as Microsoft built it for the SQL database, it would be awesome if we could leverage SSIS for data ETL into other databases like MySQL and Oracle etc.
- Add more color themes! The default color theme is old school and really sucks if you ask me.
- Saves us a considerable amount of time required to import our data.
- Streamlines the order import/processing process for our business and makes it easier for us to meet our target ship dates as we have no bottlenecks during the import flow.
SSIS works great with the above tools. We are a Microsoft shop so anything that fosters better integration among the various tools and platforms we use is very welcomed.