Rails: Reading data from remote SQL Server db and generating HTML

[AllenCoin]

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:

1. DB administrator pushes changes to remote SQL Server
2. Rails app reads data on the server
3. 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?

[Alex_Kitchens]

Hey Allen!
If that is your only database, then you should be able to configure the database.yml file to the remote server. This StackOverflow may help: http://stackoverflow.com/questions/31153669/connecting-rails-4-with-remote-mysql-database

If it's an additional database, then you can still configure it in the database.yml file, but there's a little more work. This may be helpful for that: http://geekhmer.github.io/blog/2015/02/07/ruby-on-rails-connect-to-multiple-databases-and-migrations/