I need to transfer data from an Azure SQL database in Tenant A to another Azure SQL database in Tenant B using Azure Data Factory. I want to use Service Principal authentication without relying on client secrets.
I've already tried Managed Identity, but it doesn't support cross-tenant authentication.
Could you advise if there are any alternative methods to configure the linked service across tenants without using secrets?