Suggestions for Developing Reports App Using Rails

Hi there guys,

I’m in the need of developing an application to generate reports based
on a legacy database.

Has anyone played in this area before? Any suggestions on how this can
be accomplished using Rails? Gems, tools, etc?

Oh, the data store is an Oracle Database, which I think doesn’t really
matter as the framework is agnostic.

Thanks,


Jos Tiburcio Ribeiro N.
[email protected]

2011/3/23 Jos Tiburcio Ribeiro N. [email protected]:

Hi there guys,

I’m in the need of developing an application to generate reports based on a
legacy database.

Has anyone played in this area before? Any suggestions on how this can be
accomplished using Rails? Gems, tools, etc?

Oh, the data store is an Oracle Database, which I think doesn’t really matter as
the framework is agnostic.

If you google for
rails legacy database
it will give you some good links on how to handle a legacy db. If you
are only reading the db then with luck there will be no great
problems. It can be more tricky if you have to write to the db also.
set_primary_key will probably appear regularly in your models, as will
foreign_key in the relationships.

I would start by just setting up the models for the db tables and
relationships and write some automated tests to make sure that you are
able to read the data ok. Then go on from there.

Colin