What is SSIS?
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Categories & Use Cases
Top Performing Features
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.8
Data model creation
Ability to create and maintain data models using a graphical tool to define relationships between data
Category average: 8.4
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.1
Areas for Improvement
Integration with MDM tools
Integration with master data management tools to ensure data consistency across the organization
Category average: 7.8
Connecto to Big Data and NoSQL
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Category average: 7.8
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7