Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Richard Freggi on May 28, 2021, 02:28:45 am

Title: Is it possible to reverse engineer Azure database with EA 13.10?
Post by: Richard Freggi on May 28, 2021, 02:28:45 am

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!

Title: Re: Is it possible to reverse engineer Azure database with EA 13.10?
Post by: Geert Bellekens 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

Title: Re: Is it possible to reverse engineer Azure database with EA 13.10?
Post by: Guillaume on June 01, 2021, 07:23:52 pm

Hi Richard,

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

Title: Re: Is it possible to reverse engineer Azure database with EA 13.10?
Post by: Richard Freggi 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.

Title: Re: Is it possible to reverse engineer Azure database with EA 13.10?
Post by: Modesto Vega 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.