Data transformation just got a whole lot easier—and smarter! Introducing Ontotext Refine, a tailored version of the open-source OpenRefine, designed to work seamlessly with Ontotext’s GraphDB. Built within the framework of the enRichMyData project, this tool takes the heavy lifting out of preparing, mapping, and transforming structured data into RDF.
If you’re juggling multiple formats like CSVs, JSON, XML, or even RDF, Ontotext Refine is here to simplify your workflow. Here’s how:
- Wide Format Support: From Excel sheets to Turtle/N3 files, this tool handles it all with ease.
- Powerful Data Manipulation: Use faceting, clustering, and transformations powered by GREL (Google Refine Expression Language).
- Seamless Integration: Directly load transformed RDF data into GraphDB and enjoy features like auto-complete for classes and properties from your ontology.
Ontotext Refine offers a dual approach to creating RDF mappings:
- Use a visual RDF mapping interface for a more intuitive experience.
- Write mappings as SPARQL queries for ultimate precision.
What’s more, the tool provides a virtual SPARQL endpoint over tabular data, enabling advanced data integration scenarios.
Command Line Magic
For those who prefer the terminal, the Ontotext Refine CLI (Command Line Interface) is a powerhouse.
- Manage projects effortlessly: create, delete, and export data.
- Apply consistent transformations across datasets.
- Leverage REST APIs for tasks like cleaning and enriching data—no GUI required.
Up-to-date and Ready for Action
The latest version (1.2.1, released June 19, 2023) ensures Ontotext Refine is running on the most up-to-date external dependencies, including libraries, Docker images, and Java versions.
Who Is It For?
Whether you’re a data scientist, engineer, or simply working on creating knowledge graphs, Ontotext Refine is your ultimate companion.