You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by Rob Burgess <ba...@hotmail.com> on 2025/03/13 18:35:56 UTC
Query data on Azure SQL Server database
Hi
Is it possible to query data in a Azure SQL Server database using the authentication type: Microsoft Entra ID - Universal with MFA support?
Thanks
Rob
Re: Query data on Azure SQL Server database
Posted by Bart Maertens <ba...@apache.org>.
[2] ->
https://hop.apache.org//manual/latest/database/databases/mssqlnative.html#_integrated_authentication_windows_based_authentication
On Thu, Mar 13, 2025 at 7:52 PM Bart Maertens <ba...@apache.org> wrote:
> Haven't used it personally, but based on what I read here [1], Entra ID
> could work with the SQL Server integrated authentication [2] in Apache Hop.
> MFA support will almost certainly be a problem, but that would be the case
> anyway in scheduled workflows or pipelines.
>
> [1]
> https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16#connect-sql-server-to-azure-with-azure-ad
> [2]
> https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16#connect-sql-server-to-azure-with-azure-ad
>
> B.
>
> On Thu, Mar 13, 2025 at 7:38 PM Rob Burgess <ba...@hotmail.com> wrote:
>
>> Hi
>>
>> Is it possible to query data in a Azure SQL Server database using the
>> authentication type: Microsoft Entra ID - Universal with MFA support?
>>
>> Thanks
>>
>> *Rob*
>>
>>
>>
>>
Re: Query data on Azure SQL Server database
Posted by Bart Maertens <ba...@apache.org>.
Haven't used it personally, but based on what I read here [1], Entra ID
could work with the SQL Server integrated authentication [2] in Apache Hop.
MFA support will almost certainly be a problem, but that would be the case
anyway in scheduled workflows or pipelines.
[1]
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16#connect-sql-server-to-azure-with-azure-ad
[2]
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16#connect-sql-server-to-azure-with-azure-ad
B.
On Thu, Mar 13, 2025 at 7:38 PM Rob Burgess <ba...@hotmail.com> wrote:
> Hi
>
> Is it possible to query data in a Azure SQL Server database using the
> authentication type: Microsoft Entra ID - Universal with MFA support?
>
> Thanks
>
> *Rob*
>
>
>
>
Re: Query data on Azure SQL Server database
Posted by Hans Van Akelyen <ha...@gmail.com>.
Hi Rob,
I have no experience with this but from looking at the docs you could try
adding the following as an option to the database connection
authentication=ActiveDirectoryInteractive
It might result in having to authenticate for each and every connection we
make though, so let us know how it goes.
Cheers,
Hans
On Thu, 13 Mar 2025 at 19:38, Rob Burgess <ba...@hotmail.com> wrote:
> Hi
>
> Is it possible to query data in a Azure SQL Server database using the
> authentication type: Microsoft Entra ID - Universal with MFA support?
>
> Thanks
>
> *Rob*
>
>
>
>