Parse RDF Turtle file and save to MySQL

by

Posted on by

Want to parse RDF Turtle file and save to MySQL ?

Try Withdata FileToDB, a RDF to MySQL converter for Windows, MacOS, and Linux, Import RDF Turtle to MySQL, Easy and Fast.

And support other RDF formats: RDF/XML(.rdf, .owl), N-Triples(.nt, .ntriples), N-Quads(.nq, .nq), JSON-LD(.jsonld).

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Convert files locally and privately, avoid uploading large RDF Turtle file(s) to online services.

Download Withdata FileToDB Download FileToDB

Import RDF Turtle file (.ttl, .n3) to MySQL

Choose MySQL and logon.

convert TTL file to MySQL table - Choose MySQL and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert TTL file to MySQL table - task window

Select the “RDF” file type.

Import file data to database table - select file type

then show the wizard.

1. Open RDF Turtle file.

import RDF Turtle file (.ttl, .n3) to MySQL - open RDF Turtle file

2. Select table and config fields.

You can create new MySQL table by RDF struct, just click create MySQL table by RDF struct

Load RDF Turtle file (.ttl, .n3) to MySQL - config MySQL fields

3. Set rows options.

Transfer RDF Turtle file (.ttl, .n3) to MySQL - summary

4. Import data from RDF Turtle file (.ttl, .n3) to MySQL.

Convert RDF Turtle file (.ttl, .n3) to MySQL - import to MySQL

See importing results in MySQL table

Store RDF Turtle file (.ttl, .n3) to MySQL - view MySQL table

Convert RDF Turtle file (.ttl, .n3) to MySQL in command line

Save “RDF to MySQL” session, then you can:

Set scheduled tasks for converting RDF Turtle file (.ttl, .n3) to MySQL

You can schedule and automate this importing task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “RDF Turtle to MySQL” conversion.
  2. Set scheduled task for “RDF Turtle to MySQL” conversion.

FAQ

More about Withdata FileToDB – TTL to MySQL converter