Design, administer, automate and execute SQL scripts. Build queries and edit JavaScript and Java code. Work with multiple types of relational databases, such as MySQL, Microsoft SQL Server, Sybase, Oracle, DB2, Apache Cassandra, Derby and Hive, Informix, MongoDB, PostgreSQL, SQLite, etc.
Database developers are tasked with creating software applications that include complex business logic and access ever-changing database ecosystems, while database administrators must manage these complex environments that may incorporate a myriad of platforms and versions. Todays database environments are growing exponentially in volume, velocity, and variety, making the database professionals roles even more challenging and time-consuming. Additionally, database developers are expected to work seamlessly across disparate DBMSs and integrate their work with source control systems as part of their regular software development cycle.
Database administrators have different levels of responsibilities, and it depends on exactly what they are managing. Those that need a general-purpose tool to compare and synchronize schema objects and data and to track database sessions, instances and security will find that Aqua Data Studio meets these needs and more for many different platforms.
Business and data analysts often need to manipulate the data from the SQL queries in order to use it for analysis and decision-making, but they dont need a high-end technical tool for this. Visual Analytics lets them create beautiful visualizations and dashboards of the data to explore or share with others. Reduce costs for non-power users with Aqua Data Studio.
Aqua Data Studio provides an extensive toolset that combines SQL scripting, query building, and debugging with database object navigation and table data editing. Aqua Data Studios single interface lets developers work across database platforms so organizations can standardize on one solution and maximize database development efficiency.
v10.0 [Aug 31, 2011]
ADStudio breaks new ground for Relational Database tools with the introduction of the Aqua Open APIs, a JavaScript based language called AquaScript and a full-fledged Integrated Development Environment (IDE). Users will now have API access to nearly all of ADStudio's built-in functionality and be able to create fully automated end-to-end solutions. This includes current functionality around database access, database schema DDL generation, compare tools, version control, data pivoting, charts and much more. We have also introduced new functionality, including random data generation, statistical functions, local file system and Hadoop file system. It also has additional ADStudio enhancements such as New Database Support: Netezza, Charting Enhancements,ER Model Enhancements, Table & Index Partitioning Enhancements and much more
