How get the D2L data from the cloud to DW on premise (SQL Server)
Fernando.L.669
Posts: 3 🔍
in Development
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.
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.
Answers
-
Hi Fernando,
I would recommend connecting with your Customer Success Manager. They would be able to provide more detail on what data integrations options are available and could help connect you with the right internal team to answer your questions!
Cheers,
Bronwen
