Changing MySQL Connection String across all data models

[RickCole]

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!

[david-h]

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.