Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

SQL Inventory Manager allows database administrators to manage SQL Server inventory in physical, virtual, or cloud environments. It is unlike other products, it automatically detects SQL Server instances, databases and analysis services in your network, protection against back-level versions and missing security patches. It also provides quick display of server details to determine licensing cost and monitor instance health.

Description

When deployed as an on-premises server, SQL Server Analysis Services provides comprehensive support for various model types, including tabular models at all compatibility levels based on the version, multidimensional models, data mining capabilities, and Power Pivot features for SharePoint. The standard process for implementation involves setting up a SQL Server Analysis Services instance, designing either a tabular or multidimensional data model, deploying this model as a database to the server instance, processing it to populate with data, and configuring user permissions to facilitate data access. Once the setup is complete, client applications that are compatible with Analysis Services can easily utilize the data model as a source. These models typically gather data from external systems, primarily from data warehouses utilizing either SQL Server or Oracle relational database engines, though tabular models can connect to a variety of additional data sources. This versatility makes SQL Server Analysis Services a powerful tool for analytics and business intelligence.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

Screenshots View All

Integrations

SQL Server Yes 
Amazon EC2 Yes 
Amazon RDS Yes 
AnalyticsCreator No 
Azure SQL Database Yes 
Azure Virtual Machines Yes 
Collate Yes 
Microsoft Excel No 
Microsoft Power BI No 
Nucleon Database Master No 

Integrations

SQL Server Yes 
Amazon EC2 No 
Amazon RDS No 
AnalyticsCreator Yes 
Azure SQL Database No 
Azure Virtual Machines No 
Collate No 
Microsoft Excel Yes 
Microsoft Power BI Yes 
Nucleon Database Master Yes 

Pricing Details

$2,556 for 10 instances
USD 2,556 for 10 instances including first year of maintenance
Free Trial Yes 
Free Version No 

Pricing Details

No price information available.
Free Trial No 
Free Version No 

Deployment

Web-Based No 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac No 
Linux No 
Chromebook No 

Deployment

Web-Based Yes 
On-Premises Yes 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars Yes 
Live Training (Online) No 
In Person No 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Vendor Details

Company Name

IDERA, an Idera, Inc. company

Founded

2004

Country

United States of America

Website

www.idera.com/productssolutions/sqlserver/sql-elements

Vendor Details

Company Name

Microsoft

Founded

1975

Country

United States

Website

docs.microsoft.com/en-us/analysis-services/ssas-overview

Product Features

Database

Backup and Recovery No 
Creation / Development No 
Data Migration No 
Data Replication No 
Data Search No 
Data Security No 
Database Conversion No 
Mobile Access No 
Monitoring No 
NOSQL No 
Performance Analysis No 
Queries No 
Relational Interface No 
Virtualization No 

Database Monitoring

Anomaly Detection Yes 
Autodiscovery Yes 
Capacity Planning No 
Dashboard Yes 
Dependency Tracking No 
Historical Trend Analysis Yes 
Multitenancy No 
Notifications / Alerts No 
Performance Monitoring No 
Permissions / Access Controls No 
Predictive Analytics No 
Prioritization No 
Query Analysis No 
Resource Optimization Yes 
Troubleshooting No 

SQL Server

CPU Monitoring No 
Credential Management No 
Database Servers No 
Deployment Testing No 
Docker Compatible Containers No 
Event Logs No 
History Tracking No 
Patch Management Yes 
Scheduling No 
Supports Database Clones No 
User Activity Monitoring No 
Virtual Machine Monitoring No 

Product Features

Business Intelligence

Ad Hoc Reports No 
Benchmarking No 
Budgeting & Forecasting No 
Dashboard No 
Data Analysis No 
Key Performance Indicators No 
Natural Language Generation (NLG) No 
Performance Metrics No 
Predictive Analytics No 
Profitability Analysis No 
Strategic Planning No 
Trend / Problem Indicators No 
Visual Analytics No 

Alternatives

SQL Enterprise Job Manager Reviews

SQL Enterprise Job Manager

IDERA, an Idera, Inc. company

Alternatives

Kyvos Semantic Layer Reviews

Kyvos Semantic Layer

Kyvos Insights
SQL Doctor Reviews

SQL Doctor

IDERA, an Idera, Inc. company
SQL Diagnostic Manager for SQL Server Reviews

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
UnlimitedAnalytics Reviews

UnlimitedAnalytics

5Stones Software
SQL Secure Reviews

SQL Secure

IDERA, an Idera, Inc. company