Accessing Spatial Databases in ArcGIS using Query Layers

1
Accessing Spatial Databases in ArcGIS using Query
Layers

• Annie Sasidar and Said Parirokh

2
Road Map
3
Motivation
4
Query Layer at 10.0
5
Query Layer 10.1 onwards
6

• Database or Geodatabase?

7

• Tables spatial types

8

• Tables Spatial types Advanced functionality

9
Alitbase Dameng
SAP Hana
Teradata SQLite
SQL Server Oracle PostgreSQL IBM DB2
Netezza
10
How does connection work?
11
Client setup files
Database Client files Download from
SQL Server Native Client ESRI
Oracle Database Client Vendor
Postgre SQL libpq N/A(shipped with ArcGIS)
DB2 Run-time ESRI
Informix Informix connect ESRI
Netezza ODBC driver Vendor
Teradata ICU library,GSS client package, ODBC driver Vendor
SAP Hana ODBC driver Vendor
Altibase HDB Client Vendor
Dameng DM Client Vendor
12
Database Access

• View Content
• Spatial Data types supported in ArcGIS -gt(
  resources.arcgis.com)
• Non-Spatial search for DBMS data types supported
  in ArcGIS
• 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

13
Summary

• Improved connection user experience
• Discover entity type on opening the spatial class
• Works as a Feature layer in ArcMap
• Use GP tools for analysis
• Publish as map service
• Layer package
• Edit as a feature service from 10.2

14
Resources

• Query Layer
• http//resources.arcgis.com/en/help/main/10.2/inde
  x.html/What_is_a_query_layer/00s50000000n000000/
• Changes in Query Layer
• http//support.esri.com/en/knowledgebase/techartic
  les/detail/41246
• The Evolution of Query Layers(Blog)
• http//blogs.esri.com/esri/supportcenter/2014/04/0
  8/the-evolution-of-query-layers/

15
Related Sessions

• Web Enabling Databases with ArcGIS for Server
• http//geochannel.esri.com/index.cfm?eventvideo.v
  iewchannelId1videoId4773

16
Please take our Survey

• Your feedback allows us to help maintain high
  standards and to help presenters

Find the session you want to review
Find your event in the Esri Events App
Scroll down to the bottom of the session
Answer survey questions and submit
17
Thank you

• Accessing Spatial Databases in ArcGIS using Query
  Layers

• Please fill out the session survey
• First Offering ID 1168
• Second Offering ID 1169