User and Application Service account setup in Azure SQL Datawarehouse

Teradata Database on Azure

User and Application Service account setup in Azure SQL Datawarehouse

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

Thanks

kavyasahu
1 REPLY
Highlighted
Teradata Employee

Re: User and Application Service account setup in Azure SQL Datawarehouse

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.