- #AQUA DATA STUDIO FREE ALTERNATIVE GENERATOR#
- #AQUA DATA STUDIO FREE ALTERNATIVE DRIVER#
- #AQUA DATA STUDIO FREE ALTERNATIVE DOWNLOAD#
On some versions of Windows, this is located in Control Panel > Administrative Tools. To do this, use the 32-bit version of ODBC Data Source Administrator on your Aqua Data Studio machine. Configure a System ODBC data source for the database that you want to connect to in Aqua Data Studio.The process for using the Easysoft JDBC-ODBC Bridge with Aqua Data Studio is as follows: Note that the Easysoft JDBC-ODBC Bridge only supports 32-bit ODBC drivers. It is fully supported by Easysoft and is currently being deployed in production environments throughout the world. The Easysoft JDBC-ODBC Bridge has a Java component and a 32-bit native component. For example, the NVARCHAR column value, Production.Product, is returned as (null), when the SQL Server AdventureWorks database is accessed by using the JDBC-ODBC Bridge.Īs an alternative, if you need to connect Aqua Data Studio to an ODBC driver, you can also use the Easysoft JDBC-ODBC Bridge instead. Instead of the expected value for a Unicode column, "(null)" is returned. There appears to be an issue with Unicode data retrieved via the JDBC-ODBC Bridge.The JDBC-ODBC Bridge is not recommended for production use.
#AQUA DATA STUDIO FREE ALTERNATIVE DOWNLOAD#
You need to download a 1.7 version of the Java Runtime Environment (JRE) from AquaFold to use the JDBC-ODBC Bridge with Aqua Data Studio. Aqua Data Studio currently ships with Java 1.8, which no longer contains the JDBC-ODBC Bridge.Please bear in mind the following when using the JDBC-ODBC Bridge that's included in the Java distribution with Aqua Data Studio:
#AQUA DATA STUDIO FREE ALTERNATIVE DRIVER#
For example, if you wanted to analyse data in Aqua Data Studio, you could connect to in the following way:Īqua Data Studio > JDBC-ODBC Bridge > ODBC Driver > For example, Aqua Data Studio can work with data stored in Amazon Redshift and ships with a dedicated connector for this data store.Īqua Data Studio can also use the JDBC-ODBC Bridge that's included in the Java distribution as a generic connector for data stores for which there is an ODBC driver. It is a scalable database management tool worth trying for handling large data sets.Aqua Data Studio can analyse data stored in a number of back ends and includes a number of dedicated connectors for this purpose.
#AQUA DATA STUDIO FREE ALTERNATIVE GENERATOR#
The ER diagram generator allows you to obtain a graphical representation of the database structure, while the integrated query builder helps you generate and execute queries and view results displayed as 2D or 3D charts.Īside from the above, there are more features waiting to be discovered in Aqua Data Studio. The IDE features debugging capabilities and allows you to easily import and export data using the dedicated wizards that can guide you throughout the entire process. The application's feature set is completed by the integrated database administration tools, which enable you to manage instances, connections, sessions or storage capacity, as well as generate server statistical reports. The editor features syntax highlighting, line numbering, auto-complete functionality and suggestions, all meant to significantly ease your work. The integrated schema script generator assists you in creating SQL scripts. You can change or create indexes, users, permissions and procedures, as well as edit the data definition language of a database object. Servers and database schemas are displayed in tree-view, for easier navigation and understanding of the structure.Īqua Data Studio displays data in a structured manner, enabling you to create new tables or easily modify existing ones. The main advantage of Aqua Data Studio is that it does not limit the number of servers you can connect to, which means that you can work with multiple databases simultaneously. It provides support for multiple types of relational databases, such as MySQL, Microsoft SQL Server, Sybase, Oracle, DB2, Apache Cassandra, Derby and Hive, Informix, MongoDB, PostgreSQL, SQLite and more. Aqua Data Studio implements a reliable database administration system that can be used for browsing database contents and running SQL scripts.
0 kommentar(er)
