telosystools

Open full view…

SQL Server connection over SQL Server Authentication

richardhorvath
Sun, 21 May 2023 17:54:22 GMT

Hi, I am very new to Telosys code generation, I tried to connect to SQL Server but failed. With DBeaver, if I set up SQL Server authentication, I can connect. Although I use the same JDBC driver for Telosys. Can anyone help me figure out how to specify this authentication method in the jdbc URL? Thanks in advance!

Telosys Team
Thu, 25 May 2023 20:56:03 GMT

You just have to edit the "databases.yaml" file (you can use "edb" command in CLI) and define the JDBC connection properties, something like that : driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" url = "jdbc:sqlserver://10.226.xxx.xxx" user: xxx password: xxx catalog: demo schema: dbo See https://doc.telosys.org/telosys-cli/cli-getting-started/model-creation/new-model-from-database NB: don't forget to put the jdbc jar file ( "sqljdbc.jar" ) in "TelosysTools/lib" See https://stackoverflow.com/questions/50156877/how-to-set-the-jdbc-driver-jar-in-telosys-cli-to-create-a-dbmodel