Forum Discussion
Script to create data sources
great questions. Make sure to be precise when you say "connections" - you seem to be working on gateway connections, not semantic model connections.
The recovery key has nothing to do with connections, it is only needed when you add or modify gateway cluster members.
You are saying all your SQL sources use Service Principals for authentication> Where are you migrating to?
lbendlin ,
My goal is to create managed connections. We are busy with a tenant migration (consolidation of multiple tenants into one).
According to script 2 i need to run script 1 first so that is why I am referencing data gateways. But my goal.is to create the managed connections which use the gateway to connect to data. In my case all connections are sql based. The MS documentation on creating datasources seems light on info so these scripts looked great but I am unable to get a result, likely either me misunderstanding the requirements or formatting the body of the REST call.
So looking for some help forming the script to achieve my goal
Personal, biased, subjective opinion: Don't waste your time. Set up the connections from scratch in the new environment. The entire connections API is half baked and very temperamental. A true time sink.
