Reporting Database

Introduction

The Reporting Database app gives you direct, read-only access to your Joblogic data, allowing for advanced reporting, analysis, and dashboard creation using your preferred BI tools.

With full visibility of our database schema—including a detailed data dictionary and relationship mapping—you can confidently build your own reports and understand how data flows across the system.

The app provides the tools you need to unlock the full potential of your Joblogic data.

Important information

• Access to the Reporting Database is limited to data provisioned by Joblogic and is subject to our internal data governance policies.
• You will need to download and install SQL Server Management Studio (SSMS) or a compatible SQL tool to access the reporting database.
• Your IP address must be whitelisted to gain access. Please send your IP address to our Support Team for assistance.

Why Use the Reporting Database App?

📚 Understand your data: Access a full data dictionary with field names, types, and descriptions
📊 Build powerful reports: Create custom dashboards
🔐 Read-only security: Access is restricted to viewing data—no risk of changes to live records
⚙️ Join with confidence: Reference pre-mapped table relationships to ensure accurate queries
🧠 Get smarter insights: Use structured data to drive better operational, financial, and service decisions

Data Dictionary

For the full data dictionary and table joins, please click here.

Further Support

For further information or assistance with the above, contact our Support Team on 0800 326 5561 or email support@joblogic.com. Alternatively, our Customer Success Management team can be reached by emailing customersuccess@joblogic.com

Publishing Details

This document was written and produced by Joblogic’s Technical Writing team and was last updated on the date specified above. Be aware that the information provided may be subject to change following further updates on the matter becoming available. Additionally, details within the guide may vary depending on your Joblogic account’s user permissions.