Skip to main content

Updating the Datawarehouse Export Service

The datawarehouse export service is a service that exports data from the main EWA database to a datawarehouse database. The datawarehouse database is used for reporting and analysis purposes. The datawarehouse export service is a Windows service that runs on the EWA server. The service is configured to run automatically when the server starts.

Before any updates to the datawarehouse export service can be made, the service must be stopped. This is done by opening the Windows Services application and stopping the service named "Bliksund EWA Data Warehouse Export" or uninstalling it completely. The service will also stop exporting records if the export configuration with type ReportingDb is disabled in Insight or the EWA database.

Updating the datawarehouse export service​

The service is updated by simply copying the installer for the new version of the service to the EWA server and running it. See the Installation guide for more information about installing the datawarehouse export service.

Resetting export statuses in the EWA database​

In the scenario where the new update to the datawarehouse export service includes a new migration or any change to the database schema, the service will automatically re-export/update the existing datawarehouse records and apply the changes defined in the update, on the next start up.

If the update to the service did not include any changes related to the database schema, to ensure that all records in the datawarehouse database are re-exported/updated, the export statuses in the JournalExportStatus table in the EWA database must be reset manually. This can be done by deleting the old export configuration for the ReportingDb type and recreating it in Insight, or by running the following SQL script towards the EWA database:

-- DELETE ALL EXPORT STATUSES WITH TYPE REPORTINGDB
DELETE FROM [dbo].[JournalExportStatus]
WHERE [ConfigurationId] IN (
    SELECT [Id]
    FROM [dbo].[ExportConfigurations]
    WHERE [Type] = 4
);

FAQ​

How do I know if the datawarehouse export service is running?​

The datawarehouse export service is a Windows service. This means that it can be found in the Windows Services application. The service is named "Bliksund EWA Data Warehouse Export".

How do I know if the datawarehouse export service is working?​

The datawarehouse export service writes export statuses to the JournalExportStatus table in the EWA database. If the service is working, the JournalExportStatus table will contain records with ConfigurationId from a configuration that has the type ReportingDb. The JournalExportStatus table can be queried using the following SQL script:

SELECT * FROM [dbo].[JournalExportStatus]
WHERE [ConfigurationId] IN (
    SELECT [Id]
    FROM [dbo].[ExportConfigurations]
    WHERE [Type] = 4
);

How do I know if the datawarehouse export service is exporting records?​

The datawarehouse database will contain records if the datawarehouse export service is exporting records.