Introduction to DBeaver and how to connect to Oracle

Tram Ho

DBeaver is a database management software that supports JDBC driver
DBeaver is very intuitive and easy to use to connect to many different databases , run queries, create ERDs.
DBeaver supports databases such as Oracle, MySQL, IBM DB2, SQL Server, PostgreSQL, Java DB, …
You can download it at dbeaver.io/download/ which is available for free on Windows, Mac OS X, and Linux operating systems.

Some of the benefits and features of this app:

  • SQL statement / execute script
  • Autofill and hyperlinks metadata in SQL editor.
  • The result set is scrollable
  • Export data (tables, query results)
  • Search for database objects (tables, columns, constraints, procedures)
  • DBeaver consumes much less memory than other popular programs (SQuirreL, DBVisualizer)
  • All remote database operations work in unlock mode, so DBeaver does not crash if the database server becomes unresponsive or has a related network problem

How to connect Oracle with DBeaver

After downloading, let’s start the installation process, it’s quite simple!
When the installation is completed and the application is started, the screen will appear as follows:

Click on the icon above to connect to the sample database, you will see the table below appear
Then, Click Oracle -> Finish and continue

Next you will see a screen like this:

You enter enough information in the fields circled in red, respectively: IP address, DB name, Username, Password of the sample database you want to connect to.
Next, don’t click Finish yet, but click the Test Conection button on the left to check if the information is correct.
If there is an error, you should try to check the name of the DB to see if it is correct!

When the pop-up display as above is correct, now you just need to click Finish
The screen shown below means that you have successfully connected DB_TEST!

Tips for using DBeaver when connecting to DB Production

Maybe we rarely use the DB of the Production environment
But there are also many projects that need to use DB of this environment for testing or investigating Bugs
Imagine, what if we accidentally delete or correct some data of this DB ???
To avoid this error, after connecting the DB, you do one more simple step of authorization:

First, Right click on the DB you just connected, choose Edit Connection
A new window appears -> Select General
Under Security , you Click on Read-only connection (Only allow read data)
Click OK to confirm the changes. So you can confidently use DB without fear of making mistakes!

Share the news now

Source : Viblo