My experience with BIDS
July 07, 2019

My experience with BIDS

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

Overall Satisfaction with SQL Server Business Intelligence Manager

We used BI Manager to develop and maintain all of our ETL packages.
  • Easy to use GUI
  • Integrates nicely with SQL Server
  • Simple single server deployment
  • Lacks versioning control.
  • Lacks support/native driver for alternative database.
  • Only plays well with other Microsoft products.
  • Allows us to quickly set up ETL processes as soon as we installed SQL Server.
  • There's a lot of free/paid resources available online, decreasing development time.
  • A tool with plenty of experienced developers.
SQL servers are much easier to set up than the others but they lack the customization and integration with other popular DB.
BIDS works well if you're committed to using all MS products. It does take some serious consideration if you know you will end up working outside of that, such as working with AWS products.

SQL Server BI Manager Feature Ratings

Performance dashboard
10
Intelligent alerting
8
Top SQL
4
Historical trend data
4
Virtualization support
6