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.
Do you know what underlying DB brand it is? Or did they create their own from scratch? (If the former, that brand's JDBC driver might work.)
Thanks for the response!!
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.
Plex UX only exposes an ODBC connection through a Progress DataDirect ODBC driver for Windows, downloadable from Plex. Unfortunately, you need a Plex UX account to view or download the files.
Following the directions on the Plex website, I was able to establish the ODBC connection to Plex.
I am currently working with a company called CDATA that supplies a JDBC-ODBC bridge. While I don't have the connection working just yet, the path seems promising.
We created linked server on SQL that allows us access Plex data through the normal SQL server adapter.