Hello Jeff; Note that if you save the password in the mapping file, the password is saved in plain text. That won't pass many organizational security requirements.
You should not have to re-enter the password each time as the password will be saved in secure storage. The next time you open the file, TBC/ TBL will check secure storage for the password (secure storage encrypts the password) and automatically use that. It should be transparent to the user. Secure storage should be set up on install of TBC, TBL, and EVN. If that's not the behavior you're getting in TBC, then you may want to check your secure storage settings in Preferences > General > Security > Secure Storage. -- Scott On Jan 5, 9:21 am, "Schmitz, Jeffrey A" <[email protected]> wrote: > Just a follow up to this, as I spent some time on this same issue this > morning. I'm confused as to why the wizard doesn't store the password in the > Mapping model, thus requiring you to re-enter the password yourself the next > time you go to open the D2RQ database, which isn't an entirely obvious thing > to figure out. Is this a "bug", or by design? > > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:topbraid- > > [email protected]] On Behalf Of Scott Henninger > > Sent: Tuesday, November 15, 2011 11:12 AM > > To: TopBraid Suite Users > > Subject: [topbraid-users] Re: D2RQ Questions > > > Tim; Some responses below: > > > << Along the way the wizard asks me for a password > > to setup the secure storage which is no problem.>> > > > Secure storage will encrypt the password to the database you specified > > in the D2RQ wizard. > > > << At this point I create a new owl file, > > import the schema and dataview and expect to be able to view > > instances.>> > > > I would suggest editing the -Mapping file, then re-open the original - > > dataView file. It will read the mappings again, so there is no need > > to create a new .owl file. The -Schema file should also be edited to > > remove schema elements that are not needed. > > > The mapping wizard does create a schema for the entire database. We > > will have an improved interface for this in 3.6 that allows you to > > choose the tables and columns you need to generate the mapping file. > > > <<However the file never really opens all the way, it appears to be > > caching > > the instance data, perhaps? Should it take a really long time? The > > database is large. Millions of rows in a number of tables. I'm just > > wondering what is normal.>> > > > If there are a lot of class definitions, i.e. a lot of classes, or a > > lot of properties, then it may indeed take a long time to cache all of > > the model information in the Composer UI. These are all stored in the > > -Schema file, so you can open that directly to see if that is the > > issue. You can control what model data gets cached in Composer through > > Preferences > TopBraid Composer > 'Prebuild caches for properties'. > > This controls what properties are loaded when initializing the UI. > > > No instance data will be cached, unless you ask the UI to cache > > instance data by, for example, opening the instance view for a class. > > The number of instances cached can be controlled in the 'Max number of > > instances to display' attribute in the same preference area. > > > <<I can no longer open the dataview file due to a failed > > connection/ "Missing password" error.>> > > > The password is stored by the D2RQ wizard and associated with the URL > > of the .d2rq connector file. The best practice is as stated above, > > create the mapping files from the wizard and edit those directly. > > Thus the password is assured to be associated with the connector file. > > > Let us know how that works and in particular what actions in the > > Composer UI are particularly slow. BTW, if you open the -dataView > > file in a SPARQLMotion file, it will not cache any data from the > > schema or database back-end until a SPARQL query is submitted. > > > -- Scott > > > On Nov 15, 11:13 am, Tim Smith <[email protected]> wrote: > > > Hi, > > > > I'm using D2RQ for the first time and I have some questions. > > > > First, I run the import to generate an auto-map of the database > > structure. > > > This seems to work fine. Along the way the wizard asks me for a > > password > > > to setup the secure storage which is no problem. > > > > When I try to open the Dataview file, there are a number of errors > > relating > > > to unsupported datatypes (BLOBs, etc...) Not really a problem as I > > can > > > delete them from the mapping file. At this point I create a new owl > > file, > > > import the schema and dataview and expect to be able to view > > instances. > > > However the file never really opens all the way, it appears to be > > caching > > > the instance data, perhaps? Should it take a really long time? The > > > database is large. Millions of rows in a number of tables. I'm just > > > wondering what is normal. > > > > I created a new mapping file that points only to one small table to > > test > > > with but I cannot test it due to the problem below... > > > > Secondly, after completing the above steps, I exit TBC and restart. > > At > > > that time, I can no longer open the dataview file due to a failed > > > connection/ "Missing password" error. I do not know how to specify > > the > > > password to the database. I thought this would be stored in secure > > storage > > > and retrieved when necessary but I do not know how to do that. How > > do I > > > specify the password? > > > > Thanks for your help, > > > > Tim > > > -- > > You received this message because you are subscribed to the Google > > Group "TopBraid Suite Users", the topics of which include TopBraid > > Composer, > > TopBraid Live, TopBraid Ensemble, SPARQLMotion 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 Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion 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
