Adding a database connection to a project

Database connections require an Enterprise license.

Your external database must allow connections from the following Fabricate IP addresses:

• US instance (https://fabricate.tonic.ai/)

  • 184.72.239.148

  • 3.231.122.192

• EU instance (http://eu.fabricate.tonic.ai/)

  • 3.67.149.135

  • 3.69.97.191

Supported database platforms

Database connections can connect to the following databases:

• Databricks

• MySQL

• Oracle

• PostgreSQL

• Snowflake

• SQL Server

Defining the connection

To add a database connection to a project:

1. In the navigation panel, click Connect external database.

Option to connect to an external database

Connect live database panel to make the database connection

1. From the Server Connection dropdown list, select the server connection where the database is located. You can optionally add a new server connection or edit the selected server connection. New server connections are added to the available server connections for the workspace. Note that any edits to the selected server connection apply to all of the locations where the server connection is used.

2. In the Database Name field, provide the name of the database.

3. To test the connection to the database, click Test Connection.

4. To save the database connection, click Connect database.

Fabricate automatically names the database connection based on the database name.