Hi all,
I have to extract data from an application that handles 2 Oracle DB that are linked together using database links. These 2 databases also contain synonyms that refer to remote tables to make writing SQL statement easier.
I have create a DI datastore that points to one of the database. Is it possible to import remote tables metadata (metadata of tables that reside on the other DB) ? When I try, I get an error…
Thanks a lot in advance.
ombo (BOB member since 2005-11-16)
you create a second datastore for the source, then you edit the target database datastore and tell that there is a database link called xxxx.
If you want to see all remote tables in the other database, do not ask for synonyms, ask for views. Synonyms do not have a structure they are just textual replacements and hence cannot be imported.
Werner Daehn 
(BOB member since 2004-12-17)
Hi Werner,
thank you for your input.
I have now 2 datastores. I have set a db link in the advanced properties of the second one that refers to the first datastore.
Now, I want to import metadata for remote tables. I try to import by name using the following syntax : @ but it still doesn’t work… I cannot create views because it’s a production database and I’m not allowed to do anything except select statements.
Any idea ?
ombo (BOB member since 2005-11-16)
You import the table into the source-datastore, but if possible, DI will generate an insert…select statement in the target database facilitating the dblink.
Werner Daehn (BOB member since 2004-12-17)