premkug123
asked on
Scripting to automate Websphere Datasource configuration
DataSource-Configuration-Automation-Scri Hi Experts,
I am trying to write a script to do the automation for Resources Configuration in WebSphere Application Server (8.0).
I am starting with JDBC Resource configuration. I am asked to have,
1) A Shell script which has high level logic, and it needs to take parameters like "New" or "Update" and according to that, it reads the data from a properties file and then executes a python script.
2) A Properties file - Which has all the information like Cluster name,Node name,scope,Alias name,User ID,Password,Connection pool settings etc..
3) A Python script - which has all the wsadmin functions to create or update JDBC resources.
I have attached a simple flow diagram. Please look at it.
Please help me to create this automation scripts. Any help would be greatly appreciated. Please let me know if you have questions.
I am trying to write a script to do the automation for Resources Configuration in WebSphere Application Server (8.0).
I am starting with JDBC Resource configuration. I am asked to have,
1) A Shell script which has high level logic, and it needs to take parameters like "New" or "Update" and according to that, it reads the data from a properties file and then executes a python script.
2) A Properties file - Which has all the information like Cluster name,Node name,scope,Alias name,User ID,Password,Connection pool settings etc..
3) A Python script - which has all the wsadmin functions to create or update JDBC resources.
I have attached a simple flow diagram. Please look at it.
Please help me to create this automation scripts. Any help would be greatly appreciated. Please let me know if you have questions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Phil,Thanks AdminRAM for your solution. I could able to complete the script.
http://www-01.ibm.com/support/knowledgecenter/api/content/nl/en-us/SSEQTJ_8.5.5/com.ibm.websphere.base.doc/ae/txml_7libresource.html
Creating, modifying, and deleting configuration objects using one properties file and wsadmin scripting
https://www-01.ibm.com/support/knowledgecenter/api/content/nl/en-us/SSEQTP_8.5.5/com.ibm.websphere.zseries.doc/ae/txml_prop_crud.html
example
Working with data source properties files
http://www-01.ibm.com/support/knowledgecenter/api/content/nl/en-us/SSAW57_8.5.5/com.ibm.websphere.nd.doc/ae/txml_config_prop_jdbcprovider_ds.html