You can access the Data Stores page from Settings > Team > Data Stores.
Data Stores Page Overview
The Data Stores page allows you to manage connections to external PostgreSQL databases. Registered database connections can be used within workflows using the Data Store Node and Data Query Node. Currently, the following databases are supported:- PostgreSQL: Connect to PostgreSQL databases and execute SQL queries
Creating a Data Store
Navigate to Data Stores Settings
Go to Settings > Team > Data Stores in Giselle.
Enter Connection Information
Configure the following fields:
Name
Enter a name for the Data Store (e.g., “Production Database”, “Analytics DB”). This helps you identify the connection later.Connection String
Enter the PostgreSQL connection string.The connection string is encrypted and stored securely. For security reasons, the connection string is not displayed in the UI once saved.
Currently, only IPv4 addresses are supported. Databases using IPv6 addresses cannot be connected.
Managing Data Stores
Viewing Data Stores
The Data Stores page displays all Data Stores for your team with the following information:- Name: The descriptive name you set
- ID: The unique identifier for the Data Store
- Action Menu: Options for editing and deleting
Editing a Data Store
To edit a Data Store:- Select Edit from the action menu (three dots)
- The “Edit Data Store” dialog opens
- You can update the following fields:
Name
You can change the name of the Data Store.Update connection string
Check the checkbox to update the connection string.When updating the connection string, you must enter the new connection string completely. For security reasons, the existing connection string is not displayed.
- Click Save to save your changes
Deleting a Data Store
To delete a Data Store:- Select Delete from the action menu
- Confirm in the “Delete Data Store” dialog
- Execute the deletion
Empty State
When No Data Stores Exist
If no Data Stores have been created:- “No data stores yet”
- ‘Please create a data store using the “New Data Store” button.‘
Error Messages
The following errors may occur:- Name is required: Please enter a name
- Connection string is required: Please enter a connection string
- Invalid connection string format: The connection string format is incorrect
- Connection string must use postgresql:// or postgres:// protocol: The protocol is incorrect
- Connection string must include a host: The connection string must include a host
- Connection to private or internal IP addresses is not allowed: Connections to private IPs are not allowed
- Unable to resolve hostname: Cannot resolve the hostname
- IPv6 addresses are not supported: IPv6 addresses are not supported
- Data store not found: Data Store not found
- No DataStore node connected to DataQuery node: Data Store Node is not connected to Data Query Node
- DataStore node is not configured: Data Store Node is not configured
Using Data Stores
Registered database connections can be used with the following Nodes:- Data Store Node: Select a database connection
- Data Query Node: Execute SQL queries against the Data Store