Access Outside Database from within Rails

Question

I need to access data in an MS SQL database from a rails app.

The MS SQL database is maintained by our contractors, we just need to access data from it.

Is there a way in rails that I can access an outside db (not the main rails db)?

I can write my own SQL queries, I just need to open a connection to that outside db.

I'm on Rails 3.2.1

Thanks

ashoda · Accepted Answer · 2012-02-16 23:54:12Z

1

Check out Connection Ninja , it's pretty straight forward and easy to use.

answered Feb 16, 2012 at 23:54

ashoda

2,8801 gold badge16 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1