Sign in to see all reviews and comparisons. It's Free!
By clicking Sign In with Social Media, you agree to let PAT RESEARCH store, use and/or disclose your Social Media profile and email address in accordance with the PAT RESEARCH Privacy Policy and agree to the Terms of Use.
Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions.
Category
ETL Software
Features
•Built-in data source connectors •Built in tasks and transformations •ODBC source and destination •Azure data source connectors and tasks •Hadoop/HDFS connectors and tasks •Basic data profiling tools
URL
https://www.microsoft.com
What is best?
•High-performance Oracle source and destination by Attunity •SAP BW source and destination •Data mining model training destination •Data mining query transformation
What are the benefits?
•Dimension processing destination •Partition processing destination •Term extraction and term lookup transformations •Fuzzy grouping and fuzzy lookup transformations
PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
9.2
7.6
Features & Functionality
9.4
8.7
Advanced Features
9.3
7.2
Integration
9.4
6.8
Performance
9.3
8.9
Customer Support
9.2
7.9
Implementation
7.5
Renew & Recommend
9.0
Bottom Line
Integration Services is used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
9.3
Editor Rating
8.0
Aggregated User Rating
13 ratings
You have rated this
Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Integration Services is used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.
Integration Services includes a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration Services service for running and managing packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.
A package holds a variety of elements that define a workflow.
Company size
Medium (50 to 1000)
User Role
Consultant
User Industry
Computer
Rating
Ease of use8.4
Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
Features & Functionality8
Parameters allow you to assign values to properties within packages at the time of package execution.
Advanced Features8.7
Integration8
Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources.
Training 8
Customer Support8
Renew & Recommend8
ADDITIONAL INFORMATION Use the graphical Integration Services tools to create solutions without writing a single line of code.
Extract, transform and consolidate data from multiple relational databases and sources.
Company size
Enterprise (>1001)
User Role
Executive
User Industry
Computer
Rating
Ease of use8
Features & Functionality8.9
Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
Advanced Features8.4
Integration8.9
Training 8.9
Customer Support8.9
Implementation8
ADDITIONAL INFORMATION Program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.
A package holds a variety of elements that define a workflow.
Medium (50 to 1000)
Consultant
Computer
Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
Parameters allow you to assign values to properties within packages at the time of package execution.
Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources.
ADDITIONAL INFORMATION
Use the graphical Integration Services tools to create solutions without writing a single line of code.
Extract, transform and consolidate data from multiple relational databases and sources.
Enterprise (>1001)
Executive
Computer
Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
ADDITIONAL INFORMATION
Program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.