For the purposes of this guide, we'll use the Community Edition of DBeaver to retrieve data from MongoDB via the Open Database Connectivity driver.Ĭreating an ODBC Data Source to Use MongoDB Data in DBeaver Note though that you can access a MongoDB database from DBeaver Community Edition using the respective Devart ODBC driver. Enterprise Edition supports NoSQL databases, such as MongoDB or Cassandra, persistent query manager database, SSH tunneling, vector graphics (SVG) and a few other enterprise-level features. The tool comes in two editions - Community and Enterprise. Devart DBeaver provides you with the most important features you'd need when working with a database in a GUI tool, such as:
![dbeaver nosql dbeaver nosql](https://i.stack.imgur.com/AOgX3.png)
DBeaver can be used to access any database or cloud application that has an ODBC or JDBC driver, such as Oracle, SQL Server, MySQl, Salesforce, or Mailchimp.
#DBEAVER NOSQL DOWNLOAD#
Once download is complete, click “OK”, then return to the main DBeaver window and continue with step 7 above.DBeaver is a free, open source multiplatform database management tool and SQL client for developers and database administrators.
#DBEAVER NOSQL DRIVER#
If you do not see the DuckDB driver, first click on “Reset to Defaults”.Ĭlick “Download” to download DuckDB’s JDBC driver from Maven.
![dbeaver nosql dbeaver nosql](https://cdn-images-1.medium.com/max/800/1*xSwHtmDQ72F-3vAdrzcn1w.png)
Go to the “Libraries” tab, then click on the DuckDB driver and click “Download/Update”. (Alternate) You may also access the driver settings menu by returning to the main DBeaver window and clicking Database > Driver Manager in the menu bar.
#DBEAVER NOSQL INSTALL#
If not prompted to install the DuckDB driver when testing your connection, return to the “Connect to a database” dialog and click “Edit Driver Settings”.
![dbeaver nosql dbeaver nosql](https://dbeaver.com/wp-content/uploads/2020/03/MongoDB-1024x641.png)
Write some SQL and click the “Execute” button. Right click on that connection and create a new SQL script. Expand it to see the tables and views in your database. You should now see a database connection to your DuckDB database in the left hand “Database Navigator” pane. Note: If you are in a corporate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings.Once download is complete, click “OK”, then click “Finish”. Click “Download” to download DuckDB’s JDBC driver from Maven.If you are not prompted, see alternative driver installation instructions below. This will then prompt you to install the DuckDB JDBC driver. To use an in-memory DuckDB (useful primarily if just interested in querying parquet files, or for testing) enter “:memory:” as the path.Ĭlick “Test Connection”. Search for DuckDB, select it, and click Next.Įnter the path or browse to the DuckDB database file you wish to query. Either click on the “New Database Connector” button or go to Database > New Database Connection in the menu bar. Open DBeaver and create a new connection. Install DBeaver using the download links and instructions found at their download page.
![dbeaver nosql dbeaver nosql](https://upanh.vn-z.vn/images/2020/06/20/test-dbeaver.png)
DuckDB’s JDBC connector allows DBeaver to query DuckDB files, and by extension, any other files that DuckDB can access ( like parquet files). It is useful for visually inspecting the available tables in DuckDB and for quickly building complex queries. It has both an open source and enterprise version. DBeaver is a powerful and popular desktop sql editor and integrated development environment (IDE).