We just completed the data migration from Teradata system to Azure SQL DW. Now we just need to provide necessary access to all supporting Teradata Users and Service accounts to Azure SQL DW. For this i have some basic query:
All the accounts/Users are of domain type,so can i use Azure Active directory to set up those accounts and configure it to have access Azure SQL DW. Please let me know the process.
What kind of privilege/Access is needed in Azure Portal for creating those account within Azure Active Directory.
In Azure SQL DW how do i add Azure AD account to specific roles that i'll be creating. How the authentication will happen here.
Let me know if the above steps is feasible. Is there any alternative approach in providing on-prem User accounts access to Azure SQL DW
If you're migrating to Microsoft SQL DW, not Teradata database on Azure cloud, then you are much more likely to get an answer on a Microsoft forum.