Author Topic: Custom report on Prolaborate DB content  (Read 4805 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1351
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Custom report on Prolaborate DB content
« on: May 02, 2022, 04:36:23 pm »
Hello,

Is there a way to query Prolaborate database using the custom Reports widgets in v3 or v4 ?

Thanks,
Guillaume
Guillaume

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


OpenIT Solutions

  • EA User
  • **
  • Posts: 555
  • Karma: +9/-1
    • View Profile
Re: Custom report on Prolaborate DB content
« Reply #1 on: May 03, 2022, 06:25:33 pm »
Hi,

Depends on where your prolaborate and sparx repos are stored. I have both on same SQL Server DB. So i can use the following SQL (as an example)

SELECt emailid as name FROM Prolaborate.dbo.users

(where prolaborate is the name of my prolaborate database).

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1351
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: Custom report on Prolaborate DB content
« Reply #2 on: June 10, 2022, 05:41:59 pm »
Thanks, this is very useful !  :D
Guillaume

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


Dah Sra

  • EA User
  • **
  • Posts: 279
  • Karma: +19/-1
    • View Profile
Re: Custom report on Prolaborate DB content
« Reply #3 on: June 10, 2022, 10:00:55 pm »

Is there a way to query the Prolaborate database using the custom Reports widgets in v3 or v4?
 


Hi Guillaume, At the moment only EA resources can be added to the custom reports.


Arshad