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

SQL Anywhere 11.0.1 » MobiLink - Server Administration » Using MobiLink Server Technology » MobiLink Monitor


Saving MobiLink Monitor data

You can save the data from a MobiLink 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.

  • Save the data as a binary (.mlm) file if you want to view the saved data in the MobiLink Monitor. To reopen, choose File » Open. The binary file format is the only format that preserves all monitored information.

  • Save the data as a comma separated file (.csv) if you want to view it in another tool, such as Microsoft Excel. This only saves the information in the synchronization properties windows, except per table information and the session end time. You can also open a .csv file in the MobiLink Monitor.

    In the .csv file format, time durations are stored in milliseconds.

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 MobiLink Monitor data using an ODBC connection. You can export to any relational database that is supported by MobiLink, and to a Microsoft Excel spreadsheet.

When you export data, all the columns in your MobiLink Monitor session are exported, and a column named 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 MobiLink 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 fails.

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

  2. In the MobiLink Monitor, choose File » Export To Database.

  3. Select options for the output.

    • You can name the two tables that are created to hold the data, or use the defaults. If the tables do not exist, they are created by the MobiLink Monitor. For Excel output, the two table names identify the two worksheets that are created.

    • Choose whether you want to overwrite data in existing tables. If you do not choose to overwrite the data, new data is appended to existing data.

  4. Click OK to open the Connect window and connect to the database or Excel spreadsheet using ODBC.