Connecting to ArcMap 10

One of my customers, Morehead City, is messing around with GIS and ZonePro so I asked if they would send me their steps for making the connection and they were kind enough to do so. Here is what they sent:

ArcMap 10.3
- ArcCatalog -> Database Connections -> Add Database Connection
- In the dropdown box, select “SQL Server”
- Enter server and database information from Zone Pro -> “OK” (ZP Systems can give you this info.)
- Drag and drop the “vBuildCombo” database (for building permits) and/or “vViolateRep” database (for violations) from Database Connections in ArcCatalog to the table of contents in ArcMap
- Identify a unique identifier (e.g., “parcel” field) ->Click Finish
- Add the layer to the map which contains the parcel identification number. Use the layer to create a relate:
- Right click the layer -> “Joins and Relates” -> “Relate” ->
- #1 Select the field which contains the parcel number from the drop down box.
- Make sure #2 contains the correct table.
- #3 Select “parcel” from the dropdown box.
- Click “OK”

To see the connected information, click the identify tool and select a property. Identify from the layer that is connected to the Zone Pro tables. If permit activity exists, you will be able to see it by clicking the “+” sign under the layer name.

It looks like this: