Database Development and Management Features

Read what people say are the most valuable features of the solutions they use.
Team Lead - Oracle Applications DBA at a energy/utilities company with 1,001-5,000 employees
The 13cR3-PG (Patch Group) 1 updates to the OEM family, strongly integrate Cloud (off-site, hybrid and on-premise) services providing a seamless way to see all of your resources regardless of where they are deployed. PG1 adds enhancements for EMCLI (Command Line Interface) extensions to allow additional automation and scripting of common OEM tasks (Blackout begin/end, Patch availability monitoring, cloning enhancements.) Of the 12c series of Oracle Enterprise Manager products, version 12.1.5.0.x introduces Cloud (both public and private) support for both monitoring, and lifecycle management. This allows individual components, or entire systems to be resident either in-house on conventional hardware/VM's, or ported into virtualized datacenter environments, off-site, whether for fault tolerance and disaster recovery, or simply to reduce the cost of non-Production systems by using a pay-to-play methodology (reducing investment in specific hardware just to support disposable and transitional software systems development?) Consolidated and uniform monitoring of all Oracle-related technologies. Ability to enable centralized control and administration of Oracle products from a single console. Ability to see at a glance, all conditions of all products throughout the enterprise. Version 13c includes hybrid cloud support making transparent the transfer of provisioning systems between Oracle's Cloud and on-premise equipment. All of the cloud systems and in-house systems appear in logical groups according to their common function (Applications, Middleware, Databases, etc.) The configurations are also snapshot-friendly and made comparable to quickly isolate differences between similar systems. View full review »
Chris Bradham says in an Oracle Enterprise Manager review
Senior Technical Director at a consultancy with 51-200 employees
SQL Tuning Advisor, ADDM, Top Activity, ASM Space Manager, Incident Notifications. The ability to identify performance bottlenecks and make an immediate impact can serve as a significant contribution to Database Administers which saves time and resources. View full review »
DataArchd5df says in an IDERA ER/Studio review
Asst. Director, Data Management & Analytics at a university with 10,001+ employees
The engineering portion, developing new models, dimensional models, not relational models. For the data we're hosting, dimensional modeling is more useful. View full review »
Larry Wilson says in an IDERA ER/Studio review
Data Architect at a insurance company with 1,001-5,000 employees
* Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch. * Data lineage tracking: It allows us to identify upstream and downstream systems using data. This allows us to identify downstream impacts of making changes to data in a particular system, before the downstream systems break. * Collaboration features in Team Server: With discussion threads, email notifications, and streams, we can collaborate with team members to make sure that models and glossaries are sufficiently defined to accurately and concisely reflect the meaning, purpose, etc. of our enterprise data. * Change management: We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify. View full review »
Prerak Trivedi says in an Oracle Enterprise Manager review
Consultant at a energy/utilities company with 10,001+ employees
Max use was server monitoring and operations of applications. This helps handling of critical situations in a production and support for the customers. View full review »
reviewer1208148 says in a Quest Spotlight review
DBA at a consultancy with 10,001+ employees
The time monitoring is a very useful feature. The solution is also very useful for analyzing if you have a problem. It's free to see via graphics varying times in order to analyze a problem. View full review »
Presales Consultant at a tech vendor with 10,001+ employees
The most valuable feature of this solution is the support for older databases and the ability to manage them in a centralized dashboard. For example, I can see my SQL servers and DB2 servers on one dashboard. View full review »
Ahmad Abdulfattah says in a Quest SharePlex review
Senior Solutions Architect at a tech vendor with 501-1,000 employees
The synchronization, data backup, and data transfer are all valuable features of the solution. The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent. View full review »
Nishant Panchal says in a Nutanix Era review
Sr.System Engineer / Consultent (Professional Services) - Infrastructure Management at Future Technology Systems Co. (FutureTEC)
The most valuable features are working with database errors. There are a lot of options for working with the database. The interface is easy to use. View full review »
Piotr Pastuszka says in a Toad review
E-service at a financial services firm with 201-500 employees
I like a lot of the features in this solution including the Session Browser, Tablespace, and the bind parameters. View full review »
Mohamed Ramses says in a MIMIX review
IT Consultant at a government with 11-50 employees
The most valuable feature is data replication. Everything about the solution is very simple, which makes it easy to use. View full review »
Technicab611 says in a Toad review
Technical consultant/lead at a tech services company with 5,001-10,000 employees
The feature that is handy in Toad is that I think it is best for working with Oracle. Currently, I'm using DBeaver, SQL Server, SQL Developer, and Postgres. We are using multiple databases and tools and use Toad for Oracle only. Toad might be good for other situations but I never used it. When we have another kind of database or multiple database types, then we go to DBeaver, which is very handy right now. View full review »
Valerii Shchipanovskyi says in a Toad review
Sales Engineer at BAKOTECH LLC
The most valuable features are the database architecture, the good functionality, and the user interface. View full review »
Rajat Wadhwani says in a Toad review
Process Data Engineer (Subsurface and Wells) at a energy/utilities company with 10,001+ employees
SQLBuilder really helps to play with the data and develop SQL queries to extract data from huge databases as per the requirement. View full review »
Reviewer967458 says in an IDERA ER/Studio review
Database Developer at a financial services firm with 1,001-5,000 employees
The data modeling module is important to me because I am a database developer and designer. I also take part in designing applications and that always starts with data modeling. It's very fast, reliable, up-to-date, so easy to use, smooth. The solution is also easy to explain to others and the graphics are good. Finally, the menu choices are also important. There are a lot of them and they are good. View full review »
reviewer960693 says in an Oracle Enterprise Manager review
Software Developer at a tech services company with 10,001+ employees
The masking features are good, and many new options and features are available in OEM for masking when compared to other tools. View full review »
Mariya Salamatova says in an IDERA ER/Studio review
Senior Business Intelligence Developer at a wholesaler/distributor with 51-200 employees
The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes. View full review »
Reviewer951561 says in an IDERA ER/Studio review
Database Administrator at a government with 10,001+ employees
The modeling part of the tool. We use the solution to create data models which describe our company's data architecture. It is a mix of design upfront when we get changes. We also use the data models after we've implemented changes. It does help in regards to redundancy with standardization across models. View full review »
SeniorDB3550 says in an IDERA SQL Diagnostic Manager review
Senior DBA Lead at a government with 10,001+ employees
There are so many features. One of the most valuable features is the ability to alert, proactively, on a variety of issues on which we would normally not get a heads-up, that something is going to happen. The alerting functionality is important. There are a few pre-designed reports that we use for database and disk usage growth, that allow us to show, over time, how much a database and disk space have grown. They help us plan for the coming year. View full review »
Reviewer937893 says in an IDERA SQL Diagnostic Manager review
Senior Manager, Data Operations at a Consumer Goods with 201-500 employees
The most valuable features are disk space projections for planning, and also the Snapshotting ability, to look back in time, to see what was going on the server at a particular time. It's basically the output of an sp_who2. View full review »
DBA8d65 says in an IDERA ER/Studio review
DBA at a consultancy with 501-1,000 employees
The most valuable features are the various features for different databases, but mainly those that enable me to represent the database to the development community and the business users. View full review »
Jessie Quinn says in an Oracle Enterprise Manager review
Senior Enterprise Database Engineer at a financial services firm with 501-1,000 employees
I have found the singular GUI feature very helpful. Fewer DBA resources can be allocated with Toad licenses. View full review »
Database9ac8 says in an IDERA ER/Studio review
Database Administrator at a healthcare company with 1,001-5,000 employees
The reverse engineering is the most important feature. The relationships are also important. View full review »
Mike Grove says in an IDERA ER/Studio review
DBA at a manufacturing company with 201-500 employees
One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded. View full review »
Jamie Vasser says in an IDERA ER/Studio review
IT Specialist at a government with 10,001+ employees
The most valuable feature is data modeling, primarily, because it's something that has been lacking in our systems development for 20 years. There was no accountability for data structure. View full review »
Sign Up with Email