If you're using Access Analytics you may want to use data from Access LMS Evo in your dashboards.
It's possible to use the Access LMS Evo report API to feed data into Access Data Engine (ADE) using OAuth.
There are four stages to connecting your first report to Access Analytics.
To complete this process, log in as an administrator in Access Evo and a super administrator in Access LMS Evo.
Add authentication user to a report in Access LMS Evo.
Set up a connection in Access Data Engine (one time step).
We've outlined the steps below, along with video walkthroughs to help you through the process.
Set up an authentication user
An OAuth user is a way for Access Data Engine to be able to access the data in Access LMS Evo. You can use the same OAuth user for multiple reports.
To do, this watch this video or follow the step by steps below.
Select System in the menu to expand the options, then click Site Settings.
Click the Application Keys tile, then click Add OAuth Application.
Enter the relevant name for the key, then click OK.
Click the field containing the secret, then copy all text and paste it into a safe place.
📌 Note: This is your only opportunity to do this. Once closed, you won’t be able to access the secret again.
Click Close.
Make a note of the Key name and Key secret, as you will need these later.
Add authentication user to a report
After setting up the authentication user, create your report in Access LMS Evo and ensure that it provides you with the relevant data.
📌 Note: For the integration with Access Data Engine, it's recommended to use a simple report. You can group, sort and filter in Access Data Engine or Access Analytics.
To complete this step, watch this video or follow the steps below.
Switch to admin view.
Click Reporting then select Report Builder.
Search for and select the relevant report.
Click Edit Report, then click the Details tab.
Click Share, then select With specific users.
Click Add Users, then search for and select the relevant user.
This allows your report to be read by Access Data Engine.
Before going any further, you will need to set up a connection in Access Data Engine.
Set up a connection in Access Data Engine
After setting up one connection, you can use the same one for all of your required reports. If you have already set up your connection, skip to the next stage.
To do, this watch this video or follow the steps below.
Launch Access Data Engine from the Access button and click Connect Data.
Click Add New Connection, then select Web Service.
Enter an identifiable name and relevant description for the web service.
Next to Host, paste the URL for your Access LMS Evo site.
Click the Authentication tab, then complete the following fields.
Authentication Type: OAuth 2.0.
Grant Type: Client Credentials.
Access Token Url: https://[DOMAIN]/oauth/token.
Client Id: The OAuth Client ID from Access LMS Evo.
Client Secret: The secret you pasted in the first part of this guide.
Send Authentication: In Head (Basic Auth).
Add Token: In Header.
Click Authorise, then click Save or Next.
Connect your report to Access Data Engine
You can now connect your report to Access Data Engine.
To do this, watch this video or follow the steps below.
In Access LMS Evo
Switch to admin view.
Click Reporting, then select Report Builder.
Search for the relevant report, then right click on it.
Copy the report link.
Before proceeding further, you should paste the link in a safe place to keep a record of it. You'll need the Report ID, contained in this link for the next part of this process.
In Access Data Engine
Open Access Data Engine, then select Tables and Views.
Click Add New, then click the relevant data connection.
Select the General tab, then add a name and relevant description for the data.
Click the Endpoint tab.
Enter into the Endpoint field /api/report/get/[Report ID].
Replace [Report ID] with the report link you copied In Access LMS Evo.
Delete everything in the copied link apart from the report ID.
Select the the Test tab, then click Test.
Select the Node tab, then select the Results radio button.
Select the Preview tab. You should be able to see the output from the report.
Click Save to close the window.
From here you can create views, manipulate data, create insights, dashboards and add security settings.
You can learn how to use Access Data Engine and Access Analytics by completing the following courses, which can be found in Finder in your Access LMS Evo site.
Access Data Engine – Certified
Access Analytics – Certified