There is also a special mxd-file, ''staging.mxd'', that contains the IMSMA symbology and has Data Source set to a PostgreSQL database called '''staging''' for all layers. You find the ''staging-MM-DD-YY.mxd'' in C:\IMSMAETLTool\data.
[[Image:Repair broken links SA.png|200px|center]]<div align="center">'' The red exclamation mark indicates that Data Connection is broken''</div>If your IMSMA Staging area database is called something else than '''staging''', you need to rebuild the Data Source links for each layer. On ESRI's ArcGIS Resource Center you will find [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000020000000| instructions] on how to '''Repair broken links for multiple layers'''. Choose <ol><li>Right click on e.g. Lands - Generic - Land Polygon and choose Properties in the menu.</li><li>The following window will open. </li>[[Staging_Area_Database#Geographical_data_in_the_IMSMA_staging_areaImage:Create DataConnection staging0.png|500px|GIS viewscenter]] (e<div align="center">'' Layer Properties''</div><li>Go to tab Source. </li><li>Click on '''Set Data Source'''.g</li>[[Image:Create DataConnection staging. HAZARD_POLYGON_VIEWpng|500px|center]]<div align="center">'' The connection type is Database''</div><li>If you not already have a Database connection to your Staging area database, ACCIDENT_POINT_VIEWyou need to create one first. Double-click on ''Add Database Connection''.</li>[[Image:Create DataConnection staging1.png|500px|center]]<div align="center">'' Define the Database connection''</div><li>Fill in server name, etcuser and password. </li><li>Select the database and click OK.</li>[[Image:Create DataConnection staging2.) as sources png|500px|center]]<div align="center">'' Specify Database Connection''</div><li>Back in the staging Data Source window, double-click on the Database Connection. </li>[[Image:Create DataConnection staging3.png|500px|center]]<div align="center">'' Define the Database connection''</div><li>Select the corresponding view, in this example hazard_polygon_view. Click on '''Add'''.</li><li>Back in Layer Properties window, click on '''OK'''. </li><li>Now all other broken links to your Staging areadatabase should be repaired too.</li></ol>
{{NavBox Business Intelligence}}
[[Category:VIE]]