Forum Discussion

angeloola's avatar
angeloola
Helper I
7 years ago
Solved

Use parameter to change data connection types (e.g. Denodo to SQL Server)

So, I've seen tutorials that show how to use parameters to switch between server instances or databases on a server, or to change Excel file paths. They are always using the same source TYPE, however...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi angeloola ,

    Based on my test, you could refer to below code in query editor with if parameters:

    With my sample, I uesed two excel files, you could switch one to your sql query.

     

    Regards,

    Daniel He

     

angeloola's avatar
angeloola
Helper I
7 years ago

Thanks, sure I found that one. It's only toggling between two different instances of a SQL Server connection. I'm looking at how I could possibly toggle the connection TYPE (e.g. from a SQL connection to a Denodo or Excel). If you know of any examples of this I'd love to see them.

 

I spent a lot of time on this forum looking for and answer because there's loads of great solutions here. I wasn't able to find a solution for my specific problem... Any other suggestions would be much appreciated. At this point I'm still stuck on this one.

 

-A

 

 

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi angeloola ,

Based on my test, you could refer to below code in query editor with if parameters:

With my sample, I uesed two excel files, you could switch one to your sql query.

 

Regards,

Daniel He