Q&A

Unable to connect to the database: The TCP/IP connection to the host DESKTOP-FT43ES7, port 1433 has failed. Error: "connect timed out. Verify the connection properties
answered 13-07-2021 06:19:59 -0400

Unable to connect to the database: The TCP/IP connection to the host DESKTOP-FT43ES7, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/I...

Answers: 1

Unable to create the connection between MS SQL Server 2019 To Denodo 8.0
answered 12-07-2021 23:11:00 -0400

i am unable to connect MS SQL Server 2019 to Denodo 8.0 databse adpater:microsfot sql server 2017(MS Driver) Driver classpath : mssql-jdbc-6.x Driver Class : com.microsoft.sqlserver.jdbc.SQLServerDriver databse URL :jdbc:jtds:sqlserver://DESKTOP-FT43ES...

Answers: 1

ODBC vs RESTful API
answered 12-07-2021 16:39:12 -0400

Hello Team, May i know what are differences in features avaiable between a client app connecting Denodo via connecting with RESTful Web Service in terms of selction/filtering/authentication etc? Thanks

Answers: 1

#API #Rest_API #odbc

Authentication via Client App
answered 12-07-2021 07:47:10 -0400

Hello Team, May i know what are the authentication methods to connect to Denodo via client app. I wnet through your docs and found credentials and SSO are two ways only, is it correct?

Answers: 1

#authentication

VCS commit to code gives error
answered 12-07-2021 02:14:46 -0400

Hi Team, I am trying to commit my code in GIT repository, but getting error as 'Error obtaining elements to commit: Only a check-in of the entire database is allowed after changing the configured environment' Any insights on what causing the error an...

Answers: 1

Bulk Load Error With Apache Ranger
answered 12-07-2021 01:30:17 -0400

i am testing bulk load feature now (hive and hdfs) In our production environment, we are using apache ranger(LDAP) for authorization in hive and hdfs. I got error checking if the HDFS path exist. Connection between vdp and hdfs is normal. We also check...

Answers: 1

authorization Bulk Data Load

GraphQL service - passing credentials for Basic Auth
answered 09-07-2021 12:29:33 -0400

Hi Team, We were trying to use GraphQL service using an IDE something like GraphQL Playground, however, were unsure how to pass connection details into the header for basic authentication. By looking at Denodo's documentation you specify that - '' In...

Answers: 1

GraphQL

remove column when null
answered 09-07-2021 04:16:02 -0400

Hello, I have exposed the data in JSON and now I want column/key which has null value in it should not appear in JSON, example: { "student": "1203", "Rollnumber": "1", "status": "deactivated", "Grade": ...

Answers: 1

null

How to connect denodo to SQL server which uses Hera KMS to protect sensitive data
answered 08-07-2021 18:50:12 -0400

Hi Team, One of our consumer is migrating their DB to SQL server and will be using Hera KMS to protect their sensitive data. They want a mechanism in denodo to connect to the SQL server and decrypt the data which is encrypted by Hera KMS. They are look...

Answers: 1

#decryption #herakms #kms

User is not able to see "include users and roles" checkbox while vdb export
answered 08-07-2021 14:08:01 -0400

Hi Team, One of our consumer is unable to see"include users and privileges" checkbox while she is trying to export her vdb though she has local admin rights to the vdb she is trying to export. What is the reason behind it? How to correct it? Please help.

Answers: 1

#Export_metadata #vdbexport #Roles