You can connect without setting any connection properties for your user credentials. OAuth requires the authenticating user to interact with Azure Analysis Services using the browser. Optionally, set Database to distinguish which Azure database on the server to connect to.Īzure Analysis Services uses the OAuth authentication standard. To connect to Azure Analysis Services, set the Url property to a valid server, for instance, asazure:///server, in addition to authenticating. The JDBC URL begins with jdbc:aas: 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 Analysis Services using wizards in RazorSQL.Ĭreate a JDBC Data Source for Azure Analysis Services Data The CData JDBC Driver for Azure Analysis Services enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools.

Connect razorsql to my azure database