Q&A BY TAG 'SQL Server'

You must sign in to ask a question. If you do not have an account, you can register here

Pass-through security for SQL Server data sources
answered 18-12-2019 17:13:58 -0500

Currently we are using LDAP and Active Directory to allow users to authenticate to data sources in Denodo. We would like the capability to ignore this and use pass-through authentication, based on SQL Server permissions. In other words, if a user has W...

Answers: 1

SQL Server Denodo_SQL_Server Active Directory pass-through

VQL equivalent for T-SQL "WITH (NOLOCK)"
answered 13-06-2019 21:26:31 -0400

Our DBA claims that the Denodo view is causing DEADLOCKs on the SQL Server. They recommended us to pass the query to SQL Server with the "WITH (NOLOCK)" option. Is this possible with Denodo views? If yes, please provide specific example. Btw, the SQL...

Answers: 1

sql server deadlock nolock deadlock read uncommitted sql server

Compare sql Vs vql using denodo testing tool
answered 13-06-2019 12:11:13 -0400

This is the errror I am receiving. Exception in thread "main" java.lang.IllegalArgumentException: Missing configuration parameter 'encoding' at com.denodo.connect.testing.Configuration.get(Configuration.java:106) at com.denodo.connect.testing.Configur...

Answers: 2

Denodo TEsting Tool SQL Server

How to use Microsoft SQL Server 2016 (MS Driver) to connect to SQL Server with Windows Authentication (not SQL Server Authentication)
answered 12-06-2019 12:04:53 -0400

I am unable to configure SQL Server as a Data Source using the "Microsoft SQL Server 2016 (MS Driver)" as the Database Adapater where the user is a Windows Authenticated user (i.e., not a SQL Server Authenticated user) but without having to setup Kerbe...

Answers: 2

Data Source SQL Server MS Driver

Sql Vs vql using denodo testing tool
answered 24-05-2019 08:01:29 -0400

hello, how do I connect sql server using integratedservices; and compare with vql using Denodo Testing Tool. Please help!! Please provide link if there is documentation. When I tried I keep getting java configuration 'encoding' error. I am able to tes...

Answers: 1

Denodo TEsting Tool SQL Server

JDBC Connection to SQL Server Express - URI
answered 29-04-2019 19:00:03 -0400

Running Denodo Express VDP on my laptop. Got SQL Express installed and loaded with AdventureWorks DW 2014 data. What would be the URI if this is the case? I am trying to connect via JDBC using the following URI: jdbc:jtds:sqlserver://IA-EME/SQLEXPRESS...

Answers: 3

SQL Server

Not able to access the Data sources option (Json or SQL)
answered 07-03-2019 05:39:05 -0500

I want to create the jason and SQL base view in Denodo 7.0. When i go to the sources I see only Excel and LDAP option. Other option is there but not able to use.

Answers: 1

SQL Server #HTTP #Post #Rest_API #webservice

Write values to a data base
answered 20-02-2019 18:17:36 -0500

Hi, can we use Denodo to write (insert records, delete recors, modify) the results of a given query to a data base? (i.e i would like to store the results of a query into a SQL data base) Many thanks,

Answers: 1

Insert Operation SQL Server SQL

Copying ntlmauth.dll to DENODO_HOME/jre/bin
answered 10-02-2019 22:01:51 -0500

Hi, I would like to add my experience with Denodo 5.5 in Windows 2012 64 bit. I had to copy ntlmauth.dll to %DENODO_HOME%/jre/bin and restart the server instead of %SYSTEMROOT%/system32. The latter wouldn't work and raised a "SSO Failed: Native SS...

Answers: 1
Related to: Accessing MS SQL Server using Windows Authentication

NTLM JDBC Data Sources SQL Server SSO

SQL Server recursive query
answered 14-12-2018 05:42:20 -0500

According to https://community.denodo.com/answers/question/details?questionId=90670000000XcjoAAC&title=Can+denodo+Support+to+recursive+queries+%3F Denodo doesn't support recursive query directly. I am trying to create a base view through the method...

Answers: 1

recursive query SQL Server