Re: [topbraid-users] How does the D2RQ wizard select its tables when use with Oracle?

[Scott Henninger]

Thank you Tim;   This sounds like a reasonable enhancement request.  Probably not for 4.4, but perhaps after that.  Will get it into the list and keep you updated. -- Scott On 1/27/2014, 10:29 AM, Tim Smith wrote: 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 <shennin...@topquadrant.com> 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 topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com 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 topbraid-users+unsubscr...@googlegroups.com. 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 topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com 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 topbraid-users+unsubscr...@googlegroups.com. 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 topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com 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 topbraid-users+unsubscr...@googlegroups.com. 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 topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com 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 topbraid-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.