Register table in external database

ank9
ank9 used Ask the Experts™
on
I need to query a table which is in some external database and not in the database in which repostiory is created.

Is it possible to register such a table and then query it?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
principal solution architect
Commented:
What database are you using?

If Oracle, I believe you can create a db_link to allow your dctm schema access to the external table. Then once your schema has access to the external table, you can just register it as normal.

http://www.dba-oracle.com/t_displaying_tables_schema_database_link.htm



For SQL dbs, you can use three-part names to access external servers:

INSERT INTO MyDatabase1.dbo.MyTable1
SELECT *
FROM MyDatabase2.dbo.MyTable2


You can create a view in your dctm database and then register that view as normal.

Author

Commented:
Thanks for the help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial