Re: [topbraid-users] SQL TO RDF

[Scott Henninger]

In addition, the help file for D2RQ mapping is at TopBraid Composer Help > > Working with Data Back Ends > Working with Relational Databases > Importing Relational Databases with D2RQ.  A D2RQ server is included in the TopBraid Composer-ME and the wizard will help you pick which tables and columns you want to view. -- Scott On 9/16/2014, 9:35 AM, Scott Henninger wrote: Maarary; To be clear, TopBraid Live is not needed for this conversion.  You can use TopBraid Composer-ME. The D2RQ wizard is a good choice, and one the DataView mapping is opened you can yse EXport > Export/Merge/Convert RDF Graphs to copy the data into an RDF file. For a  SPARQLMotion solution, the sml:IterateOverSQL module will iterate through the result set of a SQL query, which can then be converted to RDF with an ApplyConstruct (basically a SPARQL CONSTRUCT query), etc., module. Documentation on this can be found in TopBraid Composer Help > Reference > SPARQLMotion Library Reference.  There is also a useful section on our home page:   http://www.topquadrant.com/technology/sparqlmotion/ -- Scott   On 9/16/2014, 7:58 AM, Mark Graham wrote: Hi Maarary. I missed your specific SQL reference. There is ‘import relational data using D2RQ’ wizard in TBC that is relevant.  When possible - please also review here: http://www.topquadrant.com/2010/02/12/how-to-read-triples-from-a-relational-database/ Thanks, Mark On Sep 16, 2014, at 8:27 AM, Mark Graham <m...@topquadrant.com> wrote: Hi Maarary, You can create an SDB connection file to your DB in TBC and create a SPARQLMotion script. You can find much detailed information in the TBC help file and at this page that should help you to get started http://www.topquadrant.com/knowledge-assets/product-documentation/ Thanks, Mark On Sep 16, 2014, at 12:53 AM, Maatary Okouya <maatarioko...@gmail.com> wrote: HI, as part of a project that i'm running for an organization i have the requirement to convert some SQL data and RDF. These RDF data shall be store in a semantic database from which they will exposed as linked data.  The semantic database is fixed and i have to use it.  Hence i need an approach to routinely convert the SQL data in RDF and update my database with it.  Is there a way that TopBraid can help me with these kind of task ?  I red somewhere that SPAQRLMOTION could help with it.  However i can't get a hold on the right documentation. MoreOver it sounds like more TBC Mastro we will have to get TOPBRAIDLive, to run sparqlMotion Script.  In short, what support TopBraid Provide for converting SQL to RDF. Is it a one time thing, or there might be a way to do it routinely ? -- -- 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/d/optout. -- -- 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/d/optout. -- -- 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/d/optout.