Database Setup
PackCPQ maintains zero data synchronization with external SaaS networks. All cost structures, customer records, and calculation histories reside within your local database node. The engine supports **PostgreSQL 14+** and **Microsoft SQL Server 2019+** instances.
1. Environment Configuration
Configure your database connection parameters inside your docker environment configuration file (.env):
DB_TYPE=postgresql
DB_HOST=10.0.4.15
DB_PORT=5432
DB_NAME=packcpq_production
DB_USER=cpq_calculator
DB_PASSWORD=your_secure_vault_password_here
DB_SSL_MODE=require
DB_POOL_MAX=202. Initial Schemas Execution
On initial startup, the container engine executes migration scripts to construct the core parameters tables. Ensure your configured database user holds CREATE and INDEX privileges.
Detailed relational foreign keys schemas, indices mappings, and security database hardening guidelines are restricted to active enterprise license holders. See your administrative package dashboard to download the complete schema documentation.
3. Connection Diagnostics
Verify network routes by running diagnostics within the container sandbox:
$ docker exec -it packcpq-core-1 /app/packcpq-engine --test-db