This topic provides the systematic instructions to add the SQL/CL related scripts for Foundation setup.

1. Add the sqlcl deployer jar in the

   /scratch/obma_patch_installer/softwares/sqlcl/ .

2. Add plato-security-toolkit and plato-security-salt-encryption-toolkit in the

   /scratch/obma_patch_installer/softwares/security_toolkit .

3. Verify that required (product)-db.zip files are in the

   /scratch/obma_patch_installer/deployables/apps/(product)

4. Verify that releaseCatalog.json and placeholder.properties files have been downloaded in

   /scratch/obma_patch_installer/deployables/sqlcl/properties/ .

   If both sync and incremental run is required for the same service, same needs to be added to releaseCatalog.json.

5. Verify sqlcl_salt.json has been downloaded in the

   scratch/obma_patch_installer/chef-repo/data_bags/obma_sqlcl_salt .

6. Verify the required databag is present in

   scratch/obma_patch_installer/chef-repo/data_bags/ .