Hi Scott, Since many of our databases enable select access to multiple schemas, we often end up with 100's or 1000's of tables in the current wizard. Most of the time we would like to select tables from one or two schemas. I think the most flexible use case would be:
1. Log into the database per the current wizard 2. The wizard displays a list of all schemas to which the user has access. 3. The user selects the schemas they are interested in. 4. The wizard then displays only tables owned by the selected schemas. 5. Processing continues as currently designed... Being able to filter by schema would make TBC run much faster and selecting the right tables much easier in cases where there are 1000s of tables. Thanks for considering an enhancement request! Tim On Sat, Jan 18, 2014 at 9:18 AM, Scott Henninger <[email protected] > wrote: > Tim; Currently the wizard will return all schema information that are > accessible by the authenticated user specified in the wizard. There is no > attempt to address ownership, but we can add that to an enhancement list. > Perhaps a use case will help us create a well-defined enhancement ticket > that we can look into. > > -- Scott > > On 1/17/2014, 4:30 PM, Tim Smith wrote: > > I'm trying to understand how the D2RQ wizard determines what tables and > columns to show in the "Select tables and columns" window when used with an > Oracle database. > > While I have several use cases in this area, one common one is to be able > to limit the choices to only those tables "owned" by the user provided to > the wizard. > > The current wizard seems to select all tables the user can "see" in the > Oracle data dictionary. In my case, this can be 10,000+ tables the user > must deal with in order to get the 10-100 tables they are interested in and > it makes the wizard perform very slowly. > > Is there a way to restrict/filter the listed tables by schema owner, > preferably before displaying them for selection? > > Thanks, > > Tim > -- > -- You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid > Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- > -- You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include Enterprise > Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid > Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/topbraid-users?hl=en > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
