Q&A

how can I call a custom function created in Oracle DB from denodo
answered 31-12-2019 15:57:53 -0500

Hi , i have created a Pl/SQL function in underlying oracle database which set the context based on passed input user parameter. i want to call this function from denodo VQL. i imported this function in denodo by creating base view on it and then trie...

Answers: 1

Function Custom Functions

Association query
answered 30-12-2019 21:13:28 -0500

Hi All, I had stuck with a case that when i hit the associations rest service to get the details, am getting only table names in response but not the mapping details between those tables.

Answers: 1

Need to run a select statement
answered 30-12-2019 20:57:26 -0500

hi, I am new to denodo and I am in need to run the below query and export results using denodo. I have imported the db views as base views in denodo, but in order to achive the below which involves multiple tables, sub queries, where condition and in...

Answers: 1

Wrong Answer in Denodo 7.0 Developer Introduction Certification
answered 28-12-2019 11:14:09 -0500

Hi, While giving the test for denodo 7.0 developer introduction module i came across some question where i think my answer option is correct but the portal says incorrect. if my observation is correct then i think you need to correct that in certifi...

Answers: 2

Certification

Salesforce connection
answered 26-12-2019 20:03:28 -0500

I'm not able to create a salesforce connection? I'm getting the below error. error=invalid_client_id&error_description=client%20identifier%20invalid can any one share the connection deatails what need to enter in each filed or with sample data? I...

Answers: 1

Timestamp Issue
answered 26-12-2019 17:40:21 -0500

Hi, During our PoC with Denodo, we faced some issues related with Timestamp-NTZ and Timestamp-LTZ column types. When we include these fields in Base View (or SQL based Base View) columns are mismatching. Basically, denodo cannot determine the column(s...

Answers: 1

snowflake Base view DENODO timestamp

VDP Server
answered 26-12-2019 14:17:39 -0500

Hi, VDP sever using Express version 7.0 in my system is not starting. Tried installing latest version with latest License file. Need Help

Answers: 1

VDP server VDP start VDP

Denodo Disparat sources join without Cache.
answered 26-12-2019 14:12:56 -0500

Hi Guys, I am new to Denodo. I have installed Express edition on my laptop and running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join ...

Answers: 3

join Cache

Accessing Denodo docker container from host by docker hostname.
answered 26-12-2019 11:22:44 -0500

Hello, I'm using the Docker container image for development and integration tests. It has been working fine when I leave the hostname for the container as localhost, and I can access it from the host. Now I need other containers to access the Denodo c...

Answers: 2

ODBC binding parameters
answered 23-12-2019 17:54:49 -0500

I'm connecting true the ODBC driver form PHP to the denodo database. I'm using pdo and want to make use of binding parameters in de code. e.q.: This works: $denodo = new DenodoDatabase(); $sql = "SELECT * from orders where ordernumber = 20753852 limi...

Answers: 3

ODBC php Bindparam Windows