1 / 25

Output Tools

Getting Data Out of Corporate Applications:. Output Tools. The Great Integrators. Busam 4/28/2009. Two Types of Tools. Output Tools Published Data (Data Analysis and Reporting). Input Tools Transactional Data (Data Capture). Input Tools. Designed for Data Entry

Olivia
Download Presentation

Output Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Getting Data Out of Corporate Applications: Output Tools The Great Integrators Busam 4/28/2009

  2. Two Types of Tools OutputTools Published Data (Data Analysis and Reporting) InputTools Transactional Data (Data Capture)

  3. Input Tools • Designed for Data Entry • On-Line Transactional Processing (OLTP) design • Normalized Database to minimize repeated data • Tuned for performance • NOT Designed for Data Extraction! • Complex retrieval queries • Complex joins needed to find data • Fewer indexes means fast data entry but slow retrieval • Complex and heavily technology driven • A world of its own…

  4. Input Tools • NRM Products – I-Web (Infra, FACTS, TIM, and NRIS) • Some Products have a Spatial ArcGIS Interface for input • Accessed through Citrix • Product Information • http://fsweb.nris.fs.fed.us/products/index.shtml • http://basenet.fs.fed.us/ • NRIS Data Exchange Tools (DEX) • Bulk loads existing electronic (legacy) data into NRIS (tabular and spatial) • Available for TESP, Invasive Species, Plant Survey, Vegetation point data (ocular macroplot, cover frequency, and line intercept), and Wildlife • Coming Soon! - Aquatic Survey and Map Units • Portable Data Recorders (PDRs) • Bulk loads field collected data into NRIS (FSVeg and IS/FACTS only)

  5. For every Input there is an Output

  6. OutputTools A Cast of Characters • A Variety of applications provide data from a variety of locations for a variety of uses or… • Data Entered Once, Used Many Times… I-Web User Views Geospatial Interface (GI) Tabular Characters I-Web MS Access/Excel Tool Corporate Data Warehouse (CDW) Spatial Characters

  7. Geospatial Interface (GI) • The Geospatial Interface (GI) is an ArcMap extension • Simple user interface – GI toolbar has 4 buttons • Users don’t have to know where the data is • Integrates spatial and tabular data • Displays layers using preset symbols • Can load multiple layers at once • Includes maps, queries, reports, and GIS analysis • One click export to Excel, Access, Word, or text file

  8. General GI Overview ALP TIM/FACTS Fire Apps NRIS Forest Servers Geospatial Interface End Users Simple access to their data

  9. Geospatial Interface (GI) • GI products are available for national applications • Custom products that combine data from several sources can be made • Works in Citrix or from Desktop ArcGIS • Set-up and maintenance of GI connections are centrally managed • (requires GI manager training) • On-line and virtual training sessions available

  10. GI Sneak Peek

  11. I-Web Corporate Data Warehouse (CDW) • I-Web CDW - Storage for Read-only, historical, aggregated data from I-Web • Easy to use - “Flat and Fat” –summarized data • Data presented in many different ways • Feature classes, reports, views • OLAP (On-Line Analytical Processing) • Query across multiple units

  12. CDW Continued • Three ways to retrieve data • I-Web CDW Discoverer Interface (national reports) • SDE Connection - PC or Citrix ArcGIS/Arc Catalog • Geospatial Interface (best for spatial access) • CDW Products documented in the FS GIS Data Dictionary • National/Regional extents • Iterative Development Strategy

  13. Oracle Content DB Enterprise File Structure SDE ArcGIS Server Transactional Oracle Tables Transactional SDE Published CDW Oracle Tables & SDE EDC I-Web Citrix I-Web and EDC

  14. CDW Sneak Peek

  15. I-Web User Views • Provides tabular corporate data for export to Excel • Accessed through the I-Web Dashboard • Tabular only • Allows queries across units • More flexibility than Standard Reports • Allows users to choose fields, sort, and write SQL query statements to retrieve specific records • Available for numerous NRM applications

  16. I-Web User View Sneak Peek

  17. I-Web Access/Excel Tool • I-Web add-in toolbar for Microsoft Access and Excel applications • One time desktop download and set up • Connect to the I-Web database • Provides tabular database returns • Explore database tables and views • Load data into Access and/or Excel • Data can be downloaded as a snapshot of the data or linked to always show current data

  18. I-Web Access/Excel ToolSneak Peek

  19. Output Summary • Once data are obtained from an Output Tool, the data can be used with other data to perform analyses. • GI – ArcGIS Extension that provides access to outputs and data from a wide variety of data sources (PC Client or Citrix) • I-Web CDW – I-WEB Data Storage Environment for Fat, Flat, and National/Regional Data, Accessed through ArcGIS or ArcCatalog (Citrix Recommended!) or I-Web CDW (National Reports only) • I-Web User Views – I-Web tool to provide tabular, summarized data in Excel, Accessed through I-Web interface (Citrix or Web) • I-Web Access/Excel Tool – I-Web add-in for MS Excel/Access that allows a user to link or grab data from the I-Web tables through Access or Excel on their PC

  20. Getting HELP! • Business Application Service Environment (BASE): http://basenet.fs.fed.us/support/helpdesk/ • Use base to suggest additional outputs! • ASK NRIS! (Tues. and Thurs.) • http://fsweb-drm.r6.fs.fed.us/administration/newsletters/dr-data/2008/08/news-ask-nris.php • I-Web Training Calendar: http://basenet.fs.fed.us:8085/training/iweb_training/ • GI Training - http://fsweb.gac.fs.fed.us/geoteam/v200/training.html • NRIS Outputs Web Page: http://fsweb.nris.fs.fed.us/outputs/index.shtml • GIS Coordinator Cheat Sheet: http://sforge.fs.fed.us/sf/docman/do/downloadDocument/projects.nris_transformation/docman.root.outputswebpage.how_to/doc12120

  21. Questions?

More Related