Difference between revisions of "Connecting to IMSMA Staging area from Excel"
From IMSMA Wiki
(3 intermediate revisions by the same user not shown) | |||
Line 22: | Line 22: | ||
'' Wizard pane 3'' | '' Wizard pane 3'' | ||
</div> | </div> | ||
− | <li>First are the views listed and the tables. Scroll until you find the table/view you would like to load into Excel. Select it and click Next. <br/><br/> | + | <li>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. <br/><br/> |
[[Image:Excel data source5.png|500px|center]] | [[Image:Excel data source5.png|500px|center]] | ||
<div align="center"> | <div align="center"> | ||
Line 34: | Line 34: | ||
<li>Select what type and where you would like the data and click OK. <br/><br/> | <li>Select what type and where you would like the data and click OK. <br/><br/> | ||
<li>The data is loaded into Excel. | <li>The data is loaded into Excel. | ||
− | [[Image:Excel refresh.png| | + | [[Image:Excel refresh.png|500px|center]] |
<div align="center"> | <div align="center"> | ||
'' Data tab - Refresh'' | '' Data tab - Refresh'' | ||
</div> | </div> | ||
− | <li>When the Staging area is updated, the data in the Excel will be loaded again when you click on Refresh. | + | <li>When the IMSMA Staging area is updated, the data in the Excel will be loaded again when you click on Refresh. |
</ol> | </ol> | ||
{{NavBox Business Intelligence}} | {{NavBox Business Intelligence}} | ||
− | [[Category: | + | [[Category:NAA]] |
Latest revision as of 21:31, 20 February 2020
The PostgreSQL ODBC driver must be installed and an ODBC source created before loading the data into Excel. |
Data tab - Data Source
- On the Data tab, click on From Other Sources and choose From Data Connection Wizard.
Wizard pane 1
- Choose ODBC DSN and click Next.
Wizard pane 2
- Select your ODBC source and click Next.
Wizard pane 3
- 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
- Enter description and click Finish.
Wizard pane 5
- Select what type and where you would like the data and click OK.
- The data is loaded into Excel.
Data tab - Refresh
- When the IMSMA Staging area is updated, the data in the Excel will be loaded again when you click on Refresh.
|