![]() In the Select Database Driver screen, select the driver corresponding to the Exasol JDBC Driver you added in the Add the JDBC Driver step and click Next. Enter a name for the connection in the New connection Wizard(for example, Exasol) and click Next.Open DbVisualizer and select Tools > Connection Wizard.The Driver Class field is automatically filled when you select the correct driver.ĭo the following to connect to your Exasol database from DbVisualizer:.Make sure you choose the exajdbc.jar file. In other systems, navigate to the folder that contains the JDBC driver. ![]() On a Windows system, you will find the jar files at C:\Program Files\Exasol\EXASolution-7.1\JDBC. Click the folder icon in the below section of the screen and locate the JDBC driver file exajdbc.jar for the driver.It is automatically set in the next step. To add a new driver, click the icon in the toolbar.Įnter the following details on the Driver Settings screen:.In the top navigation, select Tools > Driver Manager.Do the following to add the JDBC Driver to DbVisualizer: You only need to perform these steps once per DbVisualizer installation. You will need this information to connect to your database.Ĭonnecting to a SaaS database is only possible using the Exasol 7.1 JDBC driver or later, which must be added to DbVisualizer manually. You can generate a new Personal Access Token by clicking Generate. Copy the HOST, PORT, USERNAME, and PASSWORD.Click Next and proceed through the wizard until you see your connection details:.If not already installed, download the latest JDBC driver for your operating system and install it.If the IP address was already added, just click Next. In the Connect to cluster wizard, enter the IP address of the client or server which will connect to the database and click Add IP.Click on the cluster you want to connect to and then click Connect via tools.Click Databases in the web console to open the Databases page.Follow these steps to get your connection details: If you have installed the JDBC 7.1 or later driver, you have the correct driver.īefore you can proceed with connecting to your database from a tool, download the latest Exasol JDBC driver and get the connection details. Download the latest Exasol driver and set DbVisualizer to use that driver.Your local IP should be listed in the allowed IP list (see Network Security for more information).A running Exasol SaaS database (see Manage Databases and Clusters for more information).The following environment is used as an example: To know more about the benefits of the Pro version, see Exasol Specific Features. DbVisualizer Pro is the recommended SQL client by Exasol. ![]() To sum it all up, if you need a robust and comprehensive database management and administration solution, you should really give DbVisualizer a try.This section describes how to connect DbVisualizer to Exasol and run an SQL statement. In addition, DbVisualizer comes with a powerful command line interface created to help developers execute DbVisualizer SQL scripts without having to run its GUI.įurthermore, DbVisualizer’s DBA extended features make it possible to manage a large variety of database instances, as well as security and storage parameters within the database server. Powerful and full-featured database manager with a built-in SQL editorĭbVisualizer also bundles an integrated SQL editor designed to offer extended support for exporting large result sets, parameterized SQLs, auto completion, visual query builder, and a full-featured SQL formatter. One can also quickly edit and compile support for more functions, packages procedures, and triggers with the help of DbVisualizer's extensive set of built-in development tools. Thus, with the help of the DbVisualizer application you will be able to edit a wide array of table data, from binary/BLOB to CLOB data types, either by loading it from your other databases or by importing it from data files. Moreover, DbVisualizer will also provide its users with the tools needed to effortlessly alter, create, and modify database objects such as tables. Vast selection of database manipulation tools The DbVisualizer solution comes with extended support for a large number of databases including MySQL, PostgreSQL, Oracle, Cloudscape, Sybase, SQL Server, DB2, McKoi, Mimer, SAP DB, Informix and InstantDB. You can also swiftly execute a variety of SQL statements and saved between your sessions. To start using DbVisualizer on your Mac, all you have to do is to point and click to effortlessly browse your database's structure, characteristics of tables, and more. DbVisualizer has been designed from the ground up to help its one use multiple simultaneous connections to many different databases, with the help of JDBC drivers.
0 Comments
Leave a Reply. |