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

Support
1

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.

2

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

3

you mean I should query : "select * from xyz__c"

??

4

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.

5

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

6

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

7

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

8

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.

9

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

10

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

11

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."

12

Thanks a lot mate... It is working.

1 Like
13

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

14

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