Different database connections on staging server vs production server | Product Feedback Forum

mba · 2025-02-24T16:53:32.962000Z

Hi,We have two cloud servers in Sisense: one for development (staging) and one for production.The staging server connects to our staging database.The production server connects to our production database.All cubes and dashboards are identical except for database connection strings and names.Our Git branching strategy follows these steps:Create a feature branch from staging.Make changes and push them to the feature branch.Open a pull request from the feature branch to staging.Test changes in staging.If approved, merge staging into master (production) to deploy changes.The IssueGit integration tracks database connection names, meaning both servers must either run on staging data or production data—this is not feasible for us.Proposed SolutionWe suggest implementing a decentralized environmental variable for storing database connections. For example:Use {database-server-name} as a placeholder in configurations.Set database-server-name = db_server_staging on staging.Set database-server-name = db_server_production on production.This would allow the same codebase to dynamically connect to the appropriate database without manual adjustments.Would love to hear your thoughts on this!

MoreDiscussions

Different database connections on staging server vs production server | Product Feedback Forum | Sisense Community