This content has been marked as final. Show 5 replies
don't know if your problem is solved.
But if not, if you want to use a table from a different database you have to create a new module (e.g. MOD_1) which is pointing to the database and the schema, for e.g Source datasource xxx/yyy .
OWB creates a location with the needed informations. You should find them under Locations Navigator --> Locations --> Databases --> Oracle
Import your table you want to use in a mapping in this module (via design center).
Now you can create a mapping in your Module (e.g. MOD_2) which is pointing to target data source aaa/bbb.
Here you can drag and drop the table to the mapping designer.
When you deploy the Mapping owb will create a dblink. This dblink can be found under the location which belongs to MOD_2 (DB Connectors).
Hope this helps.