Data warehouse

Description

Our data warehouse connection app allows you to export a summarised copy of your data to an external SQL server. The external server can be used for your own reporting tools and for data security. It can be a cloud server on your own account or a physical server in your own location. The data is updated at less than 30 minute intervals.

Benefits

1. Keep a copy of your critical business data under your own control.
2. Build online business reports with whichever tool that you choose to use.
3. If using Manu Online portal then embed PowerBI reports back into your Manu Online screens.

Getting started

1. Ensure that you have the Manu Online Data Warehouse app licensed on your account.
2. Set up a SQL server of your own. For instance, use Azure or Amazon cloud services. Alternatively, have a physical server that can be accessed over the internet from the Manu Online data
3. In Admin – Integrations, choose the Data Warehouse til
4. Connect the app to your Manu Online account. It is recommended to create a new user with email to handle this connection and that user needs to have API rights.
5. Enter a valid SQL connection string that must be accessible from the Manu Online data centre over the internet.
6. Press Start to start syncing. If you have a lot of data in your database, then the first sync can take a considerable amount of time.