I am not exactly clear what Ravion is trying to do but wondered if D2R Map might help
https://sourceforge.net/projects/d2r-map/ It would require setting up two D2R config files that each mapped one of the database into a common RDF model On 9/7/16, 2:39 PM, "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