Page History
...
Retrieving UIM data in Excel 2007: Creating a new database connection
Follow these steps to To establish the Uptime Infrastructure Monitor UIM DataSource as an external data source for use in Excel 2007:
- Start Microsoft Excel 2007.
- Open the Data Connection Wizard : on the Data by going to the Data tab, and in the the Get External Data group, click From Other Sources, then click > From Data Connection Wizard. The Data Connection Wizard appears
...
- .
- Select Select ODBC DSN as the type of data source you want to use to make a connection, and then click click Next.In the next Wizard step, select the Uptime Infrastructure Monitor
- Select the UIM ODBC data source, and then click click Next. The name of the data source in the list is the name you gave the
...
- UIM DataStore when you created its profile in the ODBC Data Source Administrator
...
- control panel.
- In the next step, select a database and specific table from the data source:.
The database name you select is the name you gave to the up.time UIM DataStore when you you created its profile in the ODBC Data Source Administrator Control Panel control panel. The database table you select depends on the type of Uptime Infrastructure Monitor UIM data you want to import into Excel (in this example, we are importing aggregate performance data). - In the final Wizard step, remember the the FriendlyName assigned to this connection profile, and then click click Finish to save the database connection profile.
| Info |
|---|
...
Now that you |
...
created an Office database connection (.odc) file for the |
...
UIM database and specified table, you |
...
can use this existing connection to perform new database queries in future Excel sessions (on the Data tab, in the Get External Data group, click Existing Connections, then select the connection by clicking the Friendly Name). When you begin to work with data using an existing connection, |
...
Excel prompts you with the Import Data dialog box, which you can use to modify your database query. |
When you create a connection to the Uptime Infrastructure Monitor UIM database for the first time, you will always be are prompted with the Import Data
dialog box; this dialog box is described in the next section.
...