Parse RDF JSON-LD file and save to PostgreSQL

by

Posted on by

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

Try Withdata FileToDB, a RDF to PostgreSQL converter for Windows, MacOS, and Linux, Import RDF JSON-LD to PostgreSQL, 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 PostgreSQL

Choose PostgreSQL and logon.

convert JSON-LD file to PostgreSQL table - Choose PostgreSQL and logon

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

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

2. Select table and config fields.

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

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

3. Set rows options.

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

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

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

See importing results in PostgreSQL table

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

Convert RDF JSON-LD to PostgreSQL in command line

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

Set scheduled tasks for converting RDF JSON-LD to PostgreSQL

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 PostgreSQL” conversion.
  2. Set scheduled task for “RDF JSON-LD to PostgreSQL” conversion.

FAQ

More about Withdata FileToDB – RDF to PostgreSQL converter