Scripted Configuration

Created May 08, 2017 18:35

Hi,

I need to update about 20 data sources every month with a new password, sometimes adding and removing them too.

I had a brief look around the ~/.DataGrip* folder and couldn't see anything obvious.

Is there any way I could script these changes?

Thanks,

Mark

1 comment

Created May 20, 2017 20:15

Hi,

There are two ways.

1. Project settings are stored in
%USER%\.DataGrip2017.1\config\projects\%PROJECT_NAME%\.idea

Password are stored in Keychain or etc.

2. Define data sources in your project with URL mode and write password directly in your jdbc url:

E.g. for MySQL:

jdbc:mysql://localhost:33055/guest?user=guest&password=guest

Then you need to store your project configuration using "Database Tools -> Copy settings" action:

Then you need to copy settings from buffer to any file and edit settings and recreate project with new settings.

Thank you.

Please sign in to leave a comment.