The AppCan Data Warehouse allows you direct access to your data in the Data Warehouse (SQL database) for use with reporting systems (e.g Microsoft PowerBI).

The following tables are available in the Data Warehouse:

• Document Distributors
• Data Collectors
• Alerts
• Users
• Global Data Fields

Accessing AppCan Data Warehouse

If you require to access the AppCan Data Warehouse, your approved AppCan System Administrator can request the logon credentials from AppCan.  This will provide you with:

• Server Name
• Database Name
• Username
• Password

The above will allow you read-only access to your data.