| Author |
Message
|
| WakeUpSid |
 Posted: Tue Jun 22, 2010 7:25 am Post subject: Configurable Service |
 |
|
Novice
Joined: 22 Jun 2010
Posts: 10
|
Is it possible to read a configurable service from ESQL? We have need to pass credentials in the process of invoking a service from an external system.
Would like to leverage configurable service to be abstract from the code.
Any suggestions ?
--
Sid |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Jun 22, 2010 7:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Please be much more specific about what particular kind of external system you are accessing and how you expect to access it from ESQL.
There is no ESQL statement that will let you do the equivalent function of mqsireportproperties. |
|
| Back to top |
|
|
| WakeUpSid |
| Posted: Tue Jun 22, 2010 7:57 am Post subject: |
|
|
Novice
Joined: 22 Jun 2010
Posts: 10
|
We have to invoke a web service (REST based) to an external partner and need to include the user/pwd in the payload.
We have come up with options to avoid to hard code in ESQL. (file system, db, JAVA app etc.,) and we came across the configurable service.
The question is can we leverage configurable service to create an alias or some, similar to db DNS and use it in our ESQL.
--
Sid |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jun 22, 2010 8:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I suspect someone who knows a lot more about calling REST services from Broker will be along shortly.
I would use a User Defined Property for this, myself. |
|
| Back to top |
|
|
| n1ghtrain |
| Posted: Wed Jun 23, 2010 2:40 am Post subject: |
|
|
Apprentice
Joined: 23 Mar 2006
Posts: 48
Location: Bangalore
|
I faced a similar issue while making Basic HTTP authentication on HTTP Request (REST Based). Wanted to avoid hardcoding the password in esql.
User Defined Properties were not really helpful, as I don't want to redeploy each time passwords change in LDAP. So went with storing the password in an encrypted field in database and caching the value in Broker. (Wish if i can use a custom template for Configurable Service or something like mqsisetdbparms and use it in Code). Also thinking of TFIM as an option to do the identity mapping. Any suggestions/ experiences.? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jun 23, 2010 3:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You don't need to redeploy to change a UDP, in 6.1 and 7. You can update the values using CMP based admin tooling and then restart the EG. |
|
| Back to top |
|
|
| n1ghtrain |
| Posted: Wed Jun 23, 2010 5:57 am Post subject: |
|
|
Apprentice
Joined: 23 Mar 2006
Posts: 48
Location: Bangalore
|
This is perfect.. tried it from MB Explorer , worked even without exec. group restart.. Thanks for the tip mqjeff
(Next stop: security guy's desk to convince him that there is no harm in putting password as clear text  ) |
|
| Back to top |
|
|
|
|
