Skip to main content

Documentation Index

Fetch the complete documentation index at: https://ai-kb.automationanywhere.com/llms.txt

Use this file to discover all available pages before exploring further.

With the Generic SQL connector, you can connect to Snowflake, Postgres, Redshift, and other SQL databases using a connection string. Use this connector when there is no dedicated connector tile for your database.

​
Connecting to Generic SQL

1

Open Project Settings

In your EKB project, navigate to Settings in the sidebar.
2

Go to Connections

Select the Connections tab and find the Generic SQL tile under Databases.
3

Open the Generic SQL popup

Click the Generic SQL tile. A popup appears with the option to connect to Snowflake or other SQL databases. Click + Add Connection.
4

Fill in the connection form

Enter the following details:Server
FieldRequiredDescription
Connection NameYesA display name for this connection (e.g. My Generic Connection).
Connect StringYesThe connection string for your database (e.g. sqlite:///:memory:).
Database
FieldRequiredDescription
TablesYesThe tables to index. Enter each table name separated by a comma.
5

Save the connection

Click Save. EKB will authenticate using the details provided. If successful, the Generic SQL tile on the Connections page will display a green dot and a count of your active Generic SQL connections.
You’re now ready to use your database in the Knowledge Base!