Parse RDF JSON-LD file and save to MySQL without programming

by

Posted on by

Want to parse RDF JSON-LD (JSON for Linking Data) file and save to MySQL ?

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona) easily and fast.

  • 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 JSON-LD file(s) to online services.

Download FileToDB Download FileToDB

Import RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona)

Choose MySQL and logon.

convert JSON-LD file to MySQL (MariaDB, Percona) table - Choose MySQL and logon

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

convert JSON-LD file to MySQL (MariaDB, Percona) table - task window

Select the “RDF” file type.

Import file data to database table - select file type

then show the wizard.

1. Open RDF JSON-LD file.

import RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona) - open RDF JSON-LD file

2. Select table and config fields.

You can create new MySQL (MariaDB, Percona) table by RDF struct, just click create MySQL (MariaDB, Percona) table by RDF struct

Load RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona) - config MySQL (MariaDB, Percona) fields

3. Summary.

Transfer RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona) - summary

4. Import data from RDF JSON-LD file (.jsonld) to MySQL.

Convert RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona) - import to MySQL (MariaDB, Percona)

See importing results in MySQL (MariaDB, Percona) table

Store RDF JSON-LD file (.jsonld) to MySQL (MariaDB, Percona) - view MySQL (MariaDB, Percona) table

Convert RDF JSON-LD to MySQL in command line

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

Set scheduled tasks for converting RDF JSON-LD to MySQL

You can schedule and automate this importing task by:

1) Save session and create .bat file.

2) Set scheduled task.

For importing other RDF formats: RDF/XML(.rdf, .owl), Turtle(.ttl, .n3), N-Triples(.nt, .ntriples), N-Quads(.nq, .nq).

FAQ

More about FileToDB – RDF to MySQL converter