Accessing the ION Database with 3rd-party applications

The following example uses Microsoft Excel 2007 to retrieve data from the ION_Data database.

NOTE: The database uses Universal Coordinated Time (UTC) time. When you import data into Excel, the Clock module’s Time Zone Offset register for the meter is applied.

1. To create a database query in Excel, click Data > From Other Sources > From Microsoft Query.
2. To create a new data source, select <New Data Source> from the list and click OK.
3. Type the name you want to give the data source. Once you type a name, the list of drivers for the database type becomes available. Select <SQL Server> from the list. Click Connect.
4. Choose your server from the list. Provide your LoginID and Password and click OK. Select a default table for your data source (optional). Click OK to continue.
5. Select the source name you created and click OK.
6. After you have selected the data you want to view, the Query Wizard opens. Use this to filter and sort the data.
7. Follow the steps in the Query Wizard to add data to the spreadsheet.