Aqua Data Studio
Your rating: Now say why...

0

Single interface for common relational databases.   Demo ($499.00)
Add to my Watch List
Email me when discounted
Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases.

This allows the DBA or developer to tackle multiple tasks simultaneously from one application. Aqua Data Studio's sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test scripts. It also features expository graphical browsing capabilities and the ability to save your query results in many formats including HTML and XML.
What's New
Version 14.0.11:

Enhancements:

  • Netezza : Import Tool : Retrofit Netezza Batch Import to V14
  • SQL Server : Visual Editing : Add support for Extended Properties to the database object
  • Netezza : Visual Editing : Qualify Object w/ Schema and Netezza 7.0.3 Multi Schema support
  • Netezza : FluidShell : Change schema command for Netezza with multi schema is not working for FluidShell
Bug fixes:
  • Sybase ASE : Visual Explain Diagram : String index out of range: 4230
  • Netezza : Visual Editing : Netezza Alter User Throws "java.lang.NullPointerException"
  • Hive : Method not supported message is shown while creating Index
  • SQL Server : OpenAPI : ExtractFunctions OpenAPI methed against MSSQL is very slow and seems to ignore schema parameted
  • Hive : Method not supported message is shown while creating Index
  • Sybase ASE : Extract/scripting of table with computed index is wrong
  • Hive : Cloudera : Can't connect with HiveServer2 for Cloudera Distribution
  • Hive : Aqua Commands : "Query Analyzer, using Hive, reverts the Database drop down back to default after command is submitted"
  • Hive : Cloudera : Query Analyzer : Autocompletion for Cloudera in 14.0.10 is not working
  • Hive : Cloudera : Query Analyzer : Use database does not change the database context in the dropdown for Cloudera
  • Hive : Cloudera : ER Modeler : "SQL Exception when you generate ER Diagram in Cloudera, as there are no indexes"
  • Hive : Cloudera : Schema Script Generator : "SQL Exception in Schema Script Generator in Cloudera, as there are no indexes"
  • Hive : Cloudera : Visual Editing : Data type mismatch in ADS Create Table GUI and Cloudera distribution
  • Hive : Query Analyzer : SQL Exception in Query Builder when you add a table
  • 11865 : Bug : Hive : Cloudera : ER Modeler : Data type mismatch in ADS Create Table GUI for ER Modeler and Cloudera distribution
  • Hive : Cloudera : ER Modeler : Disable index node for Cloudera ER Modeler
  • 11876 : Enhancement : Hive : "Added Free Form URL into Authentication Area. Also, eliminated population of realm for Kerberos if KDC is missing"
  • Netezza : ER Modeler : Generate Script is not taking into account the Schema Name
  • : Query Analyzer : Autocompletion is not displaying Netezza synonyms even when Enabled synonyms in Options
  • Netezza : Schema Browser : Constraint node for a particular schema displays all constraints in Database
  • Netezza : Visual Editing : Foreign Key Match Type comes with keyword UNSPECIFIED which gives error in Netezza
  • Sybase ASE : Functional indexes -> index can have non function and functional parameters
  • Hive : Cloudera : ER Modeler : Removed DATE/DATETIME, and Ordered Hive distributions.
  • Hive : Cloudera : ER Modeler : Eliminated ER index addition within the main menu
  • Decode the username for SQL Server Windows Authentication

Version 14.0.11:

Enhancements:

  • Netezza : Import Tool : Retrofit Netezza Batch Import to V14
  • SQL Server : Visual Editing : Add support for Extended Properties to the database object
  • Netezza : Visual Editing : Qualify Object w/ Schema and Netezza 7.0.3 Multi Schema support
  • Netezza : FluidShell : Change schema command for Netezza with multi more...
Requirements
  • Intel, 64-bit processor
  • OS X 10.5 or later
  • Java 1.6 Update 1 or later



MacUpdate - Aqua Data Studio



Aqua Data Studio User Discussion (Write a Review)
ver. 14.x:
Your rating: Now say why...
Overall:
(10)

sort: smiles | time
burypromote
-2

-2

Mitzanu reviewed on 30 Jun 2011
You can use DbSchema it's much cheaper and also it's one of the best software on the market, try it :)
[Version 9.0.15]


burypromote
+2

+2

solidated reviewed on 16 Jan 2009
I use Aqua Data Studio almost every day. Having switched from a PC last year, I'm on a Mac and this is the only tool available that's both commercially viable and at a reasonable price.

To the reviewers that complain about the $399 price: You guys aren't serious developers. ...Maybe database hobbyists, but no way you guys make a living developing anything. If you did, you'd know just how good a price it actually is. I actually can't think of any other commercial DB software that's cheaper. Can you?

I'm very happy with the available database connection types and options as well as the ease of use. Overall the application is rock solid. My only gripe is that on the Mac (don't know about other versions), I don't like the way windows behave when you're creating or altering a table. The focus of elements isn't what I'd prefer but I can deal with it.
[Version 7.0.22]


burypromote

-2
blee commented on 21 Jan 2008
I just came back to this software because I needed to do some database work and was shocked to see the price is no $399 thats pretty insane considering all the other options out there including the slew of free tools.
[Version 6.5.7]

1 Reply

burypromote
+1

+1
locomoco replied on 30 Jul 2008
You get what you pay for. For instance, look around and try to find a decent Stored Procedure debugger. There isn't too many.

Sybase Workspace Studio 2.0 costs like $2,000 per license. At that price $400 looks like a steal.
burypromote
-1

-1
yNot commented on 28 Jan 2007
Looks cool, but too expensive. If their price jumps $400 in one step, what's the next price increase going to be? Would have liked to continue to recommend this to my hosting clientele, but I am not going to get them into a program that sees such price increases. I would have much rather seen smaller and consistent price increases throughout the life of this product.
[Version 6.0.12]


burypromote
-1

+2
Nemesys commented on 16 Jan 2007
Ouch! What happened here? $399 for a single-user license? Sorry, that's way too expensive for hobbyists.
[Version 6.0.10]


burypromote
-1

-11
germano60 commented on 16 Jan 2007
Yep, not only it's no longer free but a single license costs $399!!!! OK, nice piece of sw, lots of effort, it's fair to ask money for it. OK, you have full functional version not-expiring for free but that's just for "evaluation purposes".

But going from totally free to $399 in just one shot, well guys, that's maybe one step too much.

What about considering a special discount or a special pricing for single-computer, single-user licensing?
[Version 6.0.10]


burypromote

+1
ennuini commented on 16 Jan 2007
While a good application, it should be noted that contrary to the information at the time I downloaded Aqua Data Studio, this version marks a changed pricing scheme, and is in fact no longer free.
[Version 6.0.10]


burypromote

+1

NadeemF reviewed on 06 Sep 2005
Great value (free for academics).
It does the job pretty well when I use it to query Oracle (both from a Mac and from Windows).
Some interactions seem a bit quirky, but it is probably more to do with my ignorance of some Oracle intricacies.
[Version 4.5.2]


burypromote
+2


Anonymous reviewed on 31 Aug 2005
I'm a professional database developer and this is the app I use for practically all my SQL work. I develop for MS SQL server but spend 90% of my time on a Mac. This is really the only app for the Mac that gets it right (I've tried them all and paid several hundred dollars for some of them). If I didn't have this I would have to spend a lot more time on my Windows machine. It's got a combination of features included in the Microsoft tools that ship with SQL server, plus a few that they don't have (like autocomplete of SQL statments, filling in table names and the like). It's intended for developers who know SQL, not casual users who want something to write SQL for them because they don't know how.

It is Java based but performance hasn't been an issue for me (I do most of my development on a dual G5). Note that my high rating in Value is partly because I'm an edu user and it's free for educational use - though I would pay if necessary.
[Version 4.5.1]


burypromote
Planeten.paultje@mac.com-Guhy commented on 29 Aug 2005
Pasco.com sells a data aquisition program for its probes called "Data Studio". Could be confusing.......
[Version 4.5.1]


There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.

There are currently no ratings. Write a comment or review now.

Downloads:32,674
Version Downloads:37
Type:Development : Java
License:Demo
Date:17 Apr 2014
Platform:Intel 64 / OS X
Price: $499.00
Overall (Version 14.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-10 of 21
1 2 3 >
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases.

This allows the DBA or developer to tackle multiple tasks simultaneously from one application. Aqua Data Studio's sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test scripts. It also features expository graphical browsing capabilities and the ability to save your query results in many formats including HTML and XML.


- -