SQL Azure With DBHawk

SQL Azure JDBC Connection & AdventureWorks Sample Databases Setup with DBHawk

SQL Azure is the relational data store for the Azure platform. DBHawk allows to connect to Azure database via JDBC connection.
Following tutorial shows how to connect to MS Azure database and install sample AdventureWorks database.

Installation
If you have not already done so, download and install DBHawk.

  1. Login to your Azure account at https://azure.microsoft.com/en-us/account/
  2. Create a New Azure SQL Database
     
    SQL Azure Database Creation
  3. After database creation, ensure that you have configured your Azure Firewall to allow a connection to your Azure server from your IP address.
    SQL Azure IP Address
  4. Follow http://msftdbprodsamples.codeplex.com/releases/view/37304 link to download and install Adventure Works for Azure SQL Database.
     
     
    SQL Azure Adventure Works
  5. After successful AdventureWorks database installation, find out JDBC connection information to connect DBHawk using JDBC

    Azure SQL

    SQL Azure JDBC

  6. Login to DBHawk admin screen and go to Manage Connections Tab. Add a new connection for MS Azure SQL connection.

    SQL Azure Connection Setup

  7. After DBHawk connection setup, you should be able to login MS Azure SQL database using DBHawk with username and password.

    SQL Azure

top