A common and reliable open-source relation database system with support for advanced SQL standards and diverse data types.
Supported Connection Methods
Available methods for connections to the target system from Lumi AI:
Supported Limits
The following are limits that can be configured for the system to moderate access and usage from users in Lumi AI:
Available Parameters
These properties are the essential source system connection properties that all queries are directed towards.
* Required parameters
Note: The Gateway parameter is common to all systems (when supported) and is only available when gateway is the selected connection method.
Host*
Domain or IP of the database to allow a connection to Lumi AI.
👍Valid Examples
Domain name: docs.lumi-ai.com
IPv4: 55.88.92.101
👎 Invalid Examples
IPv4 with alphanumeric characters: 123.abc.def.456
Incomplete domain name resolutions: lumi-ai.com
Port*
Access port to allow for connections to the database.
👍Valid Examples
Default PostgreSQL port: 5432
👎 Invalid Examples
Known Port Numbers (0-1023): 80
Username*
Username of the generated database user which will be used for interactions and transactions.
Special Considerations
If double quotes are used, then the name will be case sensitive
👍Valid Examples
Uses alphanumeric characters : lumi1
Utilizing underscore (_) in place of spaces: user_number
👎 Invalid Examples
Starting with a number: 1lumi
Utilizing spaces: user name
Using invalid characters: user#1
Password*
Password of the generated database user which will be used for interactions and transactions.
Database*
Literal database name that will be used for transactions within the agents.
Special Considerations
If case sensitivity is required, utilize double quotes for database name; ex. "New_database"
👍Valid Examples
Uses alphanumeric characters: lumi1
Utilizing underscore (_) in place of spaces: new_database
👎 Invalid Examples
Starting with a number: 1lumi
Utilizing spaces: user name
Using reserved words unquoted: select
System Permissions & Configuration
Provided user must have the following:
For configurations:
Special Considerations
Special characters and case sensitivity can be utilized in database names and usernames via encasing the name in double quotes (" "), but is not recommended
Common Issues
Ensure the firewall settings allow for a connection to the database