@prefix rr: <http://www.w3.org/ns/r2rml#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix ex: <http://example.com/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix rml: <http://semweb.mmlab.be/ns/rml#> .
@prefix ql: <http://semweb.mmlab.be/ns/ql#> .
@base <http://example.com/base/> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .

<TriplesMap1> a rr:TriplesMap;
    
  rml:logicalSource [
    rml:source <#DB_source>;
    rr:sqlVersion rr:SQL2008;
    rml:query "SELECT ID, LastName, concat_ws(FirstName, '', LastName) as Name FROM student";
    rr:tableName "student";
  ];

  rr:subjectMap [
      rr:template "http://example.com/{ID}/{LastName}";
    ];

    rr:predicateObjectMap [
        rr:predicate foaf:name ;
        rr:objectMap [
          rml:reference "Name";
          rr:termType rr:Literal;
        ]
      ].

<#DB_source> a d2rq:Database;
  d2rq:jdbcDSN "CONNECTIONDSN";
  d2rq:jdbcDriver "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  d2rq:username "sa";
  d2rq:password "YourSTRONG!Passw0rd;" .