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

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

Datatype Issue while creating a base view from SQL Server
answered 10-05-2018 03:00:38 -0400

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

Answers: 1

DENODO MSSQL SQLServer sql server datatypes Date

ODBC connection issue
answered 07-05-2018 06:50:51 -0400

I am trying to connect sql server 2014. I installed ODBC drivers provided from denodo but connection issue as below. What is the fix for this?? "Unable to establish connection: server closed the connection unexpectedly This probably means the server t...

Answers: 4

ODBC SQL Server