Although I am an experienced developer, I am new to rails and enjoying
how easy it is to build applications.
I seem to have come across a stumbling block and was wondering if
anyone out there has come across the same problem and could suggest
I have an intranet-based application in a company network - using
rails. The application has many sub-applications which may be composed
of a handful of pages each.
The web application has its own database using MySQL which contains
all application specific data, however, I need to retrieve data from
different sources which maybe, MSSQL, Oracle or Sybase databases.
For example, I need to access a well establish Sybase database server
which contains trade data so I can create a summary of daily Profit &
Loss - after filtering, various calculations I will archive this
summary data in the Applications MySQL DB for performance views
In rails how do I do this neatly, rails is designed to use one
Would anyone be able to suggest ways in which I can access such data?
Many thanks in advance.