In my current organization they are archiving old data to external system ( sql database ).But now they have a requirement to generate consolidated  report on both salesforce and sql data.

how to achieve this??