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

by

Posted on by

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

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import RDF JSON-LD file (.jsonld) to PostgreSQL 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 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. Summary.

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 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 PostgreSQL converter