nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Finde mehr Beiträge mit dem Tag

Database Access

Databases

Accepted answers

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.

All comments

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.

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.