Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » MobiLink Monitor

Synchronization properties Next Page

Saving Monitor data

You can save the data from a Monitor session as a binary file (.mlm), as a text file with comma-separated values (.csv), as tables in a relational database, or as a Microsoft Excel file.

Saving to file

To save the data as a file, choose File > Save As.

You can specify that you want data to be saved automatically to a file. To do this, choose Tools > Options, and enter an output file name on the General tab. The output file is overwritten by new data.

Exporting to a relational database or Excel

You can also export Monitor data using an ODBC connection. You can export to any relational database that is supported by MobiLink, as well as to Excel.

When you export data, all the columns in your Monitor session are exported, as well as a column called export_time that identifies the time the export was performed. Data from the graph is not exported.

The data source must have quoted identifiers enabled, because some of the columns are reserved words. The Monitor enables quoted identifiers automatically for SQL Anywhere, Adaptive Server Enterprise, and Microsoft SQL Server databases. If the quoted identifiers option is not enabled, the export will fail.

To export the data to a database or Excel
  1. After collecting Monitor information, disconnect from the MobiLink server.

  2. In the MobiLink Monitor, choose File > Export to Database.

    The Export to Database dialog appears.

  3. Select options for the output.

  4. Click OK.

    A Connect dialog appears that allows you to connect to the database or Excel spreadsheet using ODBC.