RMP Global variables

[ezz...@gmail.com]

Hello,

I am wondering how to set global variables in RMP. I am using SEC (Security Enterprise Connector) and JDBC to launch queries to our local database. The connector POST content looks like the JDBC standard:

{
"protocol":"JDBC",
"data":{
"DBType":"OURDATABASE",
"sqlUsername":"our_db_user_name",
"sqlPassword":"our_db_password",
"sqlStatement":"INSERT INTO exampletable (examplecolumn1, examplecolumn2) VALUES ${values_variable_from_web_interface};"
}
}

The point is we have to write the db_user_name and db_password in every connector, because I can't find any global variable resources in RunMyProcess. The connectors quantity is growing, and if our database administrator change the password (and it is going to happen), we will be forced to change every connector password.

There is a way to define a global RunMyProcess variable for our Account, in order to be used in this case?

Thank you

[Pankaj Kumar]

Hi,

To define and get a variable on project level, You can use the "Project Vault" to save and get the variable "db_user_name " and "db_password".

Please find the method details as follows:-

1. P_save_project_vault(vault) → {object}
2. P_delete_project_vault() 
3. P_load_project_vault()

You can save it once those details and retrieve many times when required in same project.

To Save:-

${P_save_project_vault({"db_user_name":"#####","db_password":"######"})}

To Retrieve db_user_name:-

${P_load_project_vault().db_user_name}

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/fb867b64-935c-477e-83e8-28a8776bca77%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[ezz...@gmail.com]

Thank you, I don't know about Project vault. But the point is to set a Global Variable accesible to all our projects. Is there a way to define this kind of variable in RunMyProcess? If not, i think it would be interesting to be included in future updates.

Thank you

[gaston...@gigas.com]

I repeat, Is there a way to define a Global RunMyProcess Variable for our Account? (Not with process scope but account scope)

Thank you

[Pankaj Kumar]

Hi,

No direct feature is provided by RunMyProcess to define a variable on Account Scope. We can suggest you alternate approach to achieve the same.

Please create a new project and create a collection in it and save the values in that collection. You can import this project in multiple project and access the values i.e. "db_user_name" from it. This way, if there is any change is required in "db_user_name", you need to change it only in collection.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

On Wed, Dec 9, 2015 at 2:29 PM, <gaston...@gigas.com> wrote:

I repeat, Is there a way to define a Global RunMyProcess Variable for our Account? (Not with process scope but account scope)

Thank you

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/24f38bf2-833a-4dcb-8768-2e76dae9cbdd%40runmyprocess.com.

[ezz...@gmail.com]

Thank you, the collection aproach have solved my problem. :)