Forum Discussion

RickCole's avatar
RickCole
Data Storage
01-12-2024

Changing MySQL Connection String across all data models

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!

Cloud Managed Services
Data Connectors
Elasticube

1 Reply

Replies have been turned off for this discussion
  • david-h's avatar
    david-h
    Cloud Apps
    01-12-2024

    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.