Q&A BY TAG 'Interpolation Variables'

You must sign in to ask a question. If you do not have an account, you can register here

Credentials in message body?
answered 23-09-2019 01:03:34 -0400

I have two web service data source which expect the user name and password to be passed as part of the POST body. This is easy to make work with interpolation variables but is far less than ideal. Is there a method where the configured credentials c...

Answers: 5

Interpolation Variables Password

Interpolation of function and variable.
answered 26-09-2018 08:27:23 -0400

I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...

Answers: 1

Function Interpolation Variables oracle

Interpolation variable - Passing value from another base view
answered 24-08-2018 02:57:02 -0400

I have first base view with interpolation variables. I would like to pass values for them from second base view. To achieve this, I have created a derived view joining first and second base views. it is working fine until there is a null value in one o...

Answers: 1

Interpolation Variables

Denodo connect to tableau
answered 28-02-2018 04:52:49 -0500

Hi, I am connecting Tableau to denodo view which has interpolation variables which is needed by the datasource to create the dynamic http link. Not sure how i can pass those values from tableau to denodo. Thanks,

Answers: 1

Interpolation Variables

Using an interpolate variable in FROM clause
answered 05-04-2017 08:23:19 -0400

Hi team, I am trying to create a base view from a query based on an interpolate variable within the FROM clause. (SELECT * FROM {schema}.@TABLENAME). I want to do this because the platform I am trying to reach (OutSystems) uses a database with 2 layer...

Answers: 1

Dynamic Interpolation Variables joining of interpolation variables OutSystems

Interpolation variables ? How to add runtime query view in Denodo?
answered 31-10-2016 05:29:23 -0400

Hi I am new to Denodo .. i want to create a web service for my table’s join view, But how shall i pass the input values from my program which will call that web service to the Where clause of the query? how do i declare/use/;map the input data to my w...

Answers: 1

Interpolation Variables

Pass list of value to an interpolation variable
answered 08-09-2015 04:55:47 -0400

Please help. Query 1: Select * from classicmodels.orders where status in (@input_status) During execution I am passing input_status in '(select "Disputed" from classicmodels.orders)' and getting correct result. But .. Query 2: Select * from cla...

Answers: 1

Interpolation Variables