r2rml bootstrap may not generate default mappings for schema other than users

[obkhan]

Hi,

I've been trying to get r2rml bootstrap to work. I have posted a message here: https://groups.google.com/forum/#!topic/ontop4obda/vhHwecFYZxI

Any thoughts?

Omar

[obkhan]

Hi - is there any more information needed to address this? I would be glad to help provide what I can to allow this feature to work correctly with Oracle?

[obkhan]

I have an update on this. I think there should be the ability for Oracle to change the getOracleDefaultOwner to a value perhaps that could in the properties file from cli or Protégé’s plugin. I believe this code can be found in RDBMetadataExtractionTools.java

The issue is that in OracleRelationListProvider queries through user_tables & user_views, instead of all_tables & all_views

Instead perhaps queries could be added like:

select * from all_tables where owner = owner name is a variable

select * from all_views where owner = owner name is a variable

This would overcome this limitation, and allow Ontop to export metadata from owner that the user has access to, but not their default schema