Authentication Dynamics 365 fin&ops with MFA in ETL(SSIS) package

(1) Share

Report

Posted on by Lefteris Papadopoulos

Hello,

As you know, Microsoft will mandatorily implement mfa(Multi factor Authentication) for all users.
I built ETL packages, with connection via user, to directly read data from d365.

how can I will be able to do authentication with mfa for the user in Integration services or if I can integrate Auth0 Authentication in etl package as web app?

Thanks you in advance.

I have the same question (0)

All responses (2)

Answers (0)

Anthony Blake 2,977 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Lefteris,

Could you expand on how you are connecting to D365 to retrieve data? Are you pulling from OData entities do you know?

You should hopefully be able to switch Authentication to using a Service Principle, using an App Reg and Client Secret.

Was this reply helpful? Yes No
Lefteris Papadopoulos 53 on at

Like (0)

Report
Copy link

Link copied!

Hi Anthony,

Yes I'm pulling from odata entities. Until now, I use the connection Microsoft Dynamics AX Online as the image below.
If you see the note tells that not support multi-factor authentication/

How can I authenticate as web app and client secret the etl? I couldn't find that option.

Was this reply helpful? Yes No