Encrypting SQL Credentials

Best practices, code snippets for common functionality, examples, and guidelines.
sdrx
Posts: 17
Joined: Tue Jan 29, 2019 10:15 am

Encrypting SQL Credentials

Post by sdrx » Mon Apr 27, 2020 1:23 pm

We have a solution that uses a mix of SQL via .cs files with connection strings hard coded and Ranorex data sources with connection strings formed by filling in the fields.

Is there a way to encrypt the SQL credentials within these 2 areas so they are not just stored in plain text?

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 6036
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Encrypting SQL Credentials

Post by odklizec » Tue Apr 28, 2020 7:44 am

Hi,

I'm afraid, there is no such a possibility in Ranorex (not out of the box). The best (and most correct) thing you may probably do, is to request/create a separate TA account/environment, just for test purposes. Seriously, you should not use production accounts (and environment/data) for TA. I would use TA in production environment only and solely for debugging a problem, which is not reproducible in test/debug environment. And even then I would use special TA account or use production account only for quick debug and then immediately replace it with test one.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration