Differences

This shows you the differences between two versions of the page.

--- project:sqlrdf_mapper [2016/06/29 20:07] – [SQL RDF MAPPER - brings SQL Data into RDF Data] fabioricci
+++ project:sqlrdf_mapper [2016/07/22 16:39] (current) – [SQL RDF MAPPER - converts SQL Data into RDF Data] fabioricci
@@ Line 10: / Line 10: @@
 A single tenant online version will be available for the duration of the hackaton under the link https://ch.semweb.ch:8151/SQLRDFSTAR/GUI.jsp
+**Note** : This mapper is freely available until July 31 2016.
+From July 25 2016 on, a similar but much more secure service will be available upon https://rdflink.ch
 \\
@@ Line 15: / Line 19: @@
 \\
-**Description** \\
+**"User manual"** \\
 The user selects one table and press the orange button to create a first blank TURTLE MAPPING SCHEMA. Once the TURTLE SCHEMA appears, the user can define a mapping for the key of the record and several mappings for each of the table columns. Inside each mapping several functions can be used:
@@ Line 22: / Line 26: @@
 * If-Then expression (do map, donot map)\\
 * Table lookp in other table while mapping\\
+\\
+\\
+Inside a TURTLE Mapping several maps can be defined, one for each SPARQL Endpoint. For instance if you wish to scan a table and map one RDF code to one RDF Store and another RDF code (might be different) to another RDF Store, then you define two mappings.
+\\
+** Testing a Mapping **\\
+Before you execute a map you should validate the TURTLE syntax and after successful validation you should store that mapping and make a version.\\
+\\
+Then you can test a validated map on 1 or 2 records using the verbose option, click on one generated link and see what has been mapped.
+\\
+\\
+another way to test a map is to define from-which records you would like to test, then to start the online tool by licking on the table symbol on the left of a table record. This online tool permits you to see the table records together with the mapped triples, as pictures 2 and 3 show.
+\\
+\\
+**Important**: Use this mapper one at a time, since it is not (yet) multi-tenant.
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:ogsrm_mapper_detail2recsgugg.png}}]]
+Picture 2: Online Tool showing a map of a table - triples above, records below
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:ogsrm_mapper_detail2recsguggtransp.png}}]]
+Picture 3: Online Tool showing the same map of a table - triples above, transposed records below
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:ogsrm_mapper_exec1.png}}]]
+Picture 4: Execution dialog (before start)
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:ogsrm_mapper_exec2.png}}]]
+Picture 5: Execution results
+\\
+\\
+**MAPPER FUNCTIONS**
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:mapper_explode.png}}]]
+Picture 6: Mapper explode function (German)
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:mapper_regex.png}}]]
+Picture 7: Mapper regex function
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:mapper_tlookup.png}}]]
+Picture 8: Mapper table lookup function
+\\
+\\
+\\
+\\
+\\
+[[SQL RDF MAPPER|{{project:mapper_conditions.png}}]]
+Picture 9: Mapper if-then function
 ===== Data =====
-  * List and link your actual and ideal data sources.
+Data for this tool are SQL tables.
+Date must be uploaded into the table.
+If you do not find an upload mechanism on the main page, please ask me (Fabio Ricci) to upload your table data.
 ===== Team =====
@@ Line 31: / Line 132: @@
   * [[user:fabioricci]]
-{{tag>status:concept needs:dev needs:design needs:data needs:expert}}
+{{tag>status:demo needs:dev needs:design needs:data needs:expert glam semantic}}