Post

4 followers Follow
1
Avatar

Querying SQL Server Data and Displaying In Podio

We have data in a SQL Server database that we'd like to simply display to our Podio users. We'd love the ability to allow them to add filters as well to further dig into the data. Our SQL Server is on the internet and able to be contacted by Podio with the right user/password.

Is this possible?

Josh Jones

Please sign in to leave a comment.

3 comments

0
Avatar

More info: Our plan is to create a simple VIEW in SQL Server and only allow this one view to be visible to a certain SQL Server username and password. Then, we were hoping that Podio would have a way to add this SQL Server with it's username and password as a datasource and then pull the data from this VIEW and simply display it with the aforementioned filters, etc.

Josh Jones 0 votes
Comment actions Permalink
0
Avatar

Hi Josh,

There is no out of the box way to achieve this but you can make an API integration with Podio to run the view query periodically and insert the data to a Podio app. Once the data is inside Podio in proper structure you can use filters and all other Podio functionality. We have done this many times for our clients and its a straightforward task to do. Check here for the Podio API documentation https://developers.podio.com/

There is also ready made solutions available with Zapier and Simego.
https://zapier.com/zapbook/podio/sql-server/
https://www.simego.com/products/podio

Best Regards,
Anz
http://phases.dk/en

Ansar Muhammad (Anz) 0 votes
Comment actions Permalink
0
Avatar

To integrate SQL Server data with Podio take a look at Skyvia. It is a code-free web service with powerful mapping and flexible scheduling options.

Irvin Welsh 0 votes
Comment actions Permalink