From Talend 7.1 there is support for ADLS but this requires additional integration with Azure Databricks. Azure Databricks is a consumption-based Spark managed service that simplifies processing of Big Data and Artificial Intelligence workloads. The component is - tAzureFSConfiguration . Blog post. But there is another way - using Powershell. Use tSystem to execute Powershell script which would export ADLS item. The export command would download a file. Once the file is downloaded to your Talend server you could use the requisite tFileInputXXX commands to read from the file and then use tMSSqlOutput components to write to database.
