Connecting to IMSMA Staging area from Excel

From IMSMA Wiki
Jump to navigation Jump to search
The PostgreSQL ODBC driver must be installed and an ODBC source created before loading the data into Excel.

Data tab - Data Source

  1. On the Data tab, click on From Other Sources and choose From Data Connection Wizard.

    Wizard pane 1

  2. Choose ODBC DSN and click Next.

    Wizard pane 2

  3. Select your ODBC source and click Next.

    Wizard pane 3

  4. First are the views listed and then the tables. Scroll until you find the table/view you would like to load into Excel. Select it and click Next.

    Wizard pane 4

  5. Enter description and click Finish.

    Wizard pane 5

  6. Select what type and where you would like the data and click OK.

  7. The data is loaded into Excel.

    Data tab - Refresh

  8. When the IMSMA Staging area is updated, the data in the Excel will be loaded again when you click on Refresh.

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:Business Intelligence|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:Business Intelligence|}}}}{{#if:Install Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation|{{#if:Business Intelligence|}}{{#if:|}}{{#if:Staging Area Generator|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if: IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area|{{#if:Business IntelligenceInstall Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation|}}{{#if:IMSMA Staging Area|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:Business IntelligenceInstall Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area|}}{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Other Reporting Tools|{{#if:Other Reporting Tools|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if: Introduction to indicators|{{#if:Indicators|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:Business IntelligenceInstall Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area|}}}}
{{{above}}}
{{{imageleft}}}
Staging Area Generator
{{{image}}}
IMSMA Staging Area
{{{group3}}}
{{{list3}}}
Other Reporting Tools
Indicators
{{{group6}}}
{{{list6}}}
{{{group7}}}
{{{list7}}}
{{{group8}}}
{{{list8}}}
{{{group9}}}
{{{list9}}}
{{{group10}}}
{{{list10}}}
{{{group11}}}
{{{list11}}}
{{{group12}}}
{{{list12}}}
{{{group13}}}
{{{list13}}}
{{{group14}}}
{{{list14}}}
{{{group15}}}
{{{list15}}}
{{{group16}}}
{{{list16}}}
{{{group17}}}
{{{list17}}}
{{{group18}}}
{{{list18}}}
{{{group19}}}
{{{list19}}}
{{{group20}}}
{{{list20}}}
{{{below}}}
{{#switch:|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:connecting to imsma staging area from excel 

|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Connecting_to_IMSMA_Staging_area_from_Excel&oldid=24445"