You need the AirWatch DataMart Installer to receive this feature. You can configure the AirWatch DataMart Installer to run an Extract, Transform, and Load (ETL) job daily to export data as a CSV file or as a cube (CUB) for your SQL Server Analysis Services (SSAS).

For on-premises deployments, the DataMart is installed on your AirWatch database server according to settings you configure when you install the application. You can install AirWatch DataMart on the AirWatch database server or any server from which the AirWatch database is accessible.

Note:

Dedicated SaaS deployments receive a data mart in only .csv format and can access it in their specified folder from the AirWatch secure FTP location. If your company is interested in this feature, contact your AirWatch Account Services Manager.

To run the AirWatch DataMart:

  1. Run the DataMart installation executable file and select Next.

  2. Read the End-User License Agreement, accept the terms to use the feature, and then select Next.

  3. Select Change if desired, navigate to a destination folder where you want to place the installer log, and then choose Next.

    Note:

    If you export to a separate network location, the destination folder must be accessible to the SQL Agent service.

  4. Ensure the database server to which you are installing DataMart is correct.

    Note:

    This is the AirWatch database and not the reporting database.

  5. Select Browse and navigate to the AirWatch Console SQL instance if needed.
  6. Select Windows authentication credentials of current user.

  7. If you have enough rights to update the database before you continue with the installation, a warning message appears.

    RandA_DMI_DtbsSrvr_Warnmsg

  8. Select OK. You are directed to the Tenant DB Information screen.

  9. Configure the source database for DataMart.

    • Tenant DB Server – Enter the name of the SQL server hosting the AirWatch database.

    • Tenant DB Name – Enter the name of the AirWatch database.

    • Tenant Name – Enter the name of the tenant (used for reference in the DataMart database).

    • Tenant Root LG – Enter the root organization group ID of the tenant for which you are installing.

      1. On-premises installations normally enter 7 (Global).

      2. SaaS installations enter the root organization group ID (normally the ID of the organization group with the group type of customer).

      RandA_DMI_TenantDB

  10. Configure the following Publish Options for DataMart:

    • Load Frequency – Select Daily or Hourly as the frequency for publishing data.

    • Report Option – Select CSV or Tables as the format for the exported data.

    • Browse to drop folder – This option allows admins to browse to the folder that has the CSV files. On-premises installations should use this option.

    • Map a drive – This option allows admins to specify a drive path and drop folder. Dedicated SaaS installations should use this option.

      • Drive Letter – Specify the letter of the drive to be mapped.

      • Drive Path – Specify the drive path. Do not specify the client folder in this path.

      • Client Drop folder – Specify the client drop folder. The folder name must not contain spaces.

        Browse to drop folder option Database Table to Database Server option
        RandA_DMI_PblshOpt01 RandA_DMI_PblshOpt02

         

        Map a drive options
         
        RandA_DMI_PblshOpt03 RandA_DMI_PblshMapDrv
  11. Select Install to begin installation.

  12. Select Finish to exit the installation wizard.

After the installation finishes, the process creates two SQL Server Agent Jobs that run daily at midnight or hourly. DataMart creates applicable exports in the specified folder.