Results 1 to 3 of 3

Thread: Virtual Database

  1. 05-09-2009, 05:41 PM #1
    zik
    zik is offline Registered User
    Join Date
    May 2009
    Posts
    1

    Virtual Database

    Hi there,
    I work for a university as a application support and developer. Part of my work involves creating ad hoc reports where the data comes from many different databases, for example, Oracle, DB2, MS SQL Server, etc.
    I am using Agua Data and it is a good tool to connect to different databases within one tool. But Aqua Data can’t make database links and I have to manually create database links. I wonder if there is a tool out there that can connect to many databases and creates some sort of virtual database where you can write sql statements to join tables from different databases, for example, SELECT * FROM ORACLEdb1.TABLE JOIN DB2db1.TABLE without me creating a database link. Your help will be appreciated.
    Reply With Quote Reply With Quote
  2. 05-10-2009, 02:25 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    In sql server, you can connect to other rdbms with linked server feature.
    Reply With Quote Reply With Quote
  3. 05-19-2009, 10:31 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    your reporting tool should have the capability of accessing many heterogenous datasets

    Most of the RDBMS have feature like sql server linked server. you could leverage any of the RDBMS for that
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules