I would like to get details of SAP and JDBC adapter connection properties
For example: I have 10 SAP adapter connections and I would like to get values of below properties for all the 10 SAP adapter connections and insert it into a file
Properties are:
User Name
Client
Load Balancing
Application Server
System Number
Logon Group
Message Server
System ID
Any help is appreciated
Use wm.art.admin.connection:getResourceConfiguration in invoke service.
Hi Mahesh
Thank you for the reply.
I cannot see wm.art.admin…
Can you point me to a resource from where i can download it.
My Software AG Designer is 9.0 and Integration Server is 8.2
I have attached a screenshot of WmArt package
thanks
I was pretty sure that you will ask me this question but anyways the answer is :
wm.art.admin.connection:getResourceConfiguration you cannot list or view this service in package navigator due to ListACL
A trick will do:
Create a empty flow service and select invoke/insert from your developer/designer and you will get a window popped out just paste the service name wm.art.admin.connection:getResourceConfiguration and click OK, you will see this service in your editor. Pass the required input I mean the connectionAliasName
I hope it is clear to you now, if not get back to me with questions. Good luck and good night
Just some Pseudo-Code.
pub.art:listRegisteredAdapters
loop over result-list
pub.art.connection:listAdapterConnections (for each registered Adapter, when you are only interested in one specific Adapter you can start here.)
loop over the result-list
wm.art.admin.connection:getResourceConfiguration (for each Connection)
Regards,
Holger
Exactly Holger. I am going to store all the responses in a list and dump it in the spreadsheet or csv file at the end
thanks
m@ndar