Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

using ODBC vs. HTML to connect to Denodo

I have a Denodo service which requires a parameter to be specified on the connection.  A HTML connection string looks like this:

 

https://denodo.mycompany.com/path/ServiceIwantToAccess?MandatoryParam=XYZ

 

an ODBC-based connection looks like this:

 

let
Source = Denodo.Contents("DenodoODBC", null),
FOO_Database = Source{[Name="FOO",Kind="Database"]}[Data],
FOO_Schema = FOO_Database{[Name="FOO",Kind="Schema"]}[Data],
ServiceIwantToAccess_View = FOO_Schema{[Name="ServiceIwantToAccess",Kind="View"]}[Data]
in
ServiceIwantToAccess_View

 

I need to pass "MandatoryParam" to the FOO_Schema somehow, but can't find any syntax on it.  I can't use SelectRows as that assumes you've got the table view already.

  • Hi Anonymous ,

    You could try to use parameters to implement it.

    • HTML

    You need to add the entire website in the list.

    • ODBC

    You could change some values with the parameter you created, like the picture. (I used Excel file as the data source.)

    Best Regards,

    Xue

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

    You could try to use parameters to implement it.

    • HTML

    You need to add the entire website in the list.

    • ODBC

    You could change some values with the parameter you created, like the picture. (I used Excel file as the data source.)

    Best Regards,

    Xue

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.