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
