Microsoft SQL Server

A robust, scalable relational database with built-in security features, offering advanced data management, real-time analytics, and seamless integration with the Microsoft ecosystem.

Supported Methods

Means for Lumi to connect to the client to implement the services required:

• Direct

  The default / typical connection option. Interfaces directly with the target system over the Internet with no mediation. Suitable for most cloud-hosted scenarios or public-facing resources. See Network Configuration for more details.

• Gateway An alternative connection method leveraging a Lumi AI Data Gateway. This uses Lumi AI's purpose-built connection agent to mediate communications. Ideal for restricting access to systems within a protected network. For more information, see Data Gateway.

Supported Limits

The following are limitations that can be set to fine tune the agents' actions:

• Cost Limit Before running a query, if the system supports it, the system-specific compute cost (or surrogate) estimate will be processed and compared to an organization-level/admin-set cost limit for systems of this type (if configured/set). If exceeded, the query will not run (and either the workflow will attempt an optimization or the user will be notified).

• Duration Limit An alternative to cost, queries will be stopped the system supports a duration/timeout limit and one is set/configured at the organization level (across systems).

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 MS SQL Server port: 1433

👎 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 reserved words not encapsulated: select

• Using invalid characters not encapsulated: 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 not encapsulated: select

• Using invalid characters not encapsulated: user#1

System Permissions & Configuration

Provided user must have the following:

• Grant the user with db_datareader ROLE

• SELECT PRIVILEGE in table(s)

• (if applicable) SELECT PRIVILEGE on table(s) for column(s)

For configurations:

• Ensure the server is allowing connections from the Lumi gateway or server

Special Notes

• Special characters can be utilized in database names and usernames via encasing the name in double quotes (" "), but is not recommended

• Encasing an identifier with [ ] allows for a usage of reserved words and the @ character

Common Issues

• Ensure the server is not in recovery mode and be on an online state

• Ensure the firewall settings allow for a connection to the database

• Ensure the username, password, and database values are explicitly provided