Register table in external database

ank9 used Ask the Experts™
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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
principal solution architect
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.

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

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

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


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