[ InterSy... Reviews ](https://www.g2.com/products/intersystems-iris/reviews) [ InterSy... Reviews ](https://www.g2.com/products/intersystems-iris/reviews) # InterSystems IRIS Features ##### ## Database Features (7) Storage Availability Stability Scalability Security Data Manipulation Query Language Show More ##### ## Data Management (11) Data Integration Consolidate data from various disparate sources in a single unified view Data Discovery Understand the state of data, applications, systems and services Multi - Platform Manage data across environments (on-premises cloud, hybrid, and multi-cloud) Metadata Provides metadata management and lineage capabilities Data Model Stores data as key-value pairs where key is a unique identifier. Data Types Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc. Data Model Stores and queries data as JSON-like documents. Data Types Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc. Built - In Search Allows users to index at ingest and query endlessly across data. Event Triggers Notifies specific events like document inserts, updates, replaces, deletes etc and responds in real-time. Semantic Search Show More ##### ## Analytics (1) Data Analytics Supports advanced analytics solutions for better business decision making Show More ##### ## Security (17) Compliance Rules and regulations inherited from source systems or defined to secure sensitive data Governance Grant or restrict data access and control Data Protection Built - In Backup and Disaster Recovery Data Encryption Encrypts and transforms data at the database from a readable state into a ciphertext of unreadable characters. User Access Control Allows restricted user acess to modify depending on the access level. Mobile Access Access software remotely via mobile devices Database Locking Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. Access Control Allows permissions to be granted or revoked in the database, schema or table levels. Encryption Built-in native encryption with enterprise key management. Authentication Provides multi-factor authentication with certificates. Role-Based Authorization Provides predefined system roles, privileges, and user-defined roles to users. Authentication Allows integration with external security mechanisms like Kerberos, LDAP authentication etc. Encryption Provides encryption capability for all the data at rest using encryption keys. Role-Based Authorization Provides predefined system roles, privileges, and user-defined roles to users. Authentication Allows integration with external security mechanisms like Kerberos, LDAP authentication etc. Audit Logs Provides an audit log to track access and operations performed on databases for regulatory compliance. Encryption Provides encryption capability for all the data at rest using encryption keys. Show More ##### ## Maintenance (5) Data Migration Allows data movement from one database to another. Backup and Recovery Provides data backup and recovery functionality to protect and restore a database. Multi-User Environment Allows users to access and work on data concurrently, supporting several views of the data. Automatic Backup Data is backed up automatically to prevent data loss Database Conversion Transformation of data from one format to another Show More ##### ## Management (8) Data dictionary Stores the database metadata, that is the definitions of data elements, types, relationships etc. Data Replication Creates a copy of the database to maintain consistency and integrity. Query Language Allows users to create, update and retrieve data in a database. Data Modeling Defines the logical design of the data before building the schemas. Performance Analysis Monitors and analyzes critical database attributes like query performance, user sessions, dead lock detail, system errors etc and visualize them on a custom dashboard. Data Synchronization Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency Real-Time Data Receive data and information in real time Data Storage Management Manage and store data in a database Show More ##### ## Support (4) Text Search Provides support for international character sets and full text search. Data Types Supports multiple data types like primitive, structured, document etc. Languages Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. Operating Systems Available on multiple operating systems like Linux, Windows, MacOS etc. Show More ##### ## Performance (6) Disaster Recovery Provides data recovery functionality to protect and restore data in a database. Data Concurrency Allows multi-version concurrency control. Workload Management Handles workloads, from single machines to data warehouses or web services with many concurrent users. Advanced Indexing Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. Query Optimizer Helps interpret SQL queries and determine the fastest method of execution. Integrated Cache Stores frequently-used data in system memory quickly. Show More ##### ## Management (4) Data Schema Data is organized as a set of tables with columns and rows like a table structure. Query Language Allows users to create, update and retrieve data in a database. ACID - Complaint Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. Data Replication Provides log-based or/and trigger-based replication. Show More ##### ## Availability (8) Auto Sharding Implements auto horizontal data partitioning that allows storing data on more than one node to scale out. Auto Recovery Restores a database to a correct (consistent) state in the event of a failure. Data Replication Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc. Auto Sharding Implements auto horizontal data partitioning that allows storing data on more than one node to scale out. Auto Recovery Restores a database to a correct(consistent) state in the event of a failure. Data Replication Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc. Backup and Recovery Create backups and provide methods to recover deleted/lost data Real-Time Data Receive data and information in real time Show More ##### ## Support (5) Operating Systems Available on multiple operating systems like Linux, Windows, MacOS etc. Multi-Model Provides support to handle structured, semi-structured, and unstructured data with equal effect. Operating Systems Available on multiple operating systems like Linux, Windows, MacOS etc. BI Connectors Allows users to connect business intelligence tools to the database. Data Connectors Connect to big data sources Show More ##### ## Performance (2) Query Optimization Helps interpret SQL queries and determine the fastest method of execution Ad hoc Query One-off queries made on an as-needed basis Show More ##### ## Generative AI (2) AI Text Generation Allows users to generate text based on a text prompt. AI Text Summarization Condenses long documents or text into a brief summary. Show More ##### ## Agentic AI - Data Fabric (5) Autonomous Task Execution Capability to perform complex tasks without constant human input Multi-step Planning Ability to break down and plan multi-step processes Cross-system Integration Works across multiple software systems or databases Adaptive Learning Improves performance based on feedback and experience Decision Making Makes informed choices based on available data and objectives Show More ##### ## Additional Functionality (66) Database Conversion Transformation of data from one format to another Monitoring Observe and track the demand, usage, progress or quality of a system, product, or user Activity Dashboard Dashboard to view the status of ongoing processes, identify current incidents and track past activities Data Extraction Automatically retrieve and pull information from documents, websites, images, data sets, and other sources Reporting/Analytics View and track pertinent metrics to find patterns and gain insights from data Automatic Backup Data is backed up automatically to prevent data loss Real-Time Monitoring Active monitoring of systems, applications, or networks Audit Management Plan, schedule, and execute organization's accounts and assets to ensure compliance with policies and laws Data Visualization Graphical representation of data Ad hoc Reporting Generate one-off reports that meet information requirements Compliance Management Track and manage adherence to policies for any service, product, process, or supplier Indexing Compile and organize data into specific metrics Search/Filter Search and filter data across systems to locate required information by entering keywords or certain criteria Alerts/Notifications Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges Data Verification Process of checking different types of data for accuracy to avoid errors or inconsistencies Performance Testing Allows developers to check if their applications/web browsers are running as expected. Data Capture and Transfer Import, collect, and capture data from multiple sources Security Auditing Systematic evaluation of the security of a company's overall security system and situation Access Controls/Permissions Define levels of authorization for access to specific files or systems Role-Based Permissions Set & manage permission levels based on user roles and restrict access to only authorized individuals Data Mapping Track the management and flow of data throughout the organization Data Retrieval Search and find data in a structured format AI Copilot A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users Third-Party Integrations Set up connections to third-party platforms to improve business processes Generative AI Use AI to generate content in the form of text, images, videos, etc. Configuration Management Identify component attributes like servers, hardware, software, and manage relationships across all services Audit Trail A record of all activities within the system, including user access, changes made, etc. For NoSQL Databases Specific for use in NoSQL Databases Data Import/Export Import and export data to and from software applications Data Migration Move from one database to another, or upgrade the version of database software being used Data Synchronization Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency API Application programming interface that allows for integration with other systems/databases Serverless Accessibility Compatible with serverless backends Multiple Data Sources Allows users to manage data from a number of sources Workflow Management Create, design and manage workflows for repetitive tasks Third-Party Integrations Set up connections to third-party platforms to improve business processes Data Extraction Automatically retrieve and pull information from documents, websites, images, data sets, and other sources Relational Database Management Database management based on relationships between data SSL Security Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access API Application programming interface that allows for integration with other systems/databases Data Connectors Connect to big data sources Search/Filter Search and filter data across systems to locate required information by entering keywords or certain criteria Reporting & Statistics Collection, analysis, and representation of numerical data and generation of reports to understand various patterns Customizable Templates Pre-designed layouts that can be customized to match preferences and requirements AI Copilot A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users Full Text Search Search for specific words or phrases within a document or database Data Virtualization Retrieve and use data without requiring technical details about the data Data Import/Export Import and export data to and from software applications Generative AI Use AI to generate content in the form of text, images, videos, etc. Drag & Drop Assemble applications and processes by dragging over and arranging pre-built components Customizable Fields Customize data fields to support various needs and use cases Authentication Verify the identity of users/devices to enable secure access Data Visualization Graphical representation of data Secure Data Storage Securely stores data to prevent data loss or breaches Activity Dashboard Dashboard to view the status of ongoing processes, identify current incidents and track past activities Data Mapping Track the management and flow of data throughout the organization Multiple Programming Languages Supported Run stored procedures and queries in multiple programming languages, such as JSON, Java, Python, Ruby, Perl, and SQL Data Capture and Transfer Import, collect, and capture data from multiple sources User Management Manage user accounts, profiles, roles, permissions, and other details across applications, devices or networks NOSQL Database Management Database management based on customization, fluidity, and document relations Access Controls/Permissions Define levels of authorization for access to specific files or systems Calendar Management Track and manage schedules and meetings via an integrated calendar Real-Time Monitoring Active monitoring of systems, applications, or networks Document Storage Store and organize documents in a centralized system Audit Management Plan, schedule, and execute organization's accounts and assets to ensure compliance with policies and laws Charting Manage patient documentation describing all clinical interactions, diagnoses, procedures, medications, etc. Show More ## Top-Rated Alternatives [ ![Microsoft SQL Server](https://images.g2crowd.com/uploads/product/hd_favicon/a8a99a96fda235658139f710592f8a53/microsoft-sql-server.svg "Microsoft SQL Server") Microsoft SQL Server 4.4/5(2,287) ](https://www.g2.com/products/microsoft-sql-server/reviews) [ ![PostgreSQL](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_251be2af3ae607c45c14e816eaa1cf41/postgresql.png "PostgreSQL") PostgreSQL 4.4/5(684) ](https://www.g2.com/products/postgresql/reviews) [ ![IBM Db2](https://images.g2crowd.com/uploads/product/hd_favicon/1553782253/ibm-db2.svg "IBM Db2") IBM Db2 4.1/5(683) ](https://www.g2.com/products/ibm-db2/reviews) [ View All Alternatives ](https://www.g2.com/products/intersystems-iris/competitors/alternatives) ## Technology Glossary Features View full feature definition View definitions of the features and discover new technology terms. [View Glossary](/glossary) [Data Modeling](/glossary/data-modeling-definition) Data modeling is the process of creating visual representations of information systems to better communicate the connections between data points and structures. Learn more about data modeling in this G2 guide. [Data Manipulation](/glossary/data-manipulation-definition) Data manipulation is the process of organizing, modifying, and transforming data to improve accuracy, usability, and analysis across systems and workflows. InterSystems IRIS Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_251be2af3ae607c45c14e816eaa1cf41/postgresql.png "Product Avatar Image") PostgreSQL 4.4/5(684) [ Compare Now ](https://www.g2.com/compare/intersystems-iris-vs-postgresql) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_82f55e945509bff7b8009e8024cfe73c/oracle-database.jpg "Product Avatar Image") Oracle Database 4.3/5(1,020) [ Compare Now ](https://www.g2.com/compare/intersystems-iris-vs-oracle-database) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_0d3b67827912f22174857de9475977c9/microsoft-sql-server.jpg "Product Avatar Image") MS SQL 4.4/5(2,287) [ Compare Now ](https://www.g2.com/compare/intersystems-iris-vs-microsoft-sql-server) ##### Categories on G2 [Relational Databases](https://www.g2.com/categories/relational-databases)[Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms)[Document Databases](https://www.g2.com/categories/document-databases) [Relational Databases](https://www.g2.com/categories/relational-databases)[Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms)[Document Databases](https://www.g2.com/categories/document-databases)[Key Value Databases](https://www.g2.com/categories/key-value-databases)[Data Fabric](https://www.g2.com/categories/data-fabric)[XML Databases](https://www.g2.com/categories/xml-databases)[Object-Oriented Databases](https://www.g2.com/categories/object-oriented-databases) [Show MoreShow Less](javascript:void(0);) ##### Explore More [What platform integrates social suites with CRM and marketing tools?](https://www.g2.com/discussions/what-platform-integrates-social-suites-with-crm-and-marketing-tools)[What's the best sales intelligence platform for building highly targeted prospect lists with robust industry, role and company-size filters?](https://www.g2.com/discussions/what-s-the-best-sales-intelligence-platform-for-building-highly-targeted-prospect-lists-with-robust-industry-role-and-company-size-filters)[Which log monitoring platform offers the fastest alerting features?](https://www.g2.com/discussions/which-log-monitoring-platform-offers-the-fastest-alerting-features) [Top cloud content solutions for improving team productivity](https://www.g2.com/discussions/top-cloud-content-solutions-for-improving-team-productivity)[Top ABM analytics tools for enterprise marketing teams](https://www.g2.com/discussions/top-abm-analytics-tools-for-enterprise-marketing-teams)[Pros and Cons Details](https://www.g2.com/products/intersystems-iris/reviews?qs=pros-and-cons) [Show MoreShow Less](javascript:void(0);)