Great ETL tool
February 15, 2018

Great ETL tool

Anonymous | TrustRadius Reviewer
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.

Pros

  • 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.

Cons

  • 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.
1. Great for ETL (Extract-Transform-Load) data operations.
2. Amazing if your primary database environment is SQL server.
3. Works great with Visual Studio and Microsoft even has it now on the Azure platform.
4. Works great with various file formats - XML, EDI, spreadsheets, flat files etc.
5. Works great in scenarios where it is necessary to apply business logic through stored procedures etc.

SSIS Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
7
Simple transformations
10
Complex transformations
9
Data model creation
9
Metadata management
7
Business rules and workflow
9
Collaboration
4
Testing and debugging
Not Rated
Integration with data quality tools
9
Integration with MDM tools
8

Comments

More Reviews of SSIS