To obtain these values, navigate to the Storage Accounts blade in the Azure portal. Either the Primary or Secondary Access Keys can be used. Set the Account property to the Storage Account Name and set AccessKey to one of the Access Keys.

Specify your AccessKey and your Account to connect. The JDBC URL begins with jdbc:azuretables: and is followed by a semicolon-separated list of connection properties. (This property can also be set in the JDBC URL.)

Driver Class: Set the driver class to.

Driver Location: Set this property to the path to the lib subfolder in the installation directory.

In the Connection Wizard that appears, set the following properties:.

Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.

This article shows how to connect to Azure Table using wizards in RazorSQL.Ĭreate a JDBC Data Source for Azure Table Data The CData JDBC Driver for Azure Table enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools.

Connect razorsql to my azure database