InterSystems IRIS is a complete cloud-first data platform that includes a multi-model transactional data management engine, an application development platform, and interoperability engine, and an open analytics platform. It is is the next generation of InterSystems' data management software. It includes…
N/A
Microsoft SQL Server
Score 8.6 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
InterSystems IRIS
Microsoft SQL Server
Editions & Modules
No answers on this topic
Subscription
$1,418.00
Per License
Enterprise
$13,748.00
Per License
Offerings
Pricing Offerings
InterSystems IRIS
Microsoft SQL Server
Free Trial
Yes
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
InterSystems IRIS
Microsoft SQL Server
Considered Both Products
InterSystems IRIS
Verified User
Contributor
Chose InterSystems IRIS
InterSystems IRIS is more efficient than other applications therefore, it is preferred over the others. Moreover, it is more cost-effective than other applications like Microsoft SQL Server, therefore, many organizations such as small businesses can afford it. Lastly, …
InterSystems IRIS includes a wide array and assortment of otherwise stand-alone solutions. Having a single platform to support database interoperability, storage, and analytics, let alone Security and SQL tools is a great advantage over solutions that tackle a single aspect of …
The process of migration and scaling due to heavy lifting is also easier, the speed of performance of IRIS is good and fast were able to get a high increase in query performance after our switch and [immense] amount of features integrated with the solution, from the web …
InterSystems IRIS has the flexibility and power to be more than just a databse engine. We are able to create our business processes and interface with out javascript front end. SQL Server has been useful through the Entity framework connecting both together has been the …
I have always studied other databases, I cannot say if it is a problem for Brazilian colleges, however, after meeting IRIS / Caché, my concept of databases has changed. A much more robust and faster bank.
Now that I have had the opportunity to work with this database, there is …
The only comparison I can make is that they are all database tools. I strongly believe that just the fact that IRIS is not so widespread and easy to find in research forums is the reason why it is not so "famous". The tool meets and meets all needs for any situation.
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.
Microsoft SQL Server is ideal for highly available SQL workloads by using SQL Server Always On availability groups. Microsoft SQL Server might not be appropriate for solutions which require a very low resource footprint, since it requires significant CPU cores and RAM memory as well as high IOPS, always depending on the usage scenario.
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
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
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!
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
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[.]
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.