Forum Discussion
Script to create data sources
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.
thanks lbendlin ,
I am leaning towards the same conclusion. Thanks for having a look. Hopefully the API is improved eventually.
Hi, daive
I'm sorry to hear that you've lost hope, and I can see that you've made numerous attempts to resolve the issue.
However, if you feel that performance improvements are needed, you can
submit an idea on https://ideas.fabric.microsoft.com/. This allows other users with the same needs to vote for your idea, helping to expedite its implementation. Many features of our existing products are designed and upgraded based on customer feedback. As demand increases, this issue is likely to be addressed in the future.
Additionally, if you find lbendlin 's response to be an effective alternative, you might consider accepting it as the solution. This not only acknowledges lbendlin's effort in assisting you but also helps other community members with similar issues find solutions more quickly.
Thank you in advance for your efforts and understanding. I hope these suggestions are helpful to you!
Best Regards,
Leroy Lu