Author Topic: Is it possible to reverse engineer Azure database with EA 13.10?  (Read 8063 times)

Richard Freggi

  • EA User
  • **
  • Posts: 493
  • Karma: +18/-7
    • View Profile
My database has MFA authentication and seems like the EA default SQL Server drivers don't support it.  Does anyone know if suitable driver can be obtained and how to install for EA reverse engineering?  Cheers!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Is it possible to reverse engineer Azure database with EA 13.10?
« Reply #1 on: May 28, 2021, 03:25:09 am »
as long as you have an ODBC connection to your database it should work.

If you can't get it to work like that you might want to export your database structure to SQL create statements, and then recreate the structure locally.
That's what we do with databases we don't have direct access to.

Geert

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1374
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: Is it possible to reverse engineer Azure database with EA 13.10?
« Reply #2 on: June 01, 2021, 07:23:52 pm »
Hi Richard,

Have you tried using the "Microsoft OLE DB Provider for SQL" driver ?
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Richard Freggi

  • EA User
  • **
  • Posts: 493
  • Karma: +18/-7
    • View Profile
Re: Is it possible to reverse engineer Azure database with EA 13.10?
« Reply #3 on: June 01, 2021, 07:51:41 pm »
Thanks for advice Geert and Guillame, this database needs MFA authentication, which I don't think is available with the drivers I have access to.  But I'm doing OK using SQL Server Studio, so no issue.

Modesto Vega

  • EA Practitioner
  • ***
  • Posts: 1145
  • Karma: +30/-8
    • View Profile
Re: Is it possible to reverse engineer Azure database with EA 13.10?
« Reply #4 on: June 11, 2021, 01:26:24 am »
When you connect to the server using SMSS, are you using Azure Active Directory - Universal with MFA authentication? - please see https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview.