Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
project:sqlrdf_mapper [2016/06/29 20:12] – [SQL RDF MAPPER - converts 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:// | A single tenant online version will be available for the duration of the hackaton under the link https:// | ||
+ | |||
+ | **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:// | ||
+ | |||
\\ | \\ | ||
Line 26: | Line 30: | ||
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. | 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 **\\ | ** 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.\\ | 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. | + | 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**: | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 2: Online Tool showing a map of a table - triples above, records below | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 3: Online Tool showing the same map of a table - triples above, transposed records below | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 4: Execution dialog (before start) | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 5: Execution results | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | **MAPPER FUNCTIONS** | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 6: Mapper explode function (German) | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 7: Mapper regex function | ||
+ | |||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 8: Mapper table lookup function | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | [[SQL RDF MAPPER|{{project: | ||
+ | Picture 9: Mapper if-then function | ||
+ | |||
===== Data ===== | ===== 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 | ||
===== Team ===== | ===== Team ===== | ||
Line 42: | Line 132: | ||
* [[user: | * [[user: | ||
| | ||
- | {{tag> | + | {{tag> |