I saw some posts about connecting multiple databases to a single virtual graph not being possible.
Is there a workaround? Could you please lay out how to do it step by step?
Hi Nisha,
right, you can create a Virtual Graph only for a single data source (i.e., database).
Yet, you can write queries over multiple Virtual Graphs if you want to integrate the data of multiple databases. For example, you can specify the Virtual Graphs in the FROM
clause of the query:
SELECT *
FROM <virtual://vg1>
FROM <virtual://vg2>
{
...
}
Or you can use a special named graph, such as stardog:context:all
or stardog:context:virtual
SELECT *
FROM stardog:context:virtual
{
...
}
I hope this answers your question.
Best regards,
Lars