This post is continuing my previous port about modifying SQLDeveloper preferences with ansible. Building on the same motivation and technique my goal in thist post is to centrally push out and keep updated connection details for SQLDeveloper on client side.

First lets declare the connections we want to push out:

NB! I’m pushing out connections referring to TNS names, since I want to add some extra RAC related settings to each connection description.

First need to create connection.yml that will contain tasks to add a single connection to SQL Developer. This file will be called for every connection from the main playbook.

Now the main playbook.

NB! This is just an extract from the playbook. I expect you are familiar with ansible and know how to put all these three files together 🙂