# Encrypt DB Password in Database connection string

**URL:** <https://forum.katalon.com/t/encrypt-db-password-in-database-connection-string/80518>\
**Category:** Web Testing\
**Tags:** katalon-studio\
**Created:** [November 10, 2022, 5:12pm UTC](https://forum.katalon.com/t/encrypt-db-password-in-database-connection-string/80518 "2022-11-10T17:12:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![thushar.ameen](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/thushar.ameen/32/16104_2.png) [@thushar.ameen](https://forum.katalon.com/u/thushar.ameen)\
**Post date:** [November 10, 2022, 5:12pm UTC](https://forum.katalon.com/t/encrypt-db-password-in-database-connection-string/80518/1 "2022-11-10T17:12:41Z")

</div>

Hi All,  
I have two questions.

1. How to hide or encrypt database password that use in Database connection string rather use it as it is?  
 ![image](https://europe1.discourse-cdn.com/katalon/original/3X/d/6/d69d16a0f748dda1500c6cce84df1f8dc82fe6b8.png)

2 I have connected the project with Global database connection, Project → Settings → Database. Can I use the global database connection to write test execution results to the database in after test suite in the Listener? if so, how to di it?

Thanks,  
Thushar

---

<div class="post-metadata">

**Author:** ![sara.leslie](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/sara.leslie/32/20699_2.png) [@sara.leslie](https://forum.katalon.com/u/sara.leslie)\
**Post date:** [November 10, 2022, 5:21pm UTC](https://forum.katalon.com/t/encrypt-db-password-in-database-connection-string/80518/2 "2022-11-10T17:21:10Z")

</div>

I will defer to the experts to assist on this but could you please tell us what version of the product you are using? Thanks, S

---

<div class="post-metadata">

**Author:** ![thushar.ameen](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/thushar.ameen/32/16104_2.png) [@thushar.ameen](https://forum.katalon.com/u/thushar.ameen)\
**Post date:** [November 10, 2022, 5:39pm UTC](https://forum.katalon.com/t/encrypt-db-password-in-database-connection-string/80518/3 "2022-11-10T17:39:54Z")

</div>

Currently we use Katalon\_Studio\_Windows\_64-8.5.0. Thanks!

---

<div class="post-metadata">

**Author:** ![discover.selenium](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/discover.selenium/32/522_2.png) [@discover.selenium](https://forum.katalon.com/u/discover.selenium)\
**Post date:** [November 12, 2022, 6:18am UTC](https://forum.katalon.com/t/encrypt-db-password-in-database-connection-string/80518/4 "2022-11-12T06:18:52Z")

</div>

To encrypt database password, use the below said reusable methods.

```auto
import com.kms.katalon.util.CryptoUtil as CryptoUtil

	
	println encryptedText("TEST") // Output: ecg0QEv8dOk=
	
	println decryptedText("ecg0QEv8dOk=") // Output: TEST
	
	

	public static String encryptedText(String text) {
		
		text = CryptoUtil.encode(CryptoUtil.getDefault(text))
		return text
	}
	
	
	public static String decryptedText(String text) {
		
		text = CryptoUtil.decode(CryptoUtil.getDefault(text))
		return text
	}
	

```