SSIS

Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

Complex data transformations are data normalization, advanced data parsing, etc.

Ability to create and maintain data models using a graphical tool to define relationships between data

Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

Ability to define and manage business rules and workflows

Collaboration is enabled by a shared repository of project information and metadata

Tool to debug and tune for optimal performance

Integration with tools for cleansing, parsing and normalizing data according to business rules

Integration with master data management tools to ensure data consistency across the organization