By David Shugars, Senior Software Engineer
At Plex Systems, we are often asked about integrating on-premise data with data in Plex Online. We hear questions like: “Plex Online exists in the cloud. I get that. But I have systems that I need to integrate with Plex Online. Is it possible to integrate with data in the cloud?”
It is always a joy for me to tell people: “Of course you can integrate with Plex Online data!”
In this blog post, we’ll look at two different types of integration: ODBC and Web Services.
ODBC offers users the ability to write industry-standard Structured Query Language statements to integrate with Plex Online. Simply install a small ODBC driver on your client computer, configure the driver, configure the client application and then send the queries to the Plex Online databases. Most of the tools don’t require that the user even see the query being sent. The tool will do that for you.
Below is a screenshot of Plex Online data integrated into Microsoft Excel. I simply selected the table from Plex Online that contained the data that I wanted, selected the fields that I wanted and Microsoft Excel did the rest. I did all of this in less time than it will take you to read this blog post!
To continue reading, click here.