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:

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

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 VPN, but support any method you require, like IPsec VPN or AWS PrivateLink. More info here.

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 (or VioletGov), navigate to Integrations and click .

2. Select Teamcenter - SQL Server

[Optional] Assign permissions to which users or user groups can view the data or edit the credentials:

1. 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.