I am trying to change the schema in a JDBC Adapter service automatically.
I have used the wm.art.metadata.setServiceSignatureProperties service to accomplish this. My problem is using this, I am able to change the schema but it reverts back if the package is reloaded or IS is restarted.
How can I make the change permanent. What am I missing. Also, is there any other way to automate the schema change? DEV, QA and PROD have different schema and I am trying to prevent manual change and thus restricting developer access in Prod.