DBeaver

Installation

Open

No special configuration need to be done during the installation.

Oracle Configuration

1. Click on connect to a database and choose Oracle

   Open

   

    

2. Select TNS tab > choose your network alias > add Username and Password > click Finish

Azure Configuration

1. Click on connect to a database and choose Postgres

    

2. If the driver is not installed in your machine, you click on Download and the driver will be installed automatically.

    

3. Add you connection > Finish

Git Connection

1. Select "Help" and then select "Install New Software"

   Note: To install this plugin, you cannot be connected to the VPN.

    

    

2. Type git and select the option DBeaver Git Integration

    

3. Select DBeaver Git Support > Next > Next

    

4. Accept the licenses > Finish

    

5. Accept the certificates

    

6. Restart Now

    

   Note: After installer the plugin, DBeaver can crash loop on startup, you need delete the folder located in %USERPROFILE%.eclipse and delete all folders with dbeaver.product. In my case, 2 folders.
   After that, you need to reinstall the plugin again, please pay attention because to do this installation you cannot be connected to the VPN.

    

7. Once DBeaver restarted, go to File > Git > Git Repositories

    

8. Select Clone a Git Repository

9. Add URI information > Next

   URI: https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CivAv_Database

    

10. Add User and Password from DevOps

     

     

    1. Open Azure DevOps > go to Repos > CivAv_Database > Clone

        

    2. Click on Generate Git Credentials

    3. Copy and paste the user and password in DBeaver and click on Log in

        

11. Select the branch > Next

12. Select your directory > Finish

     

13. Select Projects Tab and click on Create project from Git

    Note: https://dbeaver.com/docs/wiki/Project-team-work/

     

     

14. Select the option Existing local repository > Next

     

15. Select your project cloned > Next

16. Next

17. Add the project name > Finish

     

18. You can select your file and open it

     

19. Once you finish your changes, right click in your file > Team > Commit. The git staging will be open and you can commit and push your changes.

     

Comments from TC - Dev Community of Practice

Bryen Begg: SQL Developer has alot of good features but alot of quirks. I have bee… 

posted in Solutions Centre / Centre des solutions / Dev Community of Practice at Thursday, September 12, 2019 7:33:24 AM

Hoban, Walter: As far as I know we can use TOAD id you have licence for it, that is … 

posted in Solutions Centre / Centre des solutions / Dev Community of Practice at Thursday, August 12, 2021 2:29:12 PM