Thu, 28 Jul 2016
Aqua Data Studio
Aqua Data Studio can analyse data stored in a number of back ends and includes a number of dedicated connectors for this purpose. For example, Aqua Data Studio can work with data stored in Amazon Redshift and ships with a dedicated connector for this data store.
Aqua 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. For example, if you wanted to analyse Salesforce.com data in Aqua Data Studio, you could connect to Salesforce.com in the following way:
Aqua Data Studio > JDBC-ODBC Bridge > Salasforce.com ODBC Driver > Salesforce.com
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 currently ships with Java 1.8, which no longer contains the JDBC-ODBC Bridge. 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.
- The JDBC-ODBC Bridge is not recommended for production use.
- There appears to be an issue with Unicode data retrieved via the JDBC-ODBC Bridge. Instead of the expected value for a Unicode column, "(null)" is returned. For example, the
Production.Product, is returned as (null), when the SQL Server AdventureWorks database is accessed by using the JDBC-ODBC Bridge.
As an alternative, if you need to connect Aqua Data Studio to an ODBC driver, you can also use the Easysoft JDBC-ODBC Bridge instead. The Easysoft JDBC-ODBC Bridge has a Java component and a 32-bit native component. It is fully supported by Easysoft and is currently being deployed in production environments throughout the world. Note that the Easysoft JDBC-ODBC Bridge only supports 32-bit ODBC drivers.
The process for using the Easysoft JDBC-ODBC Bridge with Aqua Data Studio is as follows:
- Configure a System ODBC data source for the database that you want to connect to in Aqua Data Studio.
To do this, use the 32-bit version of ODBC Data Source Administrator on your Aqua Data Studio machine. On some versions of Windows, this is located in Control Panel > Administrative Tools. On some version of Windows, you need to search for ODBC in the taskbar search box. The 32-bit version of ODBC Data Source Administrator should be clearly labelled. If in doubt, in the Windows Run dialog box, type:
- Download the Easysoft JDBC-ODBC Bridge. (Registration required.)
- Install and license the Easysoft JDBC-ODBC Bridge on the machine where the Aqua Data Studio is installed.
For installation instructions, see the Easysoft JDBC-ODBC Bridge documentation.
- In Aqua Data Studio, choose Server > Register Server.
The Register Server dialog box is displayed.
- In the left pane, choose Generic - JDBC.
- Complete the dialog box fields:
Field Value Name Easysoft JDBC-ODBC Bridge Login Name my_database_user
This field is only required of the target database requires it.
Password my_database_password URL jdbc:easysoft://localhost/data_source:logonuser=windows_user:logonpassword=password Driver easysoft.sql.jobDriver
- Use the Browse button to browse for EJOB.jar.
EJOB.jar is installed in the following location on the machine where you installed the Easysoft JDBC-ODBC Bridge:
On 64-bit Windows, the default location for <easysoft_install> is <drive>:\Program Files (x86)\Easysoft Limited\Easysoft JDBC-ODBC Bridge.
On 64-bit Windows, the default location for <easysoft_install> is <drive>:\Program Files\Easysoft Limited\Easysoft JDBC-ODBC Bridge.
- Save the Server to return to Acqua Data Studio.
- To retrieve some data, right-click the new Server in the Servers pane.
- Choose Query Analyzer.
- In the query pane, enter and then run a SQL Query.