Select the Database Connection, Database, and Schema from the available menus. To execute SQL queries, select SQL Commander > New SQL Commander.To browse through table data and metadata, right-click a table and click Open in New Tab.To access the available tables, from the Databases tab, expand the nodes for the connection, database, schema, and table or view.You can then browse data and execute SQL in the following ways: In the main DbVisualizer window, click Connect on the Connection tab for the newly created connection. Note: After you successfully create a database connection for SQL Server Analysis Services you should set the "Database Type" property to "Generic".ĭiscover Schemas and Query SQL Server Analysis Services Data Database Password: Enter the password for authentication to SQL Server Analysis Services, if needed.Database UserId: Enter the username for authentication to SQL Server Analysis Services, if needed.The syntax of the JDBC URL is jdbc:ssas: followed by the connection properties in a semicolon-separated list of name-value pairs.Ī typical connection string is below: jdbc:ssas:User=myuseraccount Password=mypassword URL= Database URL: Enter the full JDBC URL.See Establishing a Connection for a guide. In the following fields, enter the JDBC URL and provide authentication.
In the main DbVisualizer window, select Tools > Connection Wizard.
This section shows how to establish a connection to data in DbVisualizer, use the table editor to edit and save data, and execute SQL.Īdd the JDBC Driver for SQL Server Analysis ServicesĬomplete the following steps to add the driver.