Download D2L data to on-premise SQL Server

Fernando.L.669

Hello, I was ask to come up with high level approach to pull data from D2L-Cloud data to a on premise SQL Server database, and need to understand how much work is involved.
What components do I need to integrate for a smooth data transfer.
What are my options:
1) Can the D2L be scheduled to perform data sets exports to an on-premise location
2) Can the D2L be scheduled to perform data sets exports to cloud location, I would have a on-premise process to get the zipped file with data sets
3) Can the On Premise Power BI tools read directly from D2L cloud

The idea is to download the D2L data sets and load it in a SQL Server database and integrate it with an existing HRMS database.

Thanks in advance

Chris.S.534

Hi Fernando,

At a high level there are 4 common approaches:

1. Manually download the datasets
   
2. Build a Middleware App to download the datasets
   
3. Your BI tool makes the API calls to download the datasets
   
4. Clients leverage the Brightspace Performance+ package, in particular the Insights Report Builder. See
   1. https://community.d2l.com/brightspace/kb/articles/4680-about-performance
      
   2. https://community.d2l.com/brightspace/kb/articles/5951-about-insights-report-builder

Options 1-3 would require workflows to:

• download the full or differential datasets from Brightspace
  
• unpack & preprocess the data if required
  
• load the data directly/indirectly to your BI tool/DB

If the Brightspace Performance+ package is not available to your institution please contact your D2L Customer Success Manager/Account contact for additional information.

The short answer to all 3 questions is a No, your App/BI tool can achieve these outcomes leveraging the Valence API's. The following resources will be helpful in your discovery:

• https://community.d2l.com/brightspace/kb/articles/1102-getting-started-with-brightspace-api-automation
• https://community.d2l.com/brightspace/kb/articles/1130-how-to-get-started-with-data-hubs-apis-brightspace-data-sets
• https://docs.valence.desire2learn.com/reference.html

Hope that helps!