Hazus | Connect to a SQL Database in ArcGIS

Hazus | Connect to a SQL Database in ArcGIS


[ upbeat music ] [ sound effects ]
boom, whoosh, drip, splash, sparkle [ upbeat music fades in ] Welcome to the “Connect to a SQL Database
in ArcGIS” video tutorial. In this video, you will learn how to establish
a SQL connection to a Hazus database in ArcGIS Desktop and use that connection to access
Hazus data. For this process, you do not need to use the
Hazus program, just ArcGIS Desktop. This is a useful method to query and manipulate
your data outside of a Hazus scenario or study region. This is similar to accessing the data in SQL
Server Management Studio, but through the familiar functionality of ArcGIS. Creating a database connection using ArcCatalog or ArcGIS Pro can be done using similar steps to those shown in this video. [ upbeat music ] Begin by opening ArcGIS Desktop. The first step in creating a database connection
from ArcGIS Desktop to your desired Hazus SQL Data is to click the “catalog” button
to open the catalog panel. Expand “Database Connections” and click “Add
Database Connection.” A dialog box will appear for you to identify
the type of database connection you would
like to make. In the Database Platform dropdown, select
“SQL Server.” To help with the remainder of the steps, it
may be useful to open the Hazus settings.xml document located in your Hazus installation
files C:Program Files (x86)Hazus-MH as this contains information for creating database connections and is a useful resource. Next you will need to select your instance,
which means the name and location of your Hazus SQL Server data. Type in “localhost/HAZUSPLUSSRVR” to access your locally-stored Hazus data. Typing in “localhost” tells the software to
search for the server on your computer, rather than on a server or remote location, and “HAZUSPLUSSRVR” is the default installation location for Hazus’s SQL server. In some cases, the Hazus server will need
to be accessed not through “localhost,” but through a Server Name that you can find in
the settings.xml document. Next, select “Operating System Authentication”
from the “Authentication Type” dropdown. Finally, use the last dropdown to select the
database within the server that you would like to connect to. This list will populate with default, general
Hazus databases and with your study regions, scenarios, and statewide datasets. Once you have selected your desired database,
click “OK.” If the authentication does not allow you to
connect, you must instead select “database authentication” and use the database credentials found in the settings.xml document or by emailing the Hazus help desk at
[email protected] [ upbeat music ] The database connection will appear in the
Catalog under “Database Connections.” Expand the newly-connected database to view
the different datasets stored within. If you would like, you can edit the name of
the database connection directly in the catalog panel. Now you can view data in the map by selecting
and dragging it into ArcMap and activating it in the “Layers” window. Once a layer is active, you can use the “Identify” tool to click on data points and gain further information. Congratulations! In this video you learned how to establish
a SQL connection to a Hazus database in ArcGIS Desktop and use that connection to access Hazus data. Look for more Hazus video tutorials on the
FEMA YouTube channel. [ upbeat music fades out ]

Danny Hutson

Leave a Reply

Your email address will not be published. Required fields are marked *