Which is build 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.
Username and Password
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.
Additional instructions for specific dialects
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 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.
Microsoft SQL Server
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.