|
Is the Student_ID field of the same data type in both databases? If so, then this won't be too difficult. 1. Create a connection to the SQL Server database and add the appropriate table(s) from there. SQL Server will be the "master" for this report because that's where the student info is located. 2. Create a connection to the Oracle database and add the appropriate table(s) from there. 3. Join the tables together. If the Student_ID field has one data type in the SQL Server database and another in the Oracle database, this won't work. If that's the case, you'll need to set up some sort of link between the two in one of the databases - I know this can be done in Oracle and I suspect it can also be done in SQL Server. I would then set up either a view in the database that will link the data together or use a Command (SQL Select statement) in the report that will join the data together to get ALL of the data that's required for the report. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|