This one is throwing me for a loop, and I hope that somebody here can point me on the right direction.

I'm working on a proof of concept at work. Basically, we have some data being pushed daily to a remote SQL Server. I can connect to it via ODBC and do queries with SQLPro. I want to build a Rails app that reads some of this data and pulls it into HTML tables. So it goes like this:

DB administrator pushes changes to remote SQL Server

Rails app reads data on the server

Rails app translates some of this data into HTML tables

I have a pretty strong grasp on SQL and Rails apps, but am having some trouble connecting the two in my mind.