Connect direct to database

Follow the instructions below to connect Violet directly to your Teamcenter SQL database.

Configure access to your SQL server

First, you'll need to configure your Teamcenter SQL server to communicate with Violet via one of the below methods:

Option 1: Connect via Allow List

In this method, Violet will communicate directly with your Teamcenter server on a dedicated port via an IP allow list.

To do so, you will need to open your firewall to our IP address:

1. By default, Violet will connect to port TCP:8080 on your Teamcenter server

   1. To ensure that the connection between Violet and Teamcenter is secure, it is important that the endpoint on your Teamcenter server is protected with a valid SSL certificate.

   2. If you prefer to use a different port, let us know. Any port is fine as long as JsonRestServices is available there.

2. If you are using Teamcenter Active Workspace, we will also need to communicate with port 3000 (in particular if you plan to transfer Teamcenter files)

3. Allowlist our IP address (below) at the selected ports:

   1. For Violet: 50.19.87.143

   2. For VioletGov: 3.31.169.141

   3. More information on allow listing can be found here.

Option 2: Connect via VPN

In this method, we’ll establish a VPN tunnel between Violet’s AWS VPC and the network where your Teamcenter is hosted.

We recommend Tailscale VPN, and can also support methods like IPsec VPN and AWS PrivateLink.

See more detail on how to set this up here.

Create a SQL user

Next, you'll need to create a read-only SQL user with access to the Teamcenter database:

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

Once network access and database access are complete, you are ready to create the connection in Violet:

1. In Violet (or VioletGov), navigate to Apps 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:

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.