Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ingesting on premise data with notebooks

Hi, I have an on premise database with a running PowerBI gateway and this is how we connected to these sources previously. Now, the requierement is that we would recreate our ETL process in Microsoft...
Need Help
pipelines
smeetsh's avatar
smeetsh
Continued Contributor
2 years ago

you should be able to use and on-prem gateway to build a connection to connect to your local sql server. Why would you want a dynamic connection name?

 

The connector we use for this can talk to any DB and its tables, we have given it access to on the on prem sql server. 

PeterDaniels's avatar
PeterDaniels
Advocate II
2 years ago

Asking me "why" is not helpful, but the answer is that I want to use different connections in different environments (dev, test, prod)

  • PeterDaniels's avatar
    PeterDaniels
    Advocate II
    2 years ago

    And...I'm not just connecting to sql server sources. I have a Folder connection

    • smeetsh's avatar
      smeetsh
      Continued Contributor
      2 years ago

      Asking why is very helpful, because I am trying to understand what you want to achieve. We have an identical setup (3 environments) and a folder connection. You will have to use 1 connector for each.

       

       

      • PeterDaniels's avatar
        PeterDaniels
        Advocate II
        2 years ago

        That's my point in my orig post. Dynamic connectors don't work for anything but the 3 fabric data stores.