# Trying to create a Virtual Graph on salesforce using cdata driver but failing

**URL:** <https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641>\
**Category:** Support\
**Created:** [August 10, 2020, 1:37pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641 "2020-08-10T13:37:37Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sutanu\_Paul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/sutanu_paul/32/733_2.png) [@Sutanu\_Paul](https://community.stardog.com/u/Sutanu_Paul)\
**Post date:** [August 10, 2020, 1:37pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/1 "2020-08-10T13:37:37Z")

</div>

Hi, I have been trying to create a Virtual Graph on a salesforce database. I am using cdata jdbc driver. Having error: object 'xyz' not found (Internal server error). But I have checked that object exists and also accessed the corresponding data using dbevear and java code.  
The following steps I have followed:

1. Installed stardog in an ec2 instance.
2. Extracted the setup.jar provided by cdata and Put the cdata.jdbc.salesforce.jar file in stardoghome/server/ext/ directory.
3. It was failing the above mentioned error.

Note: Stardog is working fine because I have created a virtual graph over an oracle database and it is working perfectly.

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [August 10, 2020, 1:40pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/2 "2020-08-10T13:40:53Z")

</div>

Hi and welcome! Salesforce objects/tables include the `__c` suffix. Can you try adding this to the object/table name?

---

<div class="post-metadata">

**Author:** ![Sutanu\_Paul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/sutanu_paul/32/733_2.png) [@Sutanu\_Paul](https://community.stardog.com/u/Sutanu_Paul)\
**Post date:** [August 10, 2020, 1:53pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/3 "2020-08-10T13:53:54Z")

</div>

you mean I should query : "select \* from xyz\_\_c"

??

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [August 10, 2020, 1:58pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/4 "2020-08-10T13:58:14Z")

</div>

This is required when using the Simba driver. Please try it and see if it works. I'll try it with the CDATA driver later today.

---

<div class="post-metadata">

**Author:** ![Sutanu\_Paul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/sutanu_paul/32/733_2.png) [@Sutanu\_Paul](https://community.stardog.com/u/Sutanu_Paul)\
**Post date:** [August 11, 2020, 4:55am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/5 "2020-08-11T04:55:04Z")

</div>

It is not working. It is throwing the same error.

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [August 11, 2020, 10:50pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/6 "2020-08-11T22:50:08Z")

</div>

Is "xyz" a custom or standard object? Can you try putting double quotes around the table name in the mapping?

---

<div class="post-metadata">

**Author:** ![Sutanu\_Paul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/sutanu_paul/32/733_2.png) [@Sutanu\_Paul](https://community.stardog.com/u/Sutanu_Paul)\
**Post date:** [August 12, 2020, 1:45am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/7 "2020-08-12T01:45:47Z")

</div>

It is custom object and I have tried putting double quote but having same error.

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [August 12, 2020, 2:05am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/8 "2020-08-12T02:05:46Z")

</div>

Can you try setting `sql.default.schema=Salesforce` in the properties file? If this doesn't work, you can use the `virtual source_metadata` utility to verify the schema and table name.

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [August 13, 2020, 12:33am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/9 "2020-08-13T00:33:11Z")

</div>

@Sutanu_Paul Just wanted to check in and see how things are going. Were you able to get the query to run?

---

<div class="post-metadata">

**Author:** ![Sutanu\_Paul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/sutanu_paul/32/733_2.png) [@Sutanu\_Paul](https://community.stardog.com/u/Sutanu_Paul)\
**Post date:** [August 13, 2020, 6:12am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/10 "2020-08-13T06:12:08Z")

</div>

I am new to stardog. can you lead me where is the location of the property file?

---

<div class="post-metadata">

**Author:** ![stephen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/stephen/32/27_2.png) [@stephen](https://community.stardog.com/u/stephen)\
**Post date:** [August 13, 2020, 11:26am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/11 "2020-08-13T11:26:12Z")

</div>

If you created the VG on the CLI, the properties file is what you pass in to the command alongside the mappings (if any). If you are using Stardog Studio, you can set `sql.default.schema` in the Configuration popup for the VG, under "other options."

---

<div class="post-metadata">

**Author:** ![Sutanu\_Paul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/sutanu_paul/32/733_2.png) [@Sutanu\_Paul](https://community.stardog.com/u/Sutanu_Paul)\
**Post date:** [August 17, 2020, 6:04am UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/12 "2020-08-17T06:04:06Z")

</div>

Thanks a lot mate... It is working.

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [August 17, 2020, 4:26pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/13 "2020-08-17T16:26:41Z")

</div>

Thanks for confirming. We'll add explicit support for this CDATA driver so it works out of the box in the future. Best regards.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [August 31, 2020, 4:27pm UTC](https://community.stardog.com/t/trying-to-create-a-virtual-graph-on-salesforce-using-cdata-driver-but-failing/2641/14 "2020-08-31T16:27:00Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
