Clear Analytics vs. IBM InfoSphere Information Server vs. SolarWinds SQL Sentry

Clear Analytics has almost all the features which are mostly required by the organizations for their data analytics and transformation activities. Clear Analytics is built on the support of a parallel query engine which makes it handle large volume requests and also provides optimized results. However, every solution has some limitations, Clear Analytics lacks advanced features such as Predictive Analytics which is a very demanding feature in the market as most organizations are adopting AI/ML automation for their businesses. Also, it needs to add a lot of advanced visualizations so that the user has the choice of selection. Overall a good solution to be recommended.

Incentivized

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

This solution is perfect for a team with a large server count and, at least, moderate experience supporting a SQL Server environment. If the environment is smaller or the team has less experience working with SQL Server performance tuning methodologies, then the tool may be overwhelming for the users.

Incentivized

• Quick management of the data through Excel thanks to the tools Clear Analytics provides such as filtering different information for an easier view.
• Ability to add new KPIs to measure different areas of our business.
• Drag and drop tool which makes an easier usage of Excel.
• Cost-effective. I find Clear Analytics to be affordable considering the number of features added and the unlimited sharing and editing it provides.

Incentivized

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Incentivized

• The Top SQL functionality has been extremely useful for identifying poorly performing queries by resource consumption.
• The flexibility of creating your own Advisory Conditions has allowed us to integrate our custom internal alerts into a centralized dashboard and alerting platform.
• Being able to highlight any chart on the dashboard and then tool-matching that window across all the other charts makes it much easier to correlate the different performance metrics against each other.

Incentivized

• For Charts and Graphs , getting the Power Point Deck would be helpful. As of now we use the data from Excel Reports

Incentivized

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

• Tuning advice: With all the graphs and data available, it's not always easy to determine the best thing to do. I'd like to see SentryOne provide some best practice analysis based on the historical information collected for the server being looked at.
• They could add help tips or links to help documents, when you select a graph on the dashboard. Inexperienced users tend to put blinders on and focus on one thing when they see a high counter or something out of the ordinary. It would be very useful to include a link that provides underlying help. The link would provide an explanation of the counter in detail and offer possible explanations as to why the counter is off.

• Scale of implementation
• IBM techsupport

Incentivized

Absolutely. SQL Sentry is an absolute must have for any company with a SQL Server estate. It provides a force multiplier to effectively manage SQL Server, and the feature sets are second to none. The support and expertise at SentryOne is incredible. They are very supportive of both the platform users and helping your business with the product

Incentivized

I have really enjoyed working with Clear Analytics. This platform has contributed to increased production and reliable data control processes. It has flexible user interface that can be operated by any organization member. Reports are shared on simple and transparent way in the dashboard for easy access. Data analytics from all departments have created manageable working environment that have increased production.

Incentivized

I accept that the flexibility of the alerting comes at a price. Other than the alerting SQL Sentry's interface is intuitive. Connecting to a new SQL instance, given that all the needed ports are open in your firewalls is straight forward. Reviewing the performance and queries for an instance is available in with a right click. As you dig in new tabs are created to present the detailed data. I find the ability to filter and rollup metrics on a query very helpful in dealing with the "it's running slow". You can easily compare the metrics of run times for the same query to let the user know, it's probably data your doing a billion reads instead of the usual 100 thousand.

Incentivized

The system is working perfectly in capturing data, but we do experience issues with SQL Timeout when viewing results in the remote clients. This may be due to the fact that our monitoring service is consuming most of the CPU, and it is the same server that is hosting the SQL Repository. We could probably fix the issue by separating the SQL instance from the monitoring service.

Incentivized

In most cases the pages load very quickly. In our particular case, we need to do some movement of services to separate our monitoring service to separate infrastructure from the repository. When we first started with SQL Sentry on 5 licenses, we did not have any issues. Since we have now grown that to 25, we are experiencing some challenges. We do not believe this to be a tool problem

Incentivized

I have had multiple scenarios where I had to reach out to the support team of Clear Analytics, be it access-related, general queries, during initial implementation, etc. My overall experience has always been good. I got the needed support every time without any delay. I can definitely recommend Clear Analytics simply on the basis of its excellent support team.

Incentivized

From their infancy as a smaller company to now as a global player they have always kept focus on prioritising he customer. They know their product and the technology it supports and are easily accessible for both resolving problems with the product all the way to adding value through additional training and assisting with getting return on investment through utilisation of the many features the product provides.

Incentivized

sql sentry expert came onsight to review the performance of installation and gave us a good insight to using the tool

Incentivized

Was suggested that we install the process monitors on a dev or qa database server, but we found it more useful to create an IT db server and put it there (along with a few other apps that we use for monitoring).

Incentivized

There are other great tools that are out there but Clear Analytics is reasonable for our business and provides a lot of features that we specifically needed

Incentivized

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

SQL Sentry offers more features and is customize-able to fit our business needs. It has more centralized management and support. The company's technical support is also top notch. It is also worth mentioning that SentryOne Team Blog is an excellent source. One can find lots of valuable troubleshooting skills on the blog site - very educational and informational.

Incentivized

We are running 25 instances through a single monitoring service and it is able to keep up. We are finding that this many instances in our environment is about as many as can be handled. We will need to deploy additional monitoring services. Luckily, there is no additional licensing costs to deploy additional monitoring services. For us, it's just an additional Azure VM.

Incentivized

• Super useful to get started immediately
• Didn't have to rely on migrating data
• Easy to add members
• Easy to learn and build charts

Incentivized

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.

• Better customer service as it alerts me automatically to loss of service issues so I can react and either get things fixed before it impacts the customers or to let my management know as soon as possible
• It helps me find expensive SQL so our customers get better performance and we make better use of our resources

Incentivized