# Get And Set Table in Database

**URL:** https://forum.robusta.ai/t/get-and-set-table-in-database/240
**Category:** FAQ
**Created:** [August 26, 2022, 8:16am UTC](https://forum.robusta.ai/t/get-and-set-table-in-database/240 "2022-08-26T08:16:04Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ilayda.ipar](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robusta.ai/ilayda.ipar/32/56_2.png) [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)
#### Post date: [August 26, 2022, 8:16am UTC](https://forum.robusta.ai/t/get-and-set-table-in-database/240/1 "2022-08-26T08:16:04Z")

</div>

In this article we will explain how to connect to the database, get the table created there and how you can set it.

![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/91aaed8adeb33d2dc414ef28f6944783e8d8238e.png)

**Step 1:** Database opens with Open Connection component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/7c5d4e0d96a6136639ed65e6d9b0aa7ddfc9cf6b.png)

**Step 2:** The table in the database is transferred to the data with Execute query component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/09b4c5fb04e67c94298e9ee691144d9028430fe9.png)

**Step 3:** The row number of the drawn table is learned with Get size component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/4af61227a5fae25bb183ea95d187e72a598f31f4.png)

**Step 4:** A sub process is added to create a loop to enter each line into the database.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/518f7234d2e490f0ee3e4ab8f560a74c370dc42d.png)

**Step 5:** The rows of the Ad column in the dataset are read and write to the variable with Get action component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/db6f274b3d78ab654c164c202fdd105b577144f3.png)

**Step 6:** The rows of the Soyad column in the dataset are read and write to the variable with Get action component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/4f1e625d26bcbb1ba3e099c815ca399fe8b5ced5.png)

**Step 7:** The rows of the Şirket Adı column in the dataset are read and write to the variable with Get action component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/fa94ab23126d27d1474916253553360060ad5d29.png)

**Step 8:** The rows of the Meslek column in the dataset are read and write to the variable with Get action component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/7f58171a388c90d7ee2bc022d1169e5565eb0ce2.png)

**Step 9:** The variables received are inserted in the sql language with Execute update component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/0ece3507f661d8c20325eaaf62aecd507a1106f3.png)

**Step 10:** Database closes with Close connection component.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/0f98af60a86ad3f4db9e8cf0bbd4b266837b1d6f.png)

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/robusta1/original/1X/738c6c396f898d0d10196d5a575a168c91808d30.png)