I've got a few different databases - 2 that hold archive data and 1 that holds current working application data.
The 2 archive databases hold tables for quality assurance and are extremely large datasets, but they are not part of the working rails application. The way that it works is that I need to query data in the 2 archive databases before I run a job in the rails app. If the 2 queries don't bring back the expected results, I don't want to run the job.
What is the best way to set up the connections to run the queries in the 2 archive databases prior to running a job in the rails app? Do I need to create separate models for the archive queries? If so, how do I make sure to tell my controller to run those before running the job? Or does this all fit into the model that runs the job with these queries running first? If so, how do I query the other 2 databases?
Thanks once again for the amazing help!
