Leave the User name and Password fields empty and proceed through the Next dialogs and finally Finish. This operation automatically fills the field JDBC URL as it was previously defined in field URL Template of the driver settings dialog. In the Generic JDBC Connection Settings dialog press button Edit Driver Settings and then press OK on the dialog that pops up. Then press button Next and select the extremedb driver from the list of connection types. Select the DBeaver menu File -> New and choose DBeaver -> Database Connection in the wizard selection dialog. Drivers are usually downloaded from web site. It will be used for drivers download only. You can enter a proxy host/port and (optionally) user/password here. Then go to Preferences->Connections->Drivers. To create a Microsoft Driver connection in DBeaver. How to configure a proxy for drivers download You need to ask your network administrator about proxy parameters. Now press OK to save the newly created driver.Ĭreating a DBeaver DB connection based on the eXtremeSQL JDBC driver Therefore, if youre using the Oracle JDBC Thin driver, perform the equivalent of SQLNet. Here enable parameter Driver supports indexes and disable parameter Driver supports references. Then fill in the field URL Template with a string like the following jdbc:extremedb:localhost:5001 where jdbc:extremedb is the identifier of the eX tremeSQL JDBC driver, localhost and 5001 are the address and port of eX tremeSQL server ( xSQL).įinally go to the tab labeled Adv. This class name will be automatically put to field Class Name of the Edit Driver dialog. The next step is to press button Find Class and select from the drop down list Driver class (the only available class). It is usually placed in the target/bin directory with a path like eXtremeDB\target\bin\extremedb_jdbc.jar'. Then press button Add File and choose the eX tremeSQL JDBC driver. A dialog like the Edit Driver image below will appear. Start DBeaver and open a dialog from menu Database -> Driver Manager and press button New. Other useful materials include official documentation, an article on writing templates and instructions on data export / import procedures for DBeaver (further discussed below) Registering the eX tremeSQL JDBC driver in DBeaver Connecting using Avatica JDBC driver Select Datasets Click on a dataset youd like to query Copy JDBC server host and port from the Interfaces tab JDBC. See usage instructions for helpful informationĥ. Register the JDBC driver in DBeaver (see instructions below)Ĥ. Use xSQL as eX tremeSQL server or integrate the eX tremeSQL Remote SQL server into the applicationģ. In summary, the steps to install and use DBeaver are:ġ.ĝownload and install the proper version of the DBeaver DB managerĢ. To use DBeaver as a GUI front-end to eX tremeDB databases, the only necessary component of the eX tremeSQL package is its JDBC driver. ToC path: eX tremeSQL Support for DBeaver
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |