Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Kingsley Idehen
On 12/16/10 3:59 PM, Lars Marius Garshol wrote: * Kingsley Idehen I am sure you understand that as a fundamental principle, OpenLink implements standards whenever such exist. If standards don't exist and a problem persists, we innovate. If standards emerge later, we support immediately. What I

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Lars Marius Garshol
* Kingsley Idehen > > I am sure you understand that as a fundamental principle, OpenLink > implements standards whenever such exist. If standards don't exist and a > problem persists, we innovate. If standards emerge later, we support > immediately. What I wrote was not meant as criticism of

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Kingsley Idehen
On 12/16/10 8:42 AM, Lars Marius Garshol wrote: * Hugh Williams What are the remote database(s) you are seeking to virtualize data into Virtuoso from ? To begin with we're looking at an ERP system known as IFS. However, there will likely be 2-3 more systems in the first iteration. We envision

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Lars Marius Garshol
* Hugh Williams > > What are the remote database(s) you are seeking to virtualize data into > Virtuoso from ? To begin with we're looking at an ERP system known as IFS. However, there will likely be 2-3 more systems in the first iteration. We envision separate Virtuoso databases serving SDsha

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Hugh Williams
Hi Lars, What are the remote database(s) you are seeking to virtualize data into Virtuoso from ? The docs page you found below details whats happening at the lower level, but the materialization of the views can also be performed using the Virtuoso conductor with the following steps :

Re: [Virtuoso-users] Upload rdf file from isql

2010-12-16 Thread Kingsley Idehen
On 12/16/10 7:38 AM, Pierre-Yves wrote: Hi Hugh, This is what I do: $ /usr/libexec/virtuoso/isql virtuoso Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (ODBC), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> DB.DBA.RDF_LOAD

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Kingsley Idehen
On 12/16/10 7:20 AM, Lars Marius Garshol wrote: * Mark James The commercial version of virtuoso has a 'virtual database' capability. You can create tables within virtuoso that are links to tables within other rdbms. It's then possible to create rdf views and either materialize the triples or q

Re: [Virtuoso-users] Upload rdf file from isql

2010-12-16 Thread Mitko Iliev
Hi Pierre, The relative path base is the server working directory i.e. in the place where virtuoso.ini file is, and since your file is on desktop server can't find it unless full path is given. Best Regards, Mitko On Dec 16, 2010, at 2:38 PM, Pierre-Yves wrote: > Hi Hugh, > > This is what I

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Lars Marius Garshol
* Mark James > > The commercial version of virtuoso has a 'virtual database' capability. You > can create tables within virtuoso that are links to tables within other > rdbms. It's then possible to create rdf views and either materialize the > triples or query the rdbms data directly. Thank y

Re: [Virtuoso-users] Upload rdf file from isql

2010-12-16 Thread Pierre-Yves
Hi Hugh, This is what I do: $ /usr/libexec/virtuoso/isql virtuoso Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (ODBC), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('/home/

Re: [Virtuoso-users] Upload rdf file from isql

2010-12-16 Thread Hugh Williams
Hi Pierre, Relative paths work for me: $ /opt/virtuoso/bin/isql 1162 Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output (

Re: [Virtuoso-users] Upload rdf file from isql

2010-12-16 Thread Pierre-Yves
Hi, Just a small remark about this subject. When I use the method [1], I have to specify the full path, not just the relative path as shown in the example. Thanks for your help, Pierre [1]: http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html On Wed, 2010-12-15 at 08:42 +0100, Pierre

Re: [Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Mark James
Hi Lars, The commercial version of virtuoso has a 'virtual database' capability. You can create tables within virtuoso that are links to tables within other rdbms. It's then possible to create rdf views and either materialize the triples or query the rdbms data directly. Note that if you want to pe

[Virtuoso-users] ETL from SQL to RDF?

2010-12-16 Thread Lars Marius Garshol
Is there functionality in Virtuoso for doing ETL from relational data to RDF? I looked at RDF Views, but it doesn't seem to be what we want, and there don't appear to be any spongers for this purpose. I did find a blog post about the subject that seemed to imply that ETL was not the preferred a

Re: [Virtuoso-users] Virtuoso hackers?

2010-12-16 Thread Aldo Bucchi
Hi Ramon, I sent you an off-list reply :) Regards, A On Wed, Dec 15, 2010 at 9:35 PM, Ramon Felciano wrote: > Hello all – > > I am looking for help evaluating Virtuoso and RDF(S) more generally for data > integration purposes in the life sciences and pharmaceutical space. We are > out of bandwi

[Virtuoso-users] Virtuoso hackers?

2010-12-16 Thread Ramon Felciano
Hello all - I am looking for help evaluating Virtuoso and RDF(S) more generally for data integration purposes in the life sciences and pharmaceutical space. We are out of bandwidth to do evaluation this internally, and I haven't been able to find a "Virtuoso consultants directory" or anything o