Export to Database window

You can save MobiLink Monitor data to any consolidated database supported by MobiLink, or to Excel spreadsheets using the Export to Database window. You must be disconnected from the MobiLink server when you export data from the MobiLink Monitor.

Note

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 quoted identifiers is not enabled, the export fails.

For more information about quoted identifiers, see:

This window has the following components:

Master table   Type a name for the master table created to hold MobiLink Monitor data. The table name must be 128 characters or less. If the table does not exist, it is created by the MobiLink Monitor. For Excel output, the table name identifies the worksheet that is created.

This table contains one row per synchronization, including all the information that can appear in the MobiLink Monitor Details Table pane, and an export_time column that contains the time the export was performed. Its primary key consists of the export_time and sync columns. By default this table is called mlm_by_sync.

Details table   Type a name for the details table created to hold MobiLink Monitor data. The table name must be 128 characters or less. By default this table is called mlm_by_table. If the table does not exist, it is created by the MobiLink Monitor. For Excel output, the table name identifies the worksheet that is created.

This table contains one row per table per synchronization, and has a column for each upload, download, and synchronization statistic that appears on the Synchronization properties window in the MobiLink Monitor, and an export_time column that contains the time the export was performed. The details table has a foreign key relationship to the master table's export_time and sync columns. The primary key for the details table consists of the export_time, sync, and table_name columns.

Overwrite any existing data   Select this option if you want to overwrite data in existing tables. If you do not choose to overwrite the data, new data is appended to existing data.

See also