Display data from another SQL DB under device status. integration questions.

TLG IT 6 years ago

So here's the situation,
Imagine I have a dispatch software application that lives on a MSSQL db.
I can look at dispatched calls, matching a device ID to a "user" then that has a "CallID" then I can go ask another table for the rest of the records matching that "CallID"
I'd like to have this information displayed under the "state" when I click on that device. i've made the devices match the username in the other database so that lookup operation will be simple, I assume. Any advice to guide me in the right direction would be stellar.
Thanks so much

Anton Tananaev6 years ago

You can't do it through database. State information is coming directly from devices and stored in memory on the server.

TLG IT 6 years ago

Well, I don't want to touch Traccar's database. I want to use the web/backend to grab data from another MSSQL database and just display it in the web form "state" field.

Anton Tananaev6 years ago

You would need to write some java code for that.