How to Set Up a Dedicated Reporting Database

Download the tyGraph External Job .ZIP file here.
Open the App Service that hosts your tyGraph harvester, and navigate to the WebJobs section:
Click the "Add" button.
Give the new job the name "tyGraphExternalJob", select the ZIP file you just downloaded, set the Type to "Continuous", and the Scale to "Single instance". Finally, click "OK":
Next, navigate to the Configuration section of the App Service:
Click the "New application setting" button, and add the following:
- Name: tyGraphExternalJob:Pipeline:Default
- Value: { "CopyScale": "S3", "DestinationUpScale": "S3", "DestinationDownScale": "S3", "DestinationErrorScale": "S0", "DestinationPool": " ", "WaitForAvailability": 1, "SqlCopy": 1 }
Click the "New application setting" button, and add the following:
- Name: tyGraphExternalJob:PipelineConfig:Default:SqlServer
- Value: <YOUR TYGRAPH SQL SERVER FQDN>
Click the "New application setting" button, and add the following:
- Name: tyGraphExternalJob:PipelineConfig:Default:SqlUser
- Value: <DBA USERNAME>
Click the "New application setting" button, and add the following:
- Name: tyGraphExternalJob:PipelineConfig:Default:SqlPassword
- Value: <DBA PASSWORD>
Click the "New application setting" button, and add the following:
- Name: tyGraphExternalJob:PipelineConfig:Default:SourceDatabase
- Value: <TYGRAPH DATABASE NAME>
Click the "New application setting" button, and add the following:
- Name: tyGraphExternalJob:PipelineConfig:Default:DestinationDatabase
- Value: <TYGRAPH DATABASE NAME>_reporting
Press the "Save" button and then press "Continue".
Open your tyGraph database in SSMS or another SQL query tool, and run the following command: UPDATE [tgAppCore].[EngineConfiguration] SET StageReportingType='external'
The new reporting database will appear after one complete cycle of the tyGraph harvester.