#Aqua data studio free version download how to
#Aqua data studio free version download driver
#Aqua data studio free version download password

Connecting to Microsoft SQL ServerĬonnect to Microsoft SQL Server using the following properties: URL: Enter the JDBC URL, which starts with jdbc:sql: and is followed by a semicolon-separated list of connection properties.

Driver: Enter the Driver's class name,.

#Aqua data studio free version download driver

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, SQL Server.

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 SQL Server 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.

#Aqua data studio free version download how to

This article shows how to connect to SQL Server data through the connection manager and execute queries. The CData JDBC Driver for SQL Server integrates SQL Server data with wizards and analytics in IDEs like Aqua Data Studio.

It is a good idea to create the table in your database first and then import the data.

Always back up your database before making any changes.

Click Next If your import is successful, you should get this message. Choose the option “Import into Database” 7. If your file has column names in the first line, make sure to click this option. Click on browse to find your Comma Separated File (.csv) – if the file extension doesn’t show up, make sure you add it at the end. Queries 1.Click on database you are interested in (in this example MySQL) 2.Click on icon Query Analyzer 3.Write statements in window 4.Click on icon Execute Database: IU usernameĬonnecting to PostgreSQL Database through Aqua Data Studio – Part 2 9.Click on Driver tab 10.

#Aqua data studio free version download password

Choose a name 1.We click on this icon to Register Server 4.Write your IU username 5.Write PostgreSQL password 2.Choose PostgreSQL 6.Host: db. 7. Click okĬonnecting to PostgreSQL Database through Aqua Data Studio – Part 1 3. Choose a name 1.We click on this icon to Register Server 4.Write your IU username 5.Password same as PostgreSQL 2.Choose MySQL 6.Host: db. 7. Click okĬonnecting to MySQL Database through Aqua Data Studio 3. Choose a name 1.We click on this icon to Register Server 4.Write your IU username 5.Password same as username 6.Host: 7. You may have to scroll down.Ĭonnecting to Oracle Database through Aqua Data Studio 2.Choose Oracle 8i 3. Under General subcategory, check ‘ ’ Statement separator. In order for ADS to understand semi-colon separators, we must change some options inside the program. Different statement separators have different pros and cons the semi-colon is the standard statement separator for command line and GUI interfaces with many SQL languages, so we have opted for the semi-colon.

For this class, we are using prewritten SQL files that use a semi-colon as a statement separator. When working on your own with ADS, you have the option to either conform with this syntax requirement, or change the options in ADS to accept a semi-colon ( ) as a statement separator. Find the application We are using Aqua Data Studio v11Īqua Data Studio has a default setting which prefers / and GO as statement separators for SQL statements.