NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | Prerequisites: the The [[Installation ODBC driver | PostgreSQL ODBC driver]] must be installed and an [[Create ODBC source | ODBC source]] createdbefore loading the data into Excel.}}
[[Image:Excel data source1.png|500px|center]]
'' Wizard pane 3''
</div>
<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]]
<div align="center">
<li>Select what type and where you would like the data and click OK. <br/><br/>
<li>The data is loaded into Excel.
[[Image:Excel refresh.png|300px500px|center]]
<div align="center">
'' Data tab - Refresh''
</div>
<li>Click on Refresh to read When the IMSMA Staging area is updated, the data from in the databaseExcel will be loaded again when you click on Refresh.
</ol>
{{NavBox Business Intelligence}}
[[Category:VIENAA]]
