5/8/2023 0 Comments Aqua data studio sql syntax![]() The Grid and Pivot Grid results include a Charting Toolkit. Aqua Data Studio’s Version Control Integration makes SQL Scripts display Inline Diff indicators in the Query Window. With a single click, query results can be exported to Excel or sent as an email attachment. To format your SQL statements, you can use the Beautify options. SQL Abbreviations and Automate features can save time when writing SQL statements. You can use extensive visual options such as joins, group bys, and sort order to create equality comparisons. The graphical user interface allows you to select columns and tables. You can install in seconds and evaluate the versatile database idea Manage SQL scripts, database, and Aqua Data Studio files using the integrated version control client for Subversion CVS Git, Git, Git, and Perforce.Convert models quickly from one platform to the next. To visualize a database model, reverse engineer existing databases. A forward engineer can model tables, views, and indexes and generate SQL scripts. This maximizes database development efficiency. This article was originally distributed on PRWeb.Developers can use one consistent interface to work across all databases platforms. AquaFold is headquartered in Sunnyvale, California. More than 300,000 users from over 98 countries use AquaFold's products to design, develop, model, and administer their relational databases. is a provider of database software tools for relational databases. Current license holders with expired subscriptions can renew their subscriptions for $174.65 USD, just 35% of the new license price.ĪquaFold, Inc. The cost of a single-user commercial license for Aqua Data Studio 15 remains $499.00 USD. A complete list of new features and enhancements may be viewed at. It is available for immediate download at. Database support has also been upgraded to include Vertica 7, DB2 10.5, MongoDB 2.6, and more.Īqua Data Studio Availability and PricingĪqua Data Studio 15 is localized into 21 languages and works with Windows, Mac OS X, Linux, Solaris, and the Java Platform. Hive support is much improved with drivers for MapR, Cloudera, and Hortonworks, support for HiveServer 2 and legacy support for HiveServer 1, as well as greater security with Kerberos authentication. Support has been added for Amazon Redshift and the NewSQL relational database VoltDB. Netezza imports that took 65 minutes now take less than 4 minutes."Īqua Data Studio 15 has also gained the ability to connect, query, and generate database-style results from Microsoft Excel files, making one of the most frequently used file formats on the planet even more useful. "Vertica imports of 100,000 rows that took 70 minutes before now take just 49 seconds. "The enhanced speeds are remarkable," says Gron. Multi-megabyte files with hundreds of thousands of rows now take seconds instead of minutes to import. The main query appears in its own tab, while unions and subqueries are built in additional tabs to keep complex queries more organized.Īlso improved in version 15 is Bulk Import of data. New to this version is a better way to visualize table unions, and support for subqueries. Users can now generate complex queries visually by dragging and dropping without ever typing a SQL statement. "You can analyze and share big data faster and more effectively than ever, which leads to better collaboration and smarter decision-making."Īlong with Aqua Data Studio's visualization improvements, the completely redesigned Visual Query Builder is more powerful and easier to use than ever. "The possibilities to create and share compelling visualizations and dashboards in Aqua Data Studio 15 is limitless," notes Gron. Additional calculations and filters, including moving averages or running totals, can be added instantly to gain greater insight. Even different types of charts can be combined to display data individually or merged into a single graph. Users drag and drop elements to combine and pivot datasets into visual representations, from pie graphs to trend lines. You can share data in a way that is instantly accessible and allows others to navigate and interact with it freely."īringing data to life in Aqua Data Studio has never been simpler. "Aqua Data Studio 15 turns any query into visuals that are immensely useful. "Instinctively we make more thoughtful observations about large amounts of data when we see it visually as graphs, charts, and trends," explains AquaFold's CEO, Niels Gron. In just a few clicks, Aqua Data Studio 15 can now combine pivot tables, charts, graphs, and other visualizations into interactive dashboards and workbooks, which can then be shared with colleagues and customers. has released Aqua Data Studio 15, a major upgrade to its universal database query and management software, with new features to create visualizations that illuminate underlying data. 16, 2014 (GLOBE NEWSWIRE) - via PRWEB - AquaFold, Inc.
0 Comments
Leave a Reply. |