Robotic Process Automation (RPA)

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER
------------------------------

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

Hi Nigel,

Thank you for your quick prompt.
The issue was in the Tenant Credential configuration.
Now the Tenant Credential is configured with proper keys pair and the ODBC Connection works well.

Best regards,
Stanislav

------------------------------
Stanislav Terziev
------------------------------

Original Message:
Sent: Fri April 08, 2022 05:00 AM
From: NIGEL CROWTHER
Subject: Database connection string and System Vault

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

How did you configure Tenant Credential? Did you install openssl for keys pair? I am not familiar with this, so I want learn. Please help me.

------------------------------
YASEMİN ALADI
------------------------------

Original Message:
Sent: Fri April 08, 2022 05:52 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Nigel,

Thank you for your quick prompt.
The issue was in the Tenant Credential configuration.
Now the Tenant Credential is configured with proper keys pair and the ODBC Connection works well.

Best regards,
Stanislav

------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:00 AM
From: NIGEL CROWTHER
Subject: Database connection string and System Vault

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

Hi Yasemin,

I configured the Tenant Credential for the on-prem installation.

First, you need to create the private and public keys pair.
For this, I used OpenSSL on a Windows machine.
Here is the download link: http://gnuwin32.sourceforge.net/packages/openssl.htm
Download the Binaries in zip format.
More about the creation of the pair may see on this video: https://www.youtube.com/watch?v=iHb3nFtzFoc.
There are all needed commands to create a public and private key in "pem" format.

After the creation of the privatekey.pem and publickey.pem you need to log in the RPA control center and select:
Administer Tenants -> Tenant Configuration -> Credentials

in a Public Key field upload your created publickey.pem file from your Windows machine.
in a Private Key -> File Type select Pem
in a File Path type full path where is your created privatekey.pem on your Windows machine (for Example: C:\TenantKeys\privatekey.pem).
and Save Configuration.

After that you need to creat Credentials -> New Credentilas and type:
Name: some Credential Name
Username: some UserName
Password: password for the Username.

When you use getvault you should type Credential Name in the key parameter.

NOTE: The privitekey.pem file should be copied on all PCs where you run bots on the same PATH typed in the File Path field.

That it is.
I hope this will help you.

Best regards,


------------------------------
Stanislav Terziev
------------------------------

Original Message:
Sent: Fri April 08, 2022 05:55 AM
From: YASEMİN ALADI
Subject: Database connection string and System Vault

How did you configure Tenant Credential? Did you install openssl for keys pair? I am not familiar with this, so I want learn. Please help me.

------------------------------
YASEMİN ALADI

Original Message:
Sent: Fri April 08, 2022 05:52 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Nigel,

Thank you for your quick prompt.
The issue was in the Tenant Credential configuration.
Now the Tenant Credential is configured with proper keys pair and the ODBC Connection works well.

Best regards,
Stanislav

------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:00 AM
From: NIGEL CROWTHER
Subject: Database connection string and System Vault

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

Thanks for detailed answer. But I have a question. In tenant configuration window, file type for private key combobox is empty. How can I select PEM as file type?

------------------------------
YASEMİN ALADI
------------------------------

Original Message:
Sent: Fri April 08, 2022 06:21 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Yasemin,

I configured the Tenant Credential for the on-prem installation.

First, you need to create the private and public keys pair.
For this, I used OpenSSL on a Windows machine.
Here is the download link: http://gnuwin32.sourceforge.net/packages/openssl.htm
Download the Binaries in zip format.
More about the creation of the pair may see on this video: https://www.youtube.com/watch?v=iHb3nFtzFoc.
There are all needed commands to create a public and private key in "pem" format.

After the creation of the privatekey.pem and publickey.pem you need to log in the RPA control center and select:
Administer Tenants -> Tenant Configuration -> Credentials

in a Public Key field upload your created publickey.pem file from your Windows machine.
in a Private Key -> File Type select Pem
in a File Path type full path where is your created privatekey.pem on your Windows machine (for Example: C:\TenantKeys\privatekey.pem).
and Save Configuration.

After that you need to creat Credentials -> New Credentilas and type:
Name: some Credential Name
Username: some UserName
Password: password for the Username.

When you use getvault you should type Credential Name in the key parameter.

NOTE: The privitekey.pem file should be copied on all PCs where you run bots on the same PATH typed in the File Path field.

That it is.
I hope this will help you.

Best regards,


------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:55 AM
From: YASEMİN ALADI
Subject: Database connection string and System Vault

How did you configure Tenant Credential? Did you install openssl for keys pair? I am not familiar with this, so I want learn. Please help me.

------------------------------
YASEMİN ALADI

Original Message:
Sent: Fri April 08, 2022 05:52 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Nigel,

Thank you for your quick prompt.
The issue was in the Tenant Credential configuration.
Now the Tenant Credential is configured with proper keys pair and the ODBC Connection works well.

Best regards,
Stanislav

------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:00 AM
From: NIGEL CROWTHER
Subject: Database connection string and System Vault

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

Hi,

Click on the combo box and select from the dropdown menu.
Please see the attached print screen.



------------------------------
Stanislav Terziev
------------------------------

Original Message:
Sent: Fri April 08, 2022 06:54 AM
From: YASEMİN ALADI
Subject: Database connection string and System Vault

Thanks for detailed answer. But I have a question. In tenant configuration window, file type for private key combobox is empty. How can I select PEM as file type?

------------------------------
YASEMİN ALADI

Original Message:
Sent: Fri April 08, 2022 06:21 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Yasemin,

I configured the Tenant Credential for the on-prem installation.

First, you need to create the private and public keys pair.
For this, I used OpenSSL on a Windows machine.
Here is the download link: http://gnuwin32.sourceforge.net/packages/openssl.htm
Download the Binaries in zip format.
More about the creation of the pair may see on this video: https://www.youtube.com/watch?v=iHb3nFtzFoc.
There are all needed commands to create a public and private key in "pem" format.

After the creation of the privatekey.pem and publickey.pem you need to log in the RPA control center and select:
Administer Tenants -> Tenant Configuration -> Credentials

in a Public Key field upload your created publickey.pem file from your Windows machine.
in a Private Key -> File Type select Pem
in a File Path type full path where is your created privatekey.pem on your Windows machine (for Example: C:\TenantKeys\privatekey.pem).
and Save Configuration.

After that you need to creat Credentials -> New Credentilas and type:
Name: some Credential Name
Username: some UserName
Password: password for the Username.

When you use getvault you should type Credential Name in the key parameter.

NOTE: The privitekey.pem file should be copied on all PCs where you run bots on the same PATH typed in the File Path field.

That it is.
I hope this will help you.

Best regards,


------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:55 AM
From: YASEMİN ALADI
Subject: Database connection string and System Vault

How did you configure Tenant Credential? Did you install openssl for keys pair? I am not familiar with this, so I want learn. Please help me.

------------------------------
YASEMİN ALADI

Original Message:
Sent: Fri April 08, 2022 05:52 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Nigel,

Thank you for your quick prompt.
The issue was in the Tenant Credential configuration.
Now the Tenant Credential is configured with proper keys pair and the ODBC Connection works well.

Best regards,
Stanislav

------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:00 AM
From: NIGEL CROWTHER
Subject: Database connection string and System Vault

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------

Thanks for your help. When I ask to you, the browser session was expired. When I try to login control room again, I see that combobox has items.

------------------------------
YASEMİN ALADI
------------------------------

Original Message:
Sent: Fri April 08, 2022 07:04 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Click on the combo box and select from the dropdown menu.
Please see the attached print screen.

Best regards,

------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 06:54 AM
From: YASEMİN ALADI
Subject: Database connection string and System Vault

Thanks for detailed answer. But I have a question. In tenant configuration window, file type for private key combobox is empty. How can I select PEM as file type?

------------------------------
YASEMİN ALADI

Original Message:
Sent: Fri April 08, 2022 06:21 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Yasemin,

I configured the Tenant Credential for the on-prem installation.

First, you need to create the private and public keys pair.
For this, I used OpenSSL on a Windows machine.
Here is the download link: http://gnuwin32.sourceforge.net/packages/openssl.htm
Download the Binaries in zip format.
More about the creation of the pair may see on this video: https://www.youtube.com/watch?v=iHb3nFtzFoc.
There are all needed commands to create a public and private key in "pem" format.

After the creation of the privatekey.pem and publickey.pem you need to log in the RPA control center and select:
Administer Tenants -> Tenant Configuration -> Credentials

in a Public Key field upload your created publickey.pem file from your Windows machine.
in a Private Key -> File Type select Pem
in a File Path type full path where is your created privatekey.pem on your Windows machine (for Example: C:\TenantKeys\privatekey.pem).
and Save Configuration.

After that you need to creat Credentials -> New Credentilas and type:
Name: some Credential Name
Username: some UserName
Password: password for the Username.

When you use getvault you should type Credential Name in the key parameter.

NOTE: The privitekey.pem file should be copied on all PCs where you run bots on the same PATH typed in the File Path field.

That it is.
I hope this will help you.

Best regards,


------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:55 AM
From: YASEMİN ALADI
Subject: Database connection string and System Vault

How did you configure Tenant Credential? Did you install openssl for keys pair? I am not familiar with this, so I want learn. Please help me.

------------------------------
YASEMİN ALADI

Original Message:
Sent: Fri April 08, 2022 05:52 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi Nigel,

Thank you for your quick prompt.
The issue was in the Tenant Credential configuration.
Now the Tenant Credential is configured with proper keys pair and the ODBC Connection works well.

Best regards,
Stanislav

------------------------------
Stanislav Terziev

Original Message:
Sent: Fri April 08, 2022 05:00 AM
From: NIGEL CROWTHER
Subject: Database connection string and System Vault

Hi Stanislav,

You can do this two ways.  The first is to use encryption/decryption rather than the system vault.  The second is to coerce the SecureString passed back from Get Vault to plain text.  Examples of both are found here:

Encrpyt/Decrypt

Get Vault as String

------------------------------
NIGEL CROWTHER

Original Message:
Sent: Thu April 07, 2022 09:06 AM
From: Stanislav Terziev
Subject: Database connection string and System Vault

Hi,

Could you support me with how to use password got from System Vault and after I need to use it as a parameter on the ODBC Connection string.
The password is a secure string but the parameter on a Connection string should be plain text.
Where is my mistake?

Thank you.
Best regards,

------------------------------
Stanislav Terziev
------------------------------