Latest Activity


Permissions and privileges need for source connection on source database

Hello - we are new to Denodo. I'm looking for documentation or direction on permissions and privileges needed at the source database level when connecting. We will have both source Oracle and SQLServer. Other than read only? Create temp table? Reading ...

Oracle SQLServer


Datatype Issue while creating a base view from SQL Server

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...

DENODO MSSQL SQLServer sql server datatypes Date


How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?

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...



How to connect to SQLServer localdb

Hello, How do I conect to the SQLServer localdb? These parameters do not work: 'D:\Denodo\extensions\thirdparty\lib\sqljdbc41.jar' jdbc:sqlserver://(LocalDb)\MSSQLLocalDB:1433;databaseName=denodoCache Error message is rather standard: Unable to ...

localdb SQLServer


How can I access SQL Server with Denodo Express?

Hi, I was trying to create an ODBC Data Source to access a SQL server, however I got an error: Creation of new ODBC data source with the 'Microsoft SQL Server adapter is not allowed by the license Is that the expected behavior? How could I connect ...

Connectivity SQLServer