Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: demian824 on July 19, 2023, 05:56:32 am

Title: [Ask]Use data from Power BI with Sparx
Post by: demian824 on July 19, 2023, 05:56:32 am

Hello Professors,

Is there any way to use / sync data from Power BI?

Thanks,

WonChul Choi

Title: Re: [Ask]Use data from Power BI with Sparx
Post by: ea0522 on July 19, 2023, 03:39:20 pm

Yes there is.
Although this is a very generic question.
The connection to the EA repository depends on the type of repository you use.
In my case, I use a QEA file as repository and therefor I had to install a SQLite3 gateway for PowerBI to be able to connect.
For other types, it might be sufficient to use an OData connection type or connect to the EA database directly.

Title: Re: [Ask]Use data from Power BI with Sparx
Post by: Richard Freggi on July 19, 2023, 03:56:02 pm

Hello ea0522
I understand from your post that you are able to import EA model metadata from *.qea file into Power BI
Would like to know if you are able to reverse engineer a Power BI data model into EA?  Thanks...

Title: Re: [Ask]Use data from Power BI with Sparx
Post by: ea0522 on July 19, 2023, 07:09:58 pm

Hai Richard,

Not quite sure what you mean with:

Quote

Would like to know if you are able to reverse engineer a Power BI data model into EA?

I don't know the internal Power BI data model and frankly, I don't care ;)
To me this question seems as any other question on how to use EA to reverse engineer an application or handle a database model.
As in "How would you manage data model of application X as defined in database Y?".
And there should be more than sufficient manuals and tips to be found.