Showing results for 
Search instead for 
Did you mean: 

Changing MySQL Connection String across all data models

7 - Data Storage
7 - Data Storage

My company is upgrading our MySQL version from 5.7 to 8.x.
As such, it seems we must change the connection string in all our data connectors referencing the MySQL environment.
Is there away of accomplishing this one-shot / globally rather than going into each individual ElastiCube / relevant data table and changing it piecemeal?

(Most of our data models are ElastiCubes.)

Many thanks!


9 - Travel Pro
9 - Travel Pro

Hi Rick,

Did you look at CLI command or API ? It will allow you to update all elasticube datasources in scripts, so that you won't have to modify them manually. Alternatively you can use ti or modify them manually one last time to use the new connection management feature.

Best, David.