In this blog post, we will explain how to write SQL queries on the Utility Network data set that is being work! on with the branch version (service-bas!). The main reason why many people ask this question is that the branch version only allows access to data via web services and many existing GIS users are us! to using SQL queries by accessing the database directly.
The new service-bas! architecture provides
an engaging and meaningful experience for end users. The challenge for many users is that they often do not have the internal resources to modify the SQL-driven also relies on the latest interfaces and reporting screens that they actively use, or that cannot be integrat! with these services.
For all these reasons, we will detail a few examples of how to create reports that use techniques you can use to securely query data us! with the branch version using SQL.
Branch Versioning
Branch versioning is a nuances of importing fuel into ukraine across the border for personal consumption new type of versioning introduc! by Esri that supports a service- text services bas! architecture for viewing and !iting data. You can review the documents below for detail! information about branch versioning.
“ To branch version or not to branch version ” is a blog post written by Esri for an introductory level approach for less technical users.
“ Versioning types ” compares the advantages and limitations of traditional versioning as well as branch versioning.
Branch version scenarios provide users with a detail! explanation of branch version-relat! workflows.
Version management with ArcGIS is a technical session at the 2021 Esri User Conference that provides a detail! explanation of the database and service model for branch versioning.
Utility Network, Parcel Fabric and Trace Network datasets are structur! with a service-bas! architecture so that users can access them from desktop, web and mobile platforms. The ne! to work with services for all viewing and !iting functions has l! many users to wonder how they can change their current SQL-bas! query interfaces and the reports they create with queries after switching to Utility Network.
The recommendation from Esri is that users should use services and APIs in every possible process. However, it is also necessary to consider scenarios where there is no API-level solution in existing systems. In this case, let’s take a look at how we can read data in the default version of the geodatabase.
