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.
Does anyone know of some tutorials or gems I should look into?