Working with a live connection database
Live connection databases are currently in private preview. To request access, contact Tonic.ai.
Live connection databases 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
By default, a Data Agent database generates data in Fabricate. You can then export the data to files or to a database.
A live connection database generates data directly to an external database.
For a live connection database, the Connections section lists the database connections for the database. For example, you connect a live connection database to both an empty staging database and an existing production database. You might then generate data to the staging database based on the profile of the production database.
The database connection that you create when you create the live connection database is marked as the default.
Supported database platforms
Live connection databases can connect to the following databases:
MySQL
PostgreSQL
SQL Server
Displaying the schema for a database connection
For a live connection database, the schema information, including the list of tables and the structure of the tables, is based on the currently selected connected database connection.
To display the schema for a different database connection, in the Connections list, click the database connection name.
Adding a database connection
To add a database connection:
In the Connections list, click the + icon.
In the Connection Name field, provide a name to use to identify the database connection.
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.
In the Database Name field, provide the name of the database.
To test the connection to the database, click Test Connection.
To save the database connection, click Create Connection.
Editing a database connection
You can change a database connection. You can select a different server connection, or choose a different database.
To edit a database connection:
In the Connections list, click the edit icon for the database connection.
From the details panel, you can:
Change the name of the database connection. You can change the name of the default database connection, but it is still marked as the default.
Select a different server connection.
Select a different database.
Click Save Changes.
Deleting a database connection
You cannot delete the default database connection.
You can delete other database connection.
To delete a database connection:
In the Connections list, click the edit icon for the database connection.
On the details panel, click Delete.
Generating data to a database connection
To generate data to a database connection, prompt the Data Agent. If you have a populated database connection to work from as a resource, you can base the generated data on that database connection. Unless you specify otherwise, Fabricate generates all new data and does not use data from another data connection.
For example:
Populate the default database using the same profile as the prod database, but scale up the data volume to 1,000 customers. Use the same products as the prod database.
You can also add records to a database:
Add another 500 customers to the default database while maintaining the existing profile.
If you don't specify the database connection to use, the Data Agent uses the default database connection.
Add 25 customer records to the Other connection database.
Last updated
Was this helpful?