# Project database settings usage

**URL:** <https://forum.katalon.com/t/project-database-settings-usage/13276>\
**Category:** Miscellaneous\
**Created:** [September 18, 2018, 12:42pm UTC](https://forum.katalon.com/t/project-database-settings-usage/13276 "2018-09-18T12:42:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edita\_Markauskaite](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/edita_markauskaite/32/2770_2.png) [@Edita\_Markauskaite](https://forum.katalon.com/u/Edita_Markauskaite)\
**Post date:** [September 18, 2018, 12:42pm UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/1 "2018-09-18T12:42:33Z")

</div>

Please someone help me. I can not understand how to use/connect to my db which I set in project settings. How can I connect to it or how to get variables which I used? I can`t figure out…  
Only found how to connect to db with own variable but not set in project settings 😕

---

<div class="post-metadata">

**Author:** ![Andrej\_Podhajsky](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/andrej_podhajsky/32/1055_2.png) [@Andrej\_Podhajsky](https://forum.katalon.com/u/Andrej_Podhajsky)\
**Post date:** [September 18, 2018, 3:06pm UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/2 "2018-09-18T15:06:36Z")

</div>

you can use settings from project when you are defining new data source of DB type in Data Files  
 ![](https://s3.amazonaws.com/katalon-forum/editor/qv/o9x0epmbk482.png "Image: https://s3.amazonaws.com/katalon-forum/editor/qv/o9x0epmbk482.png")

[image.png](https://s3.amazonaws.com/katalon-forum/editor/qv/o9x0epmbk482.png)

---

<div class="post-metadata">

**Author:** ![Edita\_Markauskaite](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/edita_markauskaite/32/2770_2.png) [@Edita\_Markauskaite](https://forum.katalon.com/u/Edita_Markauskaite)\
**Post date:** [September 19, 2018, 5:45am UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/3 "2018-09-19T05:45:13Z")

</div>

Thanks. But problem is other. Can I use these settings in my script to execute query? Not only for data files

---

<div class="post-metadata">

**Author:** ![Andrej\_Podhajsky](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/andrej_podhajsky/32/1055_2.png) [@Andrej\_Podhajsky](https://forum.katalon.com/u/Andrej_Podhajsky)\
**Post date:** [September 19, 2018, 5:57am UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/4 "2018-09-19T05:57:40Z")

</div>

can you please elaborate on wanted usage? simple use case?

---

<div class="post-metadata">

**Author:** ![Edita\_Markauskaite](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/edita_markauskaite/32/2770_2.png) [@Edita\_Markauskaite](https://forum.katalon.com/u/Edita_Markauskaite)\
**Post date:** [September 19, 2018, 9:37am UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/5 "2018-09-19T09:37:39Z")

</div>

This case:  
My script send coupon code to input, example in buying process.  
Coupon code can be various types and according to type should be different cases.  
I don`t know what code was entered, so I want to execute query with given code to get his type from db.

---

<div class="post-metadata">

**Author:** ![Andrej\_Podhajsky](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/andrej_podhajsky/32/1055_2.png) [@Andrej\_Podhajsky](https://forum.katalon.com/u/Andrej_Podhajsky)\
**Post date:** [September 19, 2018, 10:58am UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/6 "2018-09-19T10:58:34Z")

</div>

understand.  
i don’t think settings of DB in project will help you. Unfortunately you will need to go with DB based testing with custom keywords to be able to execute db requests as you like.  
i guess you allready know this:

> **[How to perform Database Testing using Katalon Studio](https://docs.katalon.com/katalon-studio/tutorials/connect_db_gui_testing.html)**
>
> Katalon Studio allows users to create custom keywords to address specific needs. With custom keywords, you can connect and perform database testing.

---

<div class="post-metadata">

**Author:** ![Edita\_Markauskaite](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/edita_markauskaite/32/2770_2.png) [@Edita\_Markauskaite](https://forum.katalon.com/u/Edita_Markauskaite)\
**Post date:** [September 19, 2018, 11:09am UTC](https://forum.katalon.com/t/project-database-settings-usage/13276/7 "2018-09-19T11:09:59Z")

</div>

Yes, I done like this but hopped that I could change it.  
Well, thanks. Leave as it is now…