Author Topic: PowerBI presentations of a PCS Repository  (Read 3363 times)

ea0522

  • EA User
  • **
  • Posts: 134
  • Karma: +5/-0
    • View Profile
PowerBI presentations of a PCS Repository
« on: January 10, 2023, 09:27:46 pm »
Hai,
Currently we are moving from a client based Enterprise Architect environment to a more shared configuration using Pro Cloud Server (PCS).
In the 'old' environment, I managed to have PowerBI access the information in the EAPX/QEAX files to present a dashboard with statistics.
Any suggestions on how to connect PowerBI to the PCS repositories?
Thanks.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: PowerBI presentations of a PCS Repository
« Reply #1 on: January 10, 2023, 09:41:59 pm »
There seems to be a lot of confusion about what PCS actually is. This is because the name "Cloud" is a bit misleading.

PCS is a server component that sits between your EA repository database (.eap, .quea, SQL Server, ...) and the client installed on your local machine.
There is no "Cloud" as we all know it involved (e.g. full SaaS)
So the "shared configuration" you are talking about won't happen because of PCS.

Your repositories haven't changed. They are still there.
PCS only provides an alternative way for your EA client (still locally installed) to connect to your databases.
Ask the people who installed PCS where your model databases are, then connect to them like before.

Geert

ea0522

  • EA User
  • **
  • Posts: 134
  • Karma: +5/-0
    • View Profile
Re: PowerBI presentations of a PCS Repository
« Reply #2 on: January 10, 2023, 10:54:43 pm »
Thanks for the quick reply Geert.

What you mean is to get access to the eap or qea file directly located on the server? Via some sort of file access?

There is no need to use the OSLC type connection?
I was under the impression that the OSLC connection via HTTPS was necessary to have secure access.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: PowerBI presentations of a PCS Repository
« Reply #3 on: January 10, 2023, 11:03:29 pm »
Thanks for the quick reply Geert.

What you mean is to get access to the eap or qea file directly located on the server? Via some sort of file access?

There is no need to use the OSLC type connection?
I was under the impression that the OSLC connection via HTTPS was necessary to have secure access.
Yes. You'll have a hard time getting the info you need usin OSLC.
You should also consider changing to a real database such as SQL Server or MySQL (or... as long as it's not Oracle). That will make allowing access for PowerBI easier.

Geert