Lift data from tabular data such as CSV, XSLX or database tables

Register the vocabulary

The vocabulary contains the classes and properties needed to map the data into the new structure in the Knowledge Graph.

1. Press the + button on the lower bottom right of the VOCABS tab in Corporate Memory.
   
2. Define a Name, a Graph URI and a Description of the vocabulary.
   In this example we will use:
   • Name: Product Vocabulary
   • Graph URI: http://ld.company.org/prod-vocab/
   • Description: Example vocabulary modeled to describe relations between products and services.
   

Upload the data file / Connect to the JDBC endpoint

(Re-)View your Data Table

To validate that the input data is correct, you can preview the data table in Corporate Memory.

1. Press the Open button of the dataset you want to view the data.
   
2. Select the TABLEVIEW tab.
   
3. In the TABLEVIEW tab, you can view a couple of rows to check that your data in correctly accessible.
   

Create a Knowledge Graph

1. Press the Add button in the Datasets category of your workspace and select the type Knowledge Graph (embedded).
   
2. Define a Name for the Knowledge Graph and provide a graph uri. All other parameters can keep the default values. 
   In this example we will use:
   • Name: Service_Knowledge_Graph
   • graph: http://ld.company.org/prod-instances/
     

Create a Transformation

The transformation defines how an input dataset (e.g. CSV) will be transformed into an output dataset (e.g. Knowledge Graph).

1. Press the Add button in the Transform Tasks category of your workspace.
   
2. Define the Name, the Source Dataset, the Output Dataset and the needed Target Vocabularies of your Transformation Task.
   In this example we will use:
   • Name: Create_Service_Triples
   • Select the previously created dataset, as the Source Dataset: Services CSV
   • Select the previously created dataset as the Output Dataset: Service_Knowledge_Graph
   • Provide the graph (URI) that holds the registered vocabulary as the Target Vocabularies: http://ld.company.org/prod-vocab/
     
3. Press the Open button of the created transformation.
   
4. Click on thein the right main area to expand the menu.
5. Press the EDIT button to create a base mapping.
   

6. Define the Target entity type from the vocabulary, the URI pattern and a label for the mapping.

   In this example we will use:

   • 
     

     Target entity type: Service

   • URI pattern: http://ld.company.org/prod-inst/{ServiceID}

     • where http://ld.company.org/prod-inst/ is a common prefix for the instances in this use case,
       
     • and {ServiceID} is a placeholder that will resolve to the column of that name
   • An optional Label: Service
     

     
     Example RDF triple in our Knowledge Graph based on the mapping definition:

     <http://ld.company.org/prod-inst/Y704-9764759> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://ld.company.org/prod-vocab/Service> 

     TEXT
7. Evaluate your mapping by pressing on the button in the Examples of target data property to see at most three generated base URIs.
   
8. We have now created the Service entities in the Knowledge Graph. As a next step, will add the name of the Service entity in . Press the circular blue button on the lower right and select Add value mapping.
   
9. Define the Target property, the Data type, the Value path (column name) and a Label for your value mapping.
   

   In this example we will use:

   • Target Property: name

   • Data type: StringValueType
   • Value path: ServiceName
     • which corresponds to the column of that name
   • An optional Label: service name
   

Evaluate a Transformation

Visit the EVALUATE tab of your transformation to view a list of generated entities.  By clicking one of the generated entities, more details are provided.

Execute a Transformation to build a Knowledge Graph

1. Go into the mapping and visit the EXECUTE tab.
   
2. Press the button and validate the results. In this example, 9x Service triples were created in our Knowledge Graph based on the mapping.
   
3. Finally you can use the DataManager EXPLORE module to (re-)view of the created Knowledge Graph: http://ld.company.org/prod-instances/