Hi @Akshay Arukandy ,
Thanks for using Microsoft Q&A !!
You can use SAP BW connector in ADF for Copy and Lookup activities. This connector supports:
- SAP Business Warehouse version 7.x
- Copying data from InfoCubes and QueryCubes using MDX
- Authentication mechanism - BASIC (Username/Password)
Also, this connector is supported through SHIR and you need to install SAP NetWeaver Library which you can either get it from :
- Your SAP Admin or
- Download it from SAP Software Download Center.
- Included in the SAP Client Tools installation.
You can refer to the Copy data from SAP Business Warehouse using Azure Data Factory documentation for more details. Additionally, you can refer to SAP Integration Whitepaper to get details on SAP connector.
Please let me know if you have any other questions.
Thanks
Saurabh
----------
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.