Likelihood to Recommend Intersystems IRIS is a really great tool for Interoperability. It has so many capabilities out of the box and then such a great developer community on top of that, that there are really no limits to what you can do in terms of data manipulation and translation. Personally I find it to be a great tool if you are looking for Interoperability software.
Read full review Navicat Premium is a very well-rounded tool with a reasonable licensing fee given its feature set. It is primarily suited for technical resources who must work with a variety of different database systems, but who may not be database or command line tool wizards. However, its query building and job batch scheduling feature support end-users as they build competency, and it continues to hold its value even as users outgrow their training wheels. Navicat is probably not so appropriate for DBAs and others for whom database development and management is already a career path; these folks have their preferred toolsets, both vendor-supplied and homegrown, and they might consider the additional licensing cost to outweigh the value they'd personally get out of Navicat.
Read full review Pros Connecting with mutliple vendor platforms and systems allowing us to consume and provide data as needed. Allowed us to implement our own RESTful api engine to server data to our internal applications. Setting up their recommendations for high availability allow us to perform server maintenance with minimal down time to our users. Read full review Access via standard html Alert notification Read full review Cons Enhanced documentation, more comprehensive and user-friendly documentation, including detailed tutorials and examples Improving compatibility and integrations with others programming languages Introducing tools and techniques to optimize the performance of ObjectScript applications, such as profiling tools, performance monitoring utilities, and code optimization guidelines A better compatibility with Python libraries Read full review There is room for improvement with customer support and vendor account management Onboarding option/support for new team members within the business using the tool More product/feature updates and trainings Read full review Usability The interface is very intuitive, the documentation is very good so it is not complicated to operate.
The security is complex, but you can create a special role to access and the user ONLY can operate with the part that it allows.
Also, you can examine the data very quick with the SQL Browser integrated.
Read full review Support Rating The InterSystems WRC has always been helpful and responsive. The folks I have spoken with are always understanding of our needs and questions and regardless of if the question is simple or complex we are always met with the same professionalism and helpfulness every time. I have no hesitations contacting InterSystems for help!
Read full review Very robust online community and well as excellent support staff. Easy to follow video tutorials. Detailed sample configurations are provided with guided walk-throughs via remote classroom instruction. Very fast response from support staff. No internal hires were necessary for support as vendor support staff fully met all technical expertise. 24/7 incident reporting and tracking is great.
Read full review Implementation Rating Will done based on a proper planning, so this will makes execution more easier and better.
Read full review Alternatives Considered We are using InterSystems IRIS [especially] for database operations as the query performance is really good for [a large] amount of customer data. You can easily integrate for any application like web, desktop, and many more. It also provides BI functionality which is also very easy to implement using InterSystems IRIS[.]
Read full review Navicat is superior in allowing us to save complex queries and share them with other users. It is also better at administering the database. It also allows us to easily transfer data and structure to a test database server. This saves a ton of time when working on our dev environment to get access to fresh data.
Read full review Return on Investment Very Fast and scalable software to deal with big data flow, safe and robust. The studio IDE is quite old fashion and lacks a few facilities amazing for complex data consumption, its milyi-model capability wich allows multiple different models for a single set of codes. Read full review Practically speaking, Navicat Premium has enabled our department to support database maintenance and extension, migrations, and customer data reporting and analysis requests, without requiring staffers to be database mavens, thereby extending our limited (non-profit) resources in a significant manner. In the long term, we may find our perpetual licenses will age out of usefulness, given that major version updates are (not unreasonably) unavailable for perpetual licensing. However, three years in, we've found it to continue to provide value. And going forward, should a major version upgrade be required, upgrade licensing is available at a reduced cost. As we are a non-commercial organization -- part of the California State University system -- Navicat Premium's one-time license cost is low enough to provide a great value for our department, given the large suite of features it offers; at current non-commercial pricing, one perpetual seat costs out at $599. If you are a commercial organization, the "enterprise edition" is what you'll need to purchase, and at $1,299 per perpetual license, it may be tougher to justify the expenditure. However, Navicat Premium's support for a wide variety of database systems does positively differentiate this product! Read full review ScreenShots