Data Integration with Plex Online

Posted Sep 28 2012 by Plex Systems in , , , , , , with 0 Comments

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.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s