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
PeterDaniels's avatar
PeterDaniels
Icon for Advocate III rankAdvocate III
2 years ago

Catching up to this thread. I can use an on-prem DG connection to a Folder in a pipeline, but I can't use a dynamic connection name.  When I choose dynamic connection name, it forces me to use one of three types of connections: Lakehouse, Warehouse, and KQL DB.  I'd like to see the other connection types added.

smeetsh's avatar
smeetsh
Icon for Continued Contributor rankContinued 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
    Icon for Advocate III rankAdvocate III
    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
      Icon for Advocate III rankAdvocate III
      2 years ago

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

      • smeetsh's avatar
        smeetsh
        Icon for Continued Contributor rankContinued 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.