Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Nov 2000 @ 18:17:49 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Teradata equivalent to Oracle Public Synonyms
 
From:   Dave Ahnell

We are in the process of converting several Oracle databases over to Teradata v2.3. We use a front-end data access tool, Business Objects, which requires a repository database to store its internal objects. The user heirarchy created in Teradata is:

     dbc
        sysdba
           repositorydb
           db1
           db2
           ...

The issue we're facing is end users must connect to the repository and then their query is run against one of the databases (db1 or db2, etc). Thus the default database for the end users is required to be "repositorydb". This is forcing us to append the database owner to each object within the data access tool (e.g. db1.tableA). It also forces the administrator for the data access tool to be changing their default database depending on what they are doing.

With Oracle this could all be handled on the database side through the use of Public Synonyms (e.g. db1.tableA is aliased as tableA).

I'm wondering how others using Teradata may be dealing with this issue.

David Ahnell
EDS E.solutions Business Intelligence Services



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016