I am trying to create a Datasource from my Stardog Studio (Stardog Free Cloud) instance to a dataset present in my Local H2 database using JDBC. But I get Error. Below are the configuration setting and error message I get. Can anyone help how to establish a connection successfully ?
H2 Query Page :
Stardog Studio Config:
The JDBC Driver is present in the bin directory of the installed folder in local machine.
The error that I get after clicking Add button is:
It seems there is some problem with the org.h2.Driver class. But what step should I take to fix the issue I am not able to figure out. Can anyone please help ?
You want to place the JDBC driver in your own folder and set the STARDOG_EXT environment variable to point to that folder. See Using Virtual Graphs | Stardog Documentation Latest
I am using the StarDog Cloud Free instance. In which folder exactly I have to place the JDBC driver ? And where can I find the STARDOG_EXT env variable ? Can you provide details with screens shots please ? I have this Jar placed in the BIN directory of H2 DB set up.
My apologies. You mentioned that. We only support these drivers in our cloud offering. Supported Data Sources | Stardog Documentation Latest
No Problem Paul. Good to know that. However , I do have a postgres set up and I can create few tables over there. Would you be able to share the details how can I create data source from postgres in stardog and where should I place the jar file in Postgres set up in my local system ?
The usecase I am trying to do is - I want to create a virtual Graph in Stardog Cloud instance without copying the data to Stardog. I need to map the physical data from postgres to a business mapping to create the virtual graph.
The problem I am facing is - I am not able to create a data source in Stardog Cloud with an external data store. So far I have tried below and unsuccessful
- Oracle Server in Virtualbox
- Databricks Community Edition
I want to give it a try for Postgres next. So please share some screenshots on how to configure it in Stardog
You won't need to install the drivers as they're already installed on Stardog's hosted servers. The only constraint that I'm aware of for PostgreSQL that you need to be mindful of is the Postgres server must be accessible from the internet, so you won't be able to run the server on your workstation and use
localhost in the JDBC connection string. The connection string needs to be one that is accessible from the Stardog server, which is a cloud-hosted server. You could use Amazon's RDS, for example.
I have tried even with one RDS MySQL instance. I ran into error. The challenge is mainly is in the config section in Stardog Designer. Driver details, Class Details etc. There are not enough documentation on how one can set up a cloud stardog instance with a online data source successfully. At least, one example with config details, screenshots etc should be provided for beginners of stardog in the tutorials or how-to section. That would make the tool more user friendly and would encourage users to achieve something with the cloud trial version.
You can find a decent Designer tutorial here. For simplicity, it uses csv files. To use MySQL, follow the same steps but click database instead of file when setting up the data source. Then select MySQL and MariaDB. Finally, give the data source a name, and supply your JDBC connection string, username, and password.
An example connection string for Amazon RDS is:
More details on the JDBC connection string can be found here.