Has anyone had experience using JDBC to connect directly to the PLEX UX underlying SQL Server? Plex exposes an ODBC interface but Ignition is Java based so only the JDBC interface is available.
I'm already using web services to retrieve some data from PLEX, but in a few cases no datasource is available for the data I'm looking for. Since PLEX can accept SQL queries, I can easily create a named query to retrieve the data. Just stuck on getting past the JDBC / ODBC bridge.
It’s actually MS SQL Server.
I’m trying to get information from Plex as to the URL and instance name.
So far, they are telling me that Plex is only ODBC and not JDBC compatible.
Knowing that the Ignition JDBC for SQL Server works just fine for all my other projects, not sure what the difference would be here.
I am able to connect using web services (httpPost) and send/receive OK. But Plex responds with HIGHLY convoluted JSON. It'd be a lot easier to get to the DB directly.
Definitely more a SQL Server than Ignition one but short answer is yes.
Going off my memory but basically, when you set up a linked server you have to give a login for the server to login to the linked server. On your linked server you would set the permissions of that login to SELECT statements only or Read Only access, I forgot how it's phrased. You can get a better answer at a DB focused forum.
If there is a DBA involved in the system, consult with them they can probably do it quickly for you.