Post reply

Generate report from different sources

  • January 23, 2011 at 3:10 pm

    #233853

    hi

    i have a requirements of generating reports from different sources,like once is sql server and another is oracle.

    How can i take data from both of them and generate report.

    Another is when any underlying data is changed in database,it should trigger the report,How can i accomplish this?

    Anybody has any idea?Any help would be appreciate.

  • January 24, 2011 at 8:03 am

    #1277214

    Do you have the Oracle server Linked at all to the SQL server? If so you should be able to write the query using T-SQL and a 4 part naming convention for the Oracle data. If you don't have a Linked server set up, you should probably start there.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply