SQL Registered Server via Database Connection in ArcPro

JLopezDV

I have a group of Registered Servers in SQL Server Management System with over 20 servers that I can query at once. I would like to be able to connect to those servers from ArcPro. I am able to connect to the servers individually in Pro using Database Connection and Connection Properties. Is there a way to connect this group of Registered Servers?

DavidSolari

There's no real equivalent to that on the ArcGIS side, but you can use Create Database Connection with some Python to quickly get connection files made to every database, then play around with the managed index settings so you can quickly find the feature classes and tables you need to search through. Running queries on multiple databases simultaneously isn't something you can do out of the box, you might be able to write a geoprocessing tool with Python that can apply a query to multiple tables at once but it'll take some custom work.

View solution in original post

DavidSolari

There's no real equivalent to that on the ArcGIS side, but you can use Create Database Connection with some Python to quickly get connection files made to every database, then play around with the managed index settings so you can quickly find the feature classes and tables you need to search through. Running queries on multiple databases simultaneously isn't something you can do out of the box, you might be able to write a geoprocessing tool with Python that can apply a query to multiple tables at once but it'll take some custom work.

JLopezDV

Thank you, David, that is solid advice. I will look at the managed indexes to help out with performance. Having multiple SQL Server connections in ArcPro was something I was trying to avoid due to performance issues, as this is going to be a Web Map. Thanks again!

DavidSolari

If you're doing editing workflows on this data you can look into the ETL tools for your database to mirror a query as a standalone table, and then push changes back to the databases as needed. That way you can edit data while also keeping it appropriately warehoused. Not the best situation but it can work.