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

JDBC Connection to SQL Server Express - URI
answered 22-04-2019 23:34:20 -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: 2

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

Not able to connect to SQL Server using an Active Directory account
answered 17-09-2018 08:55:00 -0400

Hello, I am using Denodo 6.0 In the VDP tool, I am trying to connect to a SQL Server database using a Active Directory account (domain \ account name). However, when I test the connection, the tool is telling me: 'Unable to establish Connection. Login ...

Answers: 1

SQL Server Active Directory

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

How to connect the Denodo Server to the SQL Server who supports SSL?
answered 16-04-2018 08:31:24 -0400

The Denodo Server is trying to connect to the Client’s SQL Server using JDBC. But, the SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the client’s server so turning of SSL is not an option. In that case, how to connect th...

Answers: 3

SQL Server SSL

How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?
answered 11-04-2018 04:11:40 -0400

The Denodo Server is trying to connect to the Microsoft SQL Server using JDBC. But, the MS SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the the server so turning off SSL is not an option. In that case, how to connect th...

Answers: 1

SQL Server MSSQL SSL SQLServer