I have created a SQL Query with command mode for inserting data in database. But I would like to change the database credentials of this SQL Query dynamically. How can I do this? I have seen one property of this action block as Connector. What is format of the value it expects. Can any one help me on this?
Thanks for your response. Apart from Username and password I would like to change the URL of SQL Query action block dynamically. I see a propery as Connector for this action block. I want to know in which format I am suppose to provide the value for this property.
I'm not sure if the requirement can be achieved using MII. Moreover I don't think that field will help you as that is meant to specify the driver/connector of that query. In this case, it will be IDBC. You can check out this in data services->data servers -> summary .
Can you please specify exactly what you're trying to do?
You mention credentials in your subject line and earlier post, which to me would indicate that you might want your query activity to be done on behalf of the logged in user? This was an option in 11.5 (no idea how often it was used, or what 12.0/12.1 do since the documentation is void of the setting) http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/IDBCConnector.htm#Capabilities
You would have to formulate an /XMII/Illuminator?QueryTemplate=xxx/yyyy type query to include these properties, since they are not applet or template parameters they won't show up in the link editor.
The User / Pwd properties you see are not for this - they are leftovers from older versions for authenticating applets.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.