Excellent tool to gather information for SQL Reporting
June 24, 2022

Excellent tool to gather information for SQL Reporting

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

When working with data from several vendors, we often utilize SQL Server Integration Services to bring everything together. For reporting purposes, SQL Server Integration Services is the data-gathering engine. The information is then stored in our primary SQL database. Every department in our company uses it. Using SQL Reporting Services, it centralized data on which systems are included in which vendor products (and whether or not agents have been deployed, for example). It's been a while since the last time anything was checked.
  • Server Integration Services for SQL Server With the right planning of dataflows, we may aggregate information from many different sources.
  • The solution's package structure allows us to isolate individual functions while reusing the same set of settings everywhere else.
  • The capacity to test solutions in a variety of settings with varying inputs is a potent resource that facilitates the development of solutions that can be reused.
  • Parameter distribution into a user-selected environment has the potential to greatly enhance the current deployment procedure. It's inefficient and easy to make mistakes when you have to do everything by hand.
  • This is useful when a larger package is being used as a container for a set of dependent packages, and the larger package is being used to run and report on the smaller packages.
  • Data transformation is laborious when dealing with flat files.
  • We appreciate how much time it has saved our IT department by generating reports on their systems' compliance.
  • Maintaining consistent data across all of an organization's products helps streamline operations and cut down on wasted time and money.
  • By consolidating our data automatically, we can improve our input planning and cut down on wasteful overbuying and stockpiling.
One of the most popular alternatives to Microsoft's SQL Server Integration Services is Microsoft Power BI, although getting up and running with it is more difficult and costly than with SQL Server Integration Services. If more complex data transformation and loading (DTS) is needed later on, upgrading to the paid Standard Edition of SQL Server Integration Services is a straightforward process. Additionally, the MS community and MSDN technical resources provide a wealth of information to help get you up and running quickly. Further, in contrast to the costly SAP prerequisites, the installation/administration steps are straightforward and extensively documented.

Do you think SQL Server Integration Services delivers good value for the price?

Yes

Are you happy with SQL Server Integration Services's feature set?

Yes

Did SQL Server Integration Services live up to sales and marketing promises?

Yes

Did implementation of SQL Server Integration Services go as expected?

Yes

Would you buy SQL Server Integration Services again?

Yes

There are always alternative options available to meet the demand for integration. In my opinion, SQL Server Integration Services has a wide variety of capabilities that makes it a very versatile tool for developing dependable integration strategies. When determining which tools to utilize, vendor interfaces may play a significant role, and technologies like PowerShell have been used by colleagues to aid in this decision. For even more user-friendliness, our SSIS solution additionally makes use of a third-party plugin.

SSIS Feature Ratings

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