Overview
Manu Online DataWarehouse is an extension to Manu Online that exports and keeps up to date your data to an external Microsoft SQL database. This then allows you to run data analysis and visualization tools on your data.
Setup
Setup is a short 3 step process once you have licensed the product from Manu Online. The configuration settings are found under “Admin -> Public Apps”.
- Setup your Microsoft SQL database (other database types are not yet supported) and retrieve the connection string. The connection string will look something like the following: Server=tcp:manuonlinedata.database.windows.net,1433;Initial Catalog=DataWarehouse;Persist Security Info=False;User ID=manuonlinedata;Password=123456;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Connection Timeout=130; Please Note! The connection string must have full rights to the database and it is recommended that other users are limited to Read Only. Manu Online tables will always have their names start with manuonline_
- Under Admin, Public Apps, Datawarehouse you will see the DataWarehouse tile. The configuration page looks like the below:
- Connect your Manu Online through the grey box in the upper section.
- Paste your connection string into the box and select Microsoft SQL (other database types not yet supported)
- Press Save.
- Setup the database ready to sync by pressing the reset button.
Syncing your Data
Initial Sync
When the setup is done, do your first sync by pressing the “Sync Now” button. This will take some time, and the window should be left open while this happens. Progress will be show at the bottom of the page.
Note: This may take a long time if your database is large. If you leave the page or close/log out of Manu online before it is finished, the current category will be finished and you will need to sync again. However, it will pick up from the point it left off.
Help with this phase can always be ascertained from Manu Online support.
Automatic Sync
If you wish for your database to be automatically synced, after the initial sync is done, you can use the “Start” and “Stop” buttons to control this. Once the start button is pressed, the sync will run every 30 minutes and update any new records created after the last sync.
You can stop this at any time. If you press start again, it will pick up any records created since the last sync, even if the service has not been active while those records were created.
If you need to get the data updated faster than the 30 minutes, you can stop the service and press the “sync now” button.