search

LibraryCarpentry / week-four-library-carpentry--DEPRECATED

Week Four lesson
http://librarycarpentry.github.io/city-november-2015/
8 stars 6 forks source link

Are there any "connectors" to allow Open Refine to read/write directly to a database (eg Sybase, MySQL etc)? #15

Open ostephens opened 8 years ago

ostephens commented 8 years ago

@ptallentire I've seen this requested before, but I'm not aware of any generic connectors for OpenRefine that do this (e.g. see https://github.com/OpenRefine/OpenRefine/issues/12)

The 'work around' (such as it is) could be to do the data cleaning in OpenRefine then define a Template export that creates the necessary SQL statements to apply back to your original database - this approach is described http://kb.refinepro.com/2014/04/prepare-sql-query-using-openrefine.html

There are some examples of people connecting OpenRefine more directly to data sources - for example a project called 'GOKb' (Global Open Knowledgebase) uses OpenRefine to push data into a database via an application (see https://www.youtube.com/watch?v=0wAY94hc7Gw), and when Freebase still existed OpenRefine could push data into it via an API (programming interface) - this type of functionality is done via Extensions which can be written for OpenRefine - taking expertise in Java & Javascript to write these extensions

ptallentire commented 8 years ago

Thanks @ostephens, using the Templating Export feature looks like a useful workaround for recurring tasks.