Run AutoR2RML with various DBMS - MaastrichtU-IDS/data2services-pipeline GitHub Wiki

Convert TSV & RDB: generate mapping file with AutoR2RML

We use AutoR2RML to generate the R2RML mapping file to convert relational databases (Postgres, SQLite), CSV, TSV and PSV files to a generic RDF.

docker run examples with different DBMS:

# For CSV, TSV, PSV files. Apache Drill needs to be running
docker run -it --rm --link drill:drill -v /data:/data autor2rml \
	-j "jdbc:drill:drillbit=drill:31010" -r \
	-o "/data/data2services/mapping.trig" \
	-d "/data/data2services" \
	-b "https://w3id.org/data2services/" \
	-g "https://w3id.org/data2services/graph/autor2rml"
	
# For Postgres
docker run -it --rm --link postgres:postgres -v /data:/data autor2rml \
	-j "jdbc:postgresql://postgres:5432/my_database" -r \
	-o "/data/data2services/mapping.trig" \
	-u "postgres" -p "pwd" \
	-b "https://w3id.org/data2services/" \
	-g "https://w3id.org/data2services/graph/autor2rml"

# For MariaDB
docker run -it --rm --link mariadb:mariadb -v /data:/data \
  autor2rml -r
  -j "jdbc:mariadb://mariadb:3306/my_database" \
  -o "/data/data2services/mapping.trig" \
  -u "root" -p "pwd" \
  -b "https://w3id.org/data2services/" \
  -g "https://w3id.org/data2services/graph/autor2rml"

# For SQLite
docker run -it --rm -v /data:/data autor2rml \
  -j "jdbc:sqlite:/data/data2services/my_database.db" -r \
  -o "/data/data2services/mapping.trig" \
  -b "https://w3id.org/data2services/" \
  -g "https://w3id.org/data2services/graph/autor2rml"