# Oracle Database Example

This example is completed using an **Oracle Database Express** (Oracle Database XE) installed and configured instance.

> To be able to connect and work with the database from Test Studio it is necessary to install <a href="http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html" target="_blank">**Oracle Data Access Components**</a>.

Next step is to create a database in order to use it for data binding. One way to do it is by using <a href="http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html" target="_blank">Oracle SQL Developer</a>. On the following image there are SQL queries that will create table **Employees** and insert there two rows of data.

![Create Table](https://www.telerik.com/teststudio/documentation/assets/590b3abdce26fe677c21aadcd99cb8d8/fig1.png)

Once the table is created it is possible to connect to it and use it for data-driven testing:

1. Click on **Add** from **Data Sources** menu:

   ![Create Table](https://www.telerik.com/teststudio/documentation/assets/bd27d002652dee08320ba6f10f2912d3/fig4.png)

2. In the **Create new data source** dialog - for **Data Source Types** choose **Database**

   ![Create New Data Source](https://www.telerik.com/teststudio/documentation/assets/e6652b5c1bc80ae67541f03af57242b3/fig2.png)

3. For **Provider**, select **Oracle Data Provider for .NET**

4. Here's an example for **Connection String**:

```
Data Source=XE;User Id=SYSTEM;Password=pass;
```

It is possible to create many different connection strings. See <a href="https://www.connectionstrings.com/oracle/" target="_blank">here</a> for more examples.

5. Customize the **Friendly Name** as desired.

6. Click **Create** and the new data source should appear in the Data Sources list.

<br/>

When a <a href="/features/data-driven-testing/bind-test-data-source" target="_blank">test is bound</a> to this data base the table to be used will be specified:

![Bind To Table](https://www.telerik.com/teststudio/documentation/assets/a0ead408eea525e9e921ee903268c1f1/fig3.png)
