cancel
Showing results for 
Search instead for 
Did you mean: 

How to secure the connection password in ODBC database collection?

How to secure the connection password in ODBC database collection?

Question:

I need to collect data into ODBC format database, how can I ensure the database connection password is encrypted and secured in Prognosis?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to secure the connection password in ODBC database collection?

Prognosis ODBC database collection has the feature of utilizing the PASSWORDS static configuration function to encrypt the password for the ODBC database collection.

 

When setup the database collection document, as below, in the User Name field, if the actual ODBC connection user name is entered directly here, then its password will need to be entered in the Password field, as a result the text dump of this database collection document (eg, in Irfax) will show the password in plain text.


In order to mask the password, the passwordkey can be used followed by the alias for the connection user name in PASSWORDS configuration, for example, passwordkey:MyODBC, and leave the Password field blank. Then add the entry of MyODBC into the PASSWORDS configuration (eg, DB:MyODBC), and enter the real connection user name and password. The password will be encrypted in the text dump of the PASSWORDS configuration.

 

Capture0.JPG

View solution in original post

1 REPLY 1

Re: How to secure the connection password in ODBC database collection?

Prognosis ODBC database collection has the feature of utilizing the PASSWORDS static configuration function to encrypt the password for the ODBC database collection.

 

When setup the database collection document, as below, in the User Name field, if the actual ODBC connection user name is entered directly here, then its password will need to be entered in the Password field, as a result the text dump of this database collection document (eg, in Irfax) will show the password in plain text.


In order to mask the password, the passwordkey can be used followed by the alias for the connection user name in PASSWORDS configuration, for example, passwordkey:MyODBC, and leave the Password field blank. Then add the entry of MyODBC into the PASSWORDS configuration (eg, DB:MyODBC), and enter the real connection user name and password. The password will be encrypted in the text dump of the PASSWORDS configuration.

 

Capture0.JPG

View solution in original post

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar