Tools to interact with Bridge for Git Derby database

Products

• Endevor

Issue/Introduction

Any tool that can be used to interact with Endevor Bridge for Git Derby database (run SQL queries) ?   

Environment

Endevor V19

Endevor Bridge for Git

Resolution

Apache Derby ij and IntelliJ IDEA built-in database management tools can be used to interact with Derby database. 

However, Derby database was never intended for production use:

• The above tools can't connect to live database - needs to shutdown bridge for git application first. 
• Can't use the above tools to perform regular database backup.

 

Configure Bridge for Git application with an external database (such as PostgreSQL) is highly recommended. 

A database that is separate from Endevor Bridge for Git provides the following benefits:

• Improved data protection
  • Enable extra layers of access and security to the information and code that is managed by Bridge for Git
• Backup management
  • Easy configuration and scheduling of backups for the information that is stored in the database
• Enhanced performance
  • Enhance efficiency and data throughput
• High availability support
  • A separate database, which is coupled with clustering of Bridge for Git servers, ensures constant access
• Clustering
  • Option to cluster Bridge for Git servers

 

 

 

 

Additional Information

Check out Configure Bridge for Git for an External Database for more information.