# How to get mapping info in R2RML instead of SMS

**URL:** <https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888>\
**Category:** Support\
**Created:** [March 25, 2024, 12:14pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888 "2024-03-25T12:14:56Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [March 25, 2024, 12:14pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/1 "2024-03-25T12:14:56Z")

</div>

Hi,  
I am using stardog cloud free and I really like what I saw up to now.  
When exporting, the mapping info of the virtual graphs are exported in SMS format.  
Is it possible to extract it in r2rml as well?  
Up to now I only found an option to extract it using the CLI, but as I understood, this is not available with the free account in the cloud, correct?  
Any help would be appreciated.  
Andreas

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [March 25, 2024, 2:01pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/2 "2024-03-25T14:01:14Z")

</div>

Hi Andreas,

Glad your having a good experience. What you have discovered is correct - there is no way to obtain the mappings in R2RML format in Studio. The best way to do that is to use the CLI.You should be able to obtain the CLI by following this link: [Install from Zip | Stardog Documentation Latest](https://docs.stardog.com/install-stardog/install-from-zip)

-Paul

---

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [March 25, 2024, 5:32pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/3 "2024-03-25T17:32:50Z")

</div>

Hi Paul,  
thanks for your reply. Is it possible to install stardog without a license and that way use the CLI for stardog cloud free? Having read the documentation, I am not really sure.  
Thanks  
Andreas

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [March 25, 2024, 6:57pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/4 "2024-03-25T18:57:31Z")

</div>

You can use the client portion of the install without a license file. You would point the CLI to the cloud instance, which is licensed.

-Paul

---

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [March 25, 2024, 9:27pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/5 "2024-03-25T21:27:12Z")

</div>

Is it possible, that extracting r2rml is only possible with stardog-admin and that this cli command is not available for stardog cloud free?

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [March 26, 2024, 12:35am UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/6 "2024-03-26T00:35:14Z")

</div>

If you use the same user that created the virtual graph, I can't see why the CLI shouldn't work. I'm assuming you have a password, but you can go into the 🔒 security tab of Stardog Studio to set one. You should also see that your user has read permission for the VG, or for all rersources (the default for the account that created the account). Then, you want something like:

```auto
stardog-admin --server https://sd-e1234acf.stardog.cloud:5820 virtual mappings -u pauljackson@verizon.net -p PaulsSecretPa$$ -v -f r2rml paulsvg

```

The `-v` will give a better error message if it doesn't work.

-Paul

---

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [March 29, 2024, 1:11pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/7 "2024-03-29T13:11:59Z")

</div>

Hi Paul, it may be an issue with my installation. Here is the error message when trying to run stardog-admin, below also my java version. What am I doing wrong?

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/5/5dedb4bfdd317367a9d56d45d937b0a350efab75.png)  
Thanks Andreas

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [March 29, 2024, 1:16pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/8 "2024-03-29T13:16:37Z")

</div>

It looks like your version of Java is too recent for Stardog, which requires version 11.

-Paul

---

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [March 29, 2024, 4:49pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/9 "2024-03-29T16:49:30Z")

</div>

Hi Paul, with Java 11 it is working now. Thanks for your help Andreas

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [April 1, 2024, 1:56pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/10 "2024-04-01T13:56:39Z")

</div>

Excellent. I neglected to ask - what is your interest in having the mappings in R2RML format?

Regards,  
-Paul

---

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [April 1, 2024, 5:21pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/11 "2024-04-01T17:21:15Z")

</div>

Hi Paul, I would like to use the metadata generated from stardog. I am thinking about using sparql to query the metadata, thats why I wanted to use the standard. Regards, Andreas

---

<div class="post-metadata">

**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\
**Post date:** [April 1, 2024, 6:06pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/12 "2024-04-01T18:06:00Z")

</div>

That's interesting. Have you looked at the built-in [knowledge catalog](https://docs.stardog.com/knowledge-catalog/)? It's a database like any other, named `catalog`, that Stardog updates with data source metadata, including virtual graph mappings. I'd be interested to know whether that meets your needs or not.

Cheers,  
-Paul

---

<div class="post-metadata">

**Author:** ![Andreas\_Haas](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/andreas_haas/32/2082_2.png) [@Andreas\_Haas](https://community.stardog.com/u/Andreas_Haas)\
**Post date:** [April 3, 2024, 2:14pm UTC](https://community.stardog.com/t/how-to-get-mapping-info-in-r2rml-instead-of-sms/4888/13 "2024-04-03T14:14:24Z")

</div>

Hi Paul, this looks really interesting, thanks for the hint. Andreas
