<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/a2da3fe4b19d4177a895b765adf2dc68&quot; frameborder=&quot;0&quot; width=&quot;1110&quot; height=&quot;832&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>832</height><width>1110</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>832</thumbnail_height><thumbnail_width>1110</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/a2da3fe4b19d4177a895b765adf2dc68-cc2240f7f1dc94f7.gif</thumbnail_url><duration>1088.044</duration><title>CommCare Data Pipeline via DET</title><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.</description></oembed>