1. Introduction

This document provides detailed instructions and guidelines for integrating client own database with Legistify Litigation Management and Contract Management tool. The integration process involves connecting a relational database management system (RDBMS) to the application, ensuring seamless data flow, and optimizing performance.

2. Scope

The database integration includes:

Establishing a database connection
Database Connection setup
Schema Design
Conclusion

3. Prerequisites

Before beginning the integration process, ensure the following:

Installation of PostgreSQL/MongoDB required as per recommendation in the documentation of product feature and deployment documentation.
Required whitelisting of application endpoint / IP / Host on the database end for any outgoing request.
The database has access to application (in Legistify Cloud ) via VPN / Firewall ( If Any ) over the internet.
Any required database management tools (e.g pgAdmin, etc.) are available for database management. (This should be at Clients Premise / Cloud).

4. Database Connection Setup

4.1. Connection Configuration

To connect your application to the database, a database connection string is required. The connection string typically contains the following components:

Host: Database server address (e.g., localhost, IP address, or domain name).
Port: Port number the database listens on (e.g. 5432 for PostgreSQL).
Database Name: Name of the specific database to connect to.
User Credentials: Username and password to authenticate the connection.
Additional Options: Options such as SSL mode, connection timeout, etc.

PostgreSQL (JDBC):

jdbc:postgresql://localhost:5432/mydatabase?user=myuser&password=mypassword

4.2. Connection Pooling

For production environments, consider using connection pooling to manage database connections efficiently. Connection pools help minimize the overhead of creating and closing database connections for each query.

Examples: