Parse RDF JSON-LD file and save to SQL Server

by

Posted on by

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

Try Withdata FileToDB, a RDF to SQL Server converter for Windows, MacOS, and Linux, Import RDF JSON-LD to SQL Server, Easy and Fast.

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

  • 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 Withdata FileToDB Download FileToDB

Import RDF JSON-LD file (.jsonld) to SQL Server

Choose SQL Server and logon.

convert JSON-LD file to SQL Server table - Choose SQL Server and logon

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

convert JSON-LD file to SQL Server 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 SQL Server - open RDF JSON-LD file

2. Select table and config fields.

You can create new SQL Server table by RDF struct, just click create SQL Server table by RDF struct

Load RDF JSON-LD file (.jsonld) to SQL Server - config SQL Server fields

3. Set rows options.

Transfer RDF JSON-LD file (.jsonld) to SQL Server - summary

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

Convert RDF JSON-LD file (.jsonld) to SQL Server - import to SQL Server

See importing results in SQL Server table

Store RDF JSON-LD file (.jsonld) to SQL Server - view SQL Server table

Convert RDF JSON-LD to SQL Server in command line

Save “RDF to SQL Server” session, then you can:

Set scheduled tasks for converting RDF JSON-LD to SQL Server

You can schedule and automate this importing task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “RDF JSON-LD to SQL Server” conversion.
  2. Set scheduled task for “RDF JSON-LD to SQL Server” conversion.

FAQ

More about Withdata FileToDB – RDF to SQL Server converter