Author Topic: Model View Dashboard SQL Query  (Read 2916 times)

rupertkiwi

  • EA User
  • **
  • Posts: 120
  • Karma: +3/-0
    • View Profile
Model View Dashboard SQL Query
« on: July 13, 2021, 02:35:45 pm »
Hi all,
Is it possible to display data in a Model View on a dashboard using data from another database?

Thanks,
Rupert

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11229
  • Karma: +413/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Model View Dashboard SQL Query
« Reply #1 on: July 13, 2021, 02:40:28 pm »
No, I don't think so.

Geert

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1107
  • Karma: +101/-9
  • Its the results that count
    • View Profile
Re: Model View Dashboard SQL Query
« Reply #2 on: July 14, 2021, 11:13:18 am »
No but you could use MS PowerBI if you have it.
Happy to help
:)

OpenIT Solutions

  • EA User
  • **
  • Posts: 538
  • Karma: +6/-1
    • View Profile
Re: Model View Dashboard SQL Query
« Reply #3 on: July 21, 2021, 04:59:58 pm »
Hi,

Depending upon your database, it might be possible to define a view on your sparx database that selects from another database. Then select from the view on your ModelView. We use SQL Server and this is possible.

Regards,

Jon.