Database Tools
Application Performance
Precise
Idera Precise is a database management and performance analysis tool. It helps database administrators optimise performance, find and resolve problems, and increase the security and availability of their databases. The tool supports a wide range of database platforms, including Oracle, SQL Server, DBXNUMX and MySQL.
Backup and Administration
DBArtisan
DBArtisan is a database administration tool developed to administer databases. DBArtisan is designed to help database administrators manage and optimise the performance of their databases. The tool supports a variety of database platforms, including Oracle, SQL Server, DB2, Sybase, Snowflake, Teradata and MySQL. DBArtisan offers features such as security management, performance analysis, schema and data management, as well as easy access to databases via a graphical user interface. It also helps automate key database administration tasks to reduce manual work and improve efficiency.
SQL Admin Toolset
Database administrators need simple and quick ways to manage their SQL Server environment. SQL Admin Toolset provides 24 essential desktop tools for SQL Server to save time by simplifying routine administrative and troubleshooting tasks.
SQL Enterprise Job Manager
IDERA SQL Enterprise Job Manager is a database administration tool specifically developed to help database administrators manage and automate jobs for SQL Server. It provides database administrators with an overview of all scheduled jobs and their performance, as well as the ability to create, edit and delete jobs. Jobs can be scheduled to run at specific times or on certain events, and it is also possible to create and manage jobs that are linked to certain databases or servers.
The tool also has a function to track and manage failed jobs, as well as a function to generate reports and monitor the performance of the jobs. This can help database administrators identify and resolve problems with the jobs and improve the performance and availability of the databases.
SQL Safe Backup
SQL Safe Backup is a tool for safe backup of SQL Server databases from Idera (formerly Embarcadero Technologies). The tool is designed to automate and optimise the backup process for SQL Server databases. It enables database administrators to create database backups with minimal impact on performance and availability, and to restore databases with high speed and quality.
SQL Safe Backup offers features such as:
SQL Safe Backup is one of the tools in the IDERA SQL Admin Toolset.
SQL Virtual Database
Idera SQL Virtual Database is a feature of Idera’s data management software that allows users to create a virtual copy of a SQL Server database. The virtual copy, or VDB, can be used for a variety of purposes, such as testing, reporting, or providing a read-only copy of the data to users without giving them access to the live database. The VDB is created using a process called “snapshot” which creates a point-in-time copy of the data stored in a different location. This allows the VDB to be used independently of the live database without affecting its performance. The VDB can be restored to a previous state at any time, and it can be used to test upgrades and schema changes before they are implemented on the live database.
SQL Toolbox
IDERA SQL Toolbox is a collection of tools for SQL Server administrators. It is a collection of different tools that help to manage, monitor, and optimise SQL Server databases, similar to IDERA SQL Management Suite, but with more focus on various specific tasks. It provides a comprehensive set of tools to manage and optimise SQL Server databases, and can be used to manage large numbers of databases across multiple servers.
Data Modeling and Architecture
Enterprise Architect
Sparx Systems Enterprise Architect is a visual modelling and design tool for software and business systems. It supports a wide range of modelling languages and standards, including Unified Modelling Language (UML), Business Process Modelling Notation (BPMN), and ArchiMate.
It has features for designing and documenting software architecture, reverse engineering existing code, creating and managing requirements, testing and validation, and more. It also includes collaboration and project management tools to support teamwork and version control.
It is a comprehensive tool that can be used by software developers, systems architects, business analysts, and other stakeholders to design, document, and validate the structure and behavior of complex systems. It also supports various platforms like Windows, Mac, Linux and also available as Cloud version.
ER/Studio
ER/Studio is a database modeling tool designed to help developers, database administrators, and architects create, manage, and optimise database models for SQL Server, Oracle, DB2, Sybase, and other database platforms.
The tool has a graphical user interface that enables users to create and manage database structures, including tables, joins, and stored procedures, as well as to compare and synchronise database structures between different database environments. The tool also has tools to automate SQL script generation, data and metadata retrieval, and helps keep track of database model versions.
ER/Studio is a professional tool designed to help optimise database models, improve performance and security, and facilitate collaboration between developers, database administrators, and architects.
Database Development
DB Change Manager
DB Change Manager is a tool for database administration specifically developed to help database administrators manage and trace database changes. The tool allows database administrators to keep track of who does what and when in the database and to track and roll back changes to the database.
DB Change Manager offers features such as:
DB Change Manager is a tool for database administration that helps automate and manage database changes while providing database administrators with ways to monitor and track changes in the database to improve security and performance.
Database Suites
SQL Comparison Toolset
The SQL Comparison Toolset allows database administrators to compare and synchronise database structures and data between different database environments. The tool enables database administrators to compare and synchronise databases, including tables, views, stored procedures, functions, and triggers, to ensure database consistency and integrity.
SQL Comparison Toolset offers features such as:
The SQL Comparison Toolset is a tool that helps database administrators compare and synchronise databases while providing the ability to monitor and track database changes to ensure database consistency and integrity. It is one of the tools in the IDERA SQL Admin Toolset.
DB PowerStudio
DB PowerStudio is designed to help database developers and administrators to manage, design and develop databases, mainly for SQL Server databases, but also supports other databases such as Oracle, MySQL and DB2.
DB PowerStudio offers various features such as:
DB PowerStudio is a comprehensive tool for database management and development. It enables database developers and administrators to manage and optimise their databases efficiently. It is a good option for SQL Server database management and development.
SQL Management Suite
IDERA SQL Management Suite is a collection of tools that is used to manage and optimise SQL Server databases. It provides a wide range of functionality to help administrators, developers, and DBAs manage their SQL Server databases, including:
It provides a comprehensive set of tools to manage, monitor, and optimise SQL Server databases, and can be used to manage large numbers of databases across multiple servers. It also includes some of the features that IDERA SQL Security Suite includes.
SQL Security Suite
IDERA SQL Security Suite is a security solution specifically designed for SQL Server databases. It provides a set of tools and features to help secure and protect SQL Server databases from threats such as unauthorised access, data breaches, and compliance violations. Some of the features that IDERA SQL Security Suite may include are:
It is a third-party software that helps to secure your SQL servers from various threats, and it can be integrated with other security tools to provide a comprehensive security solution.
Monitoring and Performance
DB Optimiser
Embarcadero DB Optimiser simplifies SQL optimisation and development for application developers with many features for improving productivity and reducing errors. A rich SQL IDE with statement tuning, data source profiling, code completion, real-time error checking, code formatting and sophisticated object validation tools helps streamline coding tasks.
SQL BI Manager
SQL BI Manager provides agentless monitoring of the servers and services for SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services.
SQL Defrag Manager
Idera Defrag Manager is a software tool from Idera that helps optimise the performance of SQL Server databases by defragmenting their indexes. Defragmentation is the process of reorganising the data in a database to increase the speed and efficiency of queries. When a database is heavily used, its indexes can become fragmented, which means that the data is spread out over many different pages and is not stored in a contiguous manner. This can lead to poor performance, as the SQL Server engine has to read multiple pages to retrieve the data it needs.
Idera Defrag Manager allows users to analyse and defragment the indexes in their SQL Server databases, either manually or on a schedule. It also provides detailed reporting on the fragmentation of the indexes, allowing users to identify which indexes are in need of defragmentation. The software also supports automated defragment of indexes and reporting of fragmentation levels. This can help to improve the performance and responsiveness of SQL Server databases and reduce the risk of data corruption.
SQL Diagnostic Manager
Idera Diagnostic Manager is a software tool from Idera that helps to diagnose and resolve performance issues in SQL Server databases. It allows users to monitor and analyse the performance of their databases in real-time, and provides a wide range of diagnostic and troubleshooting tools to help identify and resolve issues.
It includes features such as:
It also provides a web-based dashboard that allows users to easily view and manage the performance of their databases, and can be integrated with other Idera products to provide a comprehensive solution for managing and optimising the performance of SQL Server environments.
It can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues, improve the overall performance and availability of their SQL Server databases, and reduce the risk of data corruption.
SQL Doctor
Idera SQL Doctor is a software tool from Idera that helps diagnose and resolve performance issues in SQL Server databases. It is designed to be easy to use and provides a wide range of diagnostic and troubleshooting tools to help identify and resolve issues.
It includes features such as:
It allows users to quickly identify and resolve performance issues, improve the overall performance and availability of their SQL Server databases, and reduce the risk of data corruption. Additionally, it can be integrated with other Idera products to provide a comprehensive solution for managing and optimising the performance of SQL Server environments. It can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues and improve the overall performance and availability of their SQL Server databases.
SQL Inventory Manager
IDERA SQL Inventory Manager is a software tool from Idera that helps users to manage and inventory their SQL Server environment. It allows users to discover, inventory and document their SQL Server instances and databases, and provides detailed reporting on the configuration, performance, and security of their environment.
It includes features such as:
It allows users to quickly identify and resolve performance issues, improve the overall performance and availability of their SQL Server databases, and reduce the risk of data corruption. Additionally, it can be integrated with other Idera products to provide a comprehensive solution for managing and optimising the performance of SQL Server environments. It can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues and improve the overall performance and availability of their SQL Server databases.
SQL Toolbox
IDERA SQL Toolbox is a collection of software tools from Idera that are designed to help manage and optimise SQL Server databases. The toolbox includes a variety of tools that can help with tasks such as performance monitoring, troubleshooting, backup and recovery, and more. Some of the tools that are included in the SQL Toolbox are:
Each tool is designed to address a specific aspect of managing and optimising SQL Server databases, and can be used together to provide a comprehensive solution for managing and optimising the performance of SQL Server environments. The tools can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues and improve the overall performance and availability of their SQL Server databases.
Security and Compliance
SQL Compliance Manager
Simplify your SQL Server audits. SQL Compliance Manager is a comprehensive auditing solution that uses policy-based algorithms to track changes to your SQL Server objects and data. SQL Compliance Manager gives you detailed visibility to determine who did “what”, “when”, “where”, and “how”, whether the event is initiated by privileged users or hackers.
IDERA SQL Compliance Manager provides a centralised and automated solution for managing and auditing sensitive data, including the ability to:
It helps organisations to protect sensitive data, such as personal information and financial data, from unauthorised access, and to meet the requirements of regulatory and industry standards for data security and privacy. It can be used by database administrators, developers, and other IT professionals, as well as compliance and security teams, to quickly identify and resolve compliance issues and improve the overall security and compliance of their SQL Server environments.
SQL Secure
IDERA SQL Secure is a software tool from Idera that helps organisations to secure their SQL Server environment by identifying and remediating security vulnerabilities. It provides a centralised and automated solution for managing and auditing security, including the ability to:
It helps organisations to secure their SQL Server environment by identifying and remediating security vulnerabilities, such as weak passwords, unsecured data, and misconfigured servers. It can be used by database administrators, developers, and other IT professionals, as well as security teams, to quickly identify and resolve security issues and improve the overall security of their SQL Server environments.
SQL Database
InterBase
InterBase is a relational database management system (RDBMS) developed by Embarcadero Technologies. It is a high-performance, low-maintenance, and secure database that can be used for a wide range of applications, including web, mobile, and desktop. InterBase is known for its small footprint, high performance, and ability to run on a wide range of platforms, including Windows, Linux, and macOS.