# Connect direct to database
Follow the instructions below to connect Violet directly to your Teamcenter SQL database.
### Configure access
First, you'll need to configure access to your Teamcenter database server.
Option 1: Access via Allow List
Add the applicable IP addresses to the allow list for your Teamcenter database server:
{% hint style="info" %}
**Violet's IP Addresses**
For **Violet:**
* *Production*: 50.19.87.143
* *Staging*: 34.204.135.202
For **VioletGov**:
* *Production*: 3.31.169.141
* *Staging*: 3.30.99.219
{% endhint %}
Option 2: Access via VPN
For added security, we can establish a VPN tunnel. This will connect Violet’s AWS VPC and the network where your Teamcenter server is hosted.
We recommend [Tailscale](https://tailscale.com/) VPN, but support any method you require, like IPsec VPN or AWS PrivateLink. More info [here](https://docs.violetlabs.com/resources/administrative/connect-self-hosted-software/vpn-tunnel).
### Create a SQL user
Next, you'll need to create a read-only SQL user with access to the Teamcenter database (NOT a login to Teamcenter itself). Follow the query below to create the user, then share the credentials with the Violet team to configure this before you connect.
You can securely share credentials with the Violet team on the **Credentials** page.
```
CREATE LOGIN [Violet_Readonly] WITH PASSWORD = 'some-password-of-your-choosing';
USE [tc]; -- Switch to the Teamcenter database, usually called 'tc'
CREATE USER [Violet_Readonly] FOR LOGIN [Violet_Readonly];
EXEC sp_addrolemember 'db_datareader', 'Violet_Readonly';
```
### Connect Teamcenter in Violet
Once network access and database access are complete, you are ready to create the connection in Violet:
1. In [Violet](https://app.violetlabs.com/) (or [VioletGov](https://app.violetgov.com/)), navigate to **Integrations** and click to add a new integration.
2. Select **Teamcenter - SQL Server**
\[Optional] You can also provide a unique name for the connection based on the credentials you're using, and you can create **restricted permissions** to users or groups:
3. Enter the SQL username and password, the server IP address and port, and the Teamcenter database name, then click **Connect.**
Once your connection is live, you're ready to [set up your Teamcenter integration](https://docs.violetlabs.com/apps/t/teamcenter/setting-up-your-integration).
to add a new integration.
2. Select 
**Teamcenter - SQL Server**
\[Optional] You can also provide a unique name for the connection based on the credentials you're using, and you can create **restricted permissions** to users or groups:
