Is is possible to set dynamically the parameters of the JDBC URL string of the Data Server?

For example:

• Select in runtime which database to connect to.
• Deploy the Data Servers from to a different environment and the JDBC URL will point to the database of the running environment.

------------------------------
Alex Santamarta
------------------------------

#CognosAnalyticswithWatson

I would love to know this too.  We're only just testing / fixing converting over to DQM but the end of each month I refresh Dev from Prod and now with DQM & JDBC I will have 30 Datasource Connections to have to manually update.  I'd planned on finding where that's stored in the content store and then just using SQL to change them, but if there's a better, more "official" way that'd be great!

------------------------------
Wayne Westlake
------------------------------

I don't know the data servers but in the "data sources" (adminstration console) you can insert multiple "data source connections". If you use such a data source (e.g. in a FM package), then you will be forced to select a data source connection when use execute a corresponding report or dashboard.

------------------------------
Philipp Hornung
------------------------------

Original Message:
Sent: Wed June 23, 2021 01:24 PM
From: Wayne Westlake
Subject: Data Server dynamic JDBC URL

I would love to know this too.  We're only just testing / fixing converting over to DQM but the end of each month I refresh Dev from Prod and now with DQM & JDBC I will have 30 Datasource Connections to have to manually update.  I'd planned on finding where that's stored in the content store and then just using SQL to change them, but if there's a better, more "official" way that'd be great!

------------------------------
Wayne Westlake
------------------------------