SQL Connector
Connect to SQL databases, retrieve data, and execute SQL statements
Last updated
Connect to SQL databases, retrieve data, and execute SQL statements
Last updated
The SQL Helper has only one default action - execute SQL.
To start setting up your connector auth, either go to Settings -> Connector Auth and add a new auth, or add the SQL Helper to a flow and click "Create new Auth".
The Base Domain for the SQL Connector Auth has the following schema:
Which is built together based on these input fields:
In case the database driver and dialect of your database is not listed, please reach out to us. Many of the drivers and dialects listed here are supported out of the box and we can add them as an option in a few minutes. However, the ones currently not listed, haven't been specifically tested yet and might require additional implementation time from our site.
In most cases, you will not need a dialect at all. If you get an error message, try the first listed dialect for your database.
In almost all cases, it is advisable to create a separate user for Locoia. To find out how to create a user and manage permissions, please consult your respective database's user guide.
Once you have a user you want to use for DI, simply enter the username and password in these fields.
If you need help connecting your DI SQL Helper to Amazon RDS, consult this article.
To connect to Oracle, append your service name to the end of the connection string, where you would normally enter the database name (</database>).
Known errors and their meanings:
TNS: listener does not currently know of SID given in the connect descriptor => The database name is not provided correctly. This needs to be added at the end with a slash like above mysubdatabase.
ORA-00900: Invalid SQL statement / Ungültige SQL-Anweisung =>The SQL statement is not correct. Please check your syntax and confirm with the Oracle reference.
For some Microsoft SQL Server connections, you need to enter ?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes in the Additional Driver Details field in order to specify that the database required ODBC Driver 18 in order to connect.
