Accessing Spatial Databases in Arc GIS using Query

Accessing Spatial Databases in Arc. GIS using Query Layers Annie Sasidar and Said Parirokh Esri UC 2014 | Technical Workshop |

Road Map Motivation Supported Databases Connection Database Access Analysis Sharing Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Motivation Desktop Web Device Apps Portal Access / Identity Services Server Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers Online Content and Services

Query Layer at 10. 0 Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Query Layer 10. 1 onwards Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Database or Geodatabase? Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

• Tables + spatial types Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

• Tables+ Spatial types + Advanced functionality Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Alitbase Dameng SAP Hana SQL Server Oracle Postgre. SQL IBM DB 2 10. 0 Esri UC 2014 | Technical Workshop | Teradata SQLite Netezza 10. 1 10. 2 10. 3 10. 4

How does connection work? Arc. GIS DBMS Client Database Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Client setup files Database SQL Server Oracle Postgre SQL DB 2 Client files Download from Native Client ESRI Database Client Vendor libpq N/A(shipped with Arc. GIS) Run-time ESRI Informix connect ESRI Netezza ODBC driver Vendor Teradata ICU library, GSS client package, ODBC driver Vendor Altibase HDB Client Vendor Dameng DM Client Vendor SAP Hana Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Database Access • • View Content - Spatial Data types supported in Arc. GIS ->( resources. arcgis. com) - Non-Spatial search for DBMS data types supported in Arc. GIS - Unregistered tables within a GDB - Dynamic information Database Administration - Add user - Add content Work with layers - Set properties - Analyze Edit tables - Feature Service at 10. 2 Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Summary • Improved connection user experience • Discover entity type on opening the spatial class • Works as a Feature layer in Arc. Map • Use GP tools for analysis • Publish as map service - • Layer package Edit as a feature service from 10. 2 Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Resources Query Layer http: //resources. arcgis. com/en/help/main/10. 2/index. html#/What_is_a_query_ layer/00 s 50000000 n 000000/ Changes in Query Layer http: //support. esri. com/en/knowledgebase/techarticles/detail/41246 The Evolution of Query Layers(Blog) http: //blogs. esri. com/esri/supportcenter/2014/04/08/the-evolution-of-querylayers/ Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Related Sessions Web Enabling Databases with Arc. GIS for Server : http: //geochannel. esri. com/index. cfm? event=video. view&channel. Id=1&video. Id=4773 Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers

Please take our Survey Your feedback allows us to help maintain high standards and to help presenters Find your event in the Esri Events App Esri UC 2014 | Technical Workshop | Find the session you want to review Scroll down to the bottom of the session Answer survey questions and submit

Thank you… Accessing Spatial Databases in Arc. GIS using Query Layers • Please fill out the session survey: First Offering ID : 1168 Second Offering ID: 1169 Esri UC 2014 | Technical Workshop | Accessing Spatial Databases in Arc. GIS using Query Layers