I wrote my own R2RML converter using Jena lib. It seemed cheapest and easiest at the time (a few years ago). I have not surveyed current offerings in this space.
Best, --Paul > On Sep 7, 2016, at 14:13, Martynas Jusevičius <marty...@graphity.org> wrote: > > Paul, > > What are you using for R2RML? > > Ontop looks promising: http://ontop.inf.unibz.it/ > >> On Wed, Sep 7, 2016 at 9:11 PM, Paul Tyson <phty...@sbcglobal.net> wrote: >> Yes, I am using R2RML to convert 4 big PLM DBs into RDF, load in Jena TDB >> and serve via fuseki for data mashups and inconsistency reports. Works very >> well. >> >> Best, >> --Paul >> >>> On Sep 7, 2016, at 13:39, Martynas Jusevičius <marty...@graphity.org> wrote: >>> >>> I think R2RML and GRDDL could be of interest to you: >>> https://www.w3.org/TR/r2rml/ >>> https://www.w3.org/TR/grddl/ >>> >>> On Wed, Sep 7, 2016 at 8:00 PM, ☼ R Nair (रविशंकर नायर) >>> <ravishankar.n...@gmail.com> wrote: >>>> Agree, the question is whether an RDF can be created out of the data from >>>> multiple data sources and use it for semantic correlation. That would turn >>>> the world round. In my organization, there are at least a PB of data lying >>>> in disparate sources, untapped because , they are legacy and none knows the >>>> relationships until explored manually. If Jean is not, any suggestions to >>>> manage this? Thanks >>>> >>>> Best, Ravion >>>> >>>> On Sep 7, 2016 1:55 PM, "A. Soroka" <aj...@virginia.edu> wrote: >>>> >>>> Jena is an RDF framework-- it's not really designed to integrate SQL >>>> databases. Are you sure you are using the right product? Does your use case >>>> involve a good deal of RDF processing? >>>> >>>> --- >>>> A. Soroka >>>> The University of Virginia Library >>>> >>>>>> On Sep 7, 2016, at 1:43 PM, ☼ R Nair (रविशंकर नायर) < >>>>> ravishankar.n...@gmail.com> wrote: >>>>> >>>>> All, >>>>> >>>>> I am new to Jena. I would like to query two databases, mysql and Oracle. >>>>> Assume that there are similar columns in both. For example MYSQL contains >>>> a >>>>> table EMP with ENAME column. Oracle contains, say, DEPT table with >>>>> EMPLOYEENAME column. What are the steps if I want Jena to find out ENAME >>>> of >>>>> MYSQL is same as EMPLOYEENAME column of Oracle, ( and so can be joined). >>>> Is >>>>> this possible, at least to get an output saying both columns are similar? >>>>> If so, how, thanks and appreciate your help. >>>>> >>>>> Best, Ravion >>