{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/a2da3fe4b19d4177a895b765adf2dc68\" frameborder=\"0\" width=\"1110\" height=\"832\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":832,"width":1110,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":832,"thumbnail_width":1110,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/a2da3fe4b19d4177a895b765adf2dc68-cc2240f7f1dc94f7.gif","duration":1088.044,"title":"CommCare Data Pipeline via DET","description":"In this video, I walk you through the process of setting up a robust data pipeline using ComCare to connect our data to external sources like an Azure MS SQL database. I demonstrate how to create a case export and generate a Data Export Tool (DET) configuration file, which is crucial for understanding which fields to export. I also cover the installation of the DET and how to create a connection string for the SQL database. Once set up, I show how to execute the export command and confirm that the data has been successfully populated in the SQL database. I encourage you to refer to the documentation for further clarification and to reach out if you have any questions."}