MySQL (also on Amazon Aurora and Google Cloud SQL).Apache Hive, Apache Impala, and Apache Spark.Natively, Aqua Data Studio can connect to the following data sources: Further, Aqua Data Studio can connect to additional data sources via Java database connectivity (JDBC) and open database connectivity (ODBC). visual analytics including integration with R for computational statisticsĪqua Data Studio can query proprietary and open-source platforms, relational databases, NoSQL databases (including column-oriented databases and document-oriented databases), embedded databases, in-memory databases, distributed databases, massively parallel processing (MPP) databases, data warehouses, and spreadsheets.version control with clients for Apache Subversion (SVN), Concurrent Versions System (CVS), Git, and Perforce.database schema comparison with synchronization and data comparison.open application programming interface (open API).The prominent software features of Aqua Data Studio are : Īqua Data Studio is currently part of the portfolio of Idera, Inc. In July 2017 AquaFold was acquired by Idera, Inc. Its first release to general availability was in 2002. History Īqua Data Studio was created in 2001 by Niels Gron shortly after founding AquaFold, Inc. Refer also to the German (Deutsche), Italian (Italiano), and Spanish (Español) version of this page. It is proprietary software that is distributed under a software license for commercial software as trialware.Īqua Data Studio is being developed by AquaFold, Inc. ![]() It integrates with the programming language R for computational statistics.Īqua Data Studio is a desktop application software that is written in Java with a graphical user interface. It also uses the Java database connectivity (JDBC) and open database connectivity (ODBC) application programming interfaces (APIs) to interact with databases via JDBC and ODBC database drivers. It is commonly used for exploratory data analysis and data visualization, specifically for business intelligence.Īqua Data Studio uses proprietary database drivers to connect to a range of databases including relational databases, NoSQL databases, and cloud databases. Aqua Data Studio is intended for use by software developers, database administrators, business analysts, and data analysts. It integrates database management, database design, database administration, SQL programming, data management, and visual analytics into a single application software. Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Aqua Data Studio is an integrated development environment (IDE) for data sources such as Microsoft Excel and databases. If not set, tables from all databases will be returned.įor assistance in constructing the JDBC URL, use the connection string designer built into the MySQL JDBC Driver. Optionally, Database can be set to connect to a specific database. ![]() If IntegratedSecurity is set to false, then User and Password must be set to valid userĬredentials. ![]() The Server and Port properties must be set to a MySQL server. URL: Enter the JDBC URL, which starts with jdbc:mysql: and is followed by a semicolon-separated list of connection properties. Driver: Enter the Driver's class name,.Driver Location: Click the Browse button and select the file, located in the lib subfolder of the installation directory.Name: Enter a name for the data source for example, MySQL.Enter the following JDBC connection properties:.In the Register Server form, select the 'Generic - JDBC' connection.In Aqua Data Studio, select Register Server from the Servers menu.The MySQL data source can then be accessed from Aqua Data Studio tools. You can use the connection manager to define connection properties and save them in a new JDBC data source. This article shows how to connect to MySQL data through the connection manager and execute queries. The CData JDBC Driver for MySQL integrates MySQL data with wizards and analytics in IDEs like Aqua Data Studio.
0 Comments
Leave a Reply. |