Training FAQ: Accessing Stardog Data with BI Tools

 

Screen Shot 2020-06-17 at 11.42.02 AM What BI Tools are supported?
In general, if a BI tool can connect to a MySQL database, it can connect to Stardog’s BI Server. That said, we know that some BI tools have their own brand of SQL that might require additional information from Stardog in order to work as intended. To that end, we have a list of officially supported tools that have passed our battery of internal testing. You can find that list here.
 
Please let us know if you have trouble connecting to your BI tool of choice and we’ll add it to our testing queue.
 
Screen Shot 2020-06-17 at 11.42.02 AM When was this feature released?
 
The BI Server was released in Stardog 7.0.3 in November 2019.
 
Screen Shot 2020-06-17 at 11.42.02 AM What’s the benefit of connecting Stardog to a relational-based tool?
 
You receive all the benefits of solving complex problems with heterogenous, connected data while also using the BI tools that analysts and executives know and love. Now, virtualization, the Inference Engine, and advanced features like geospatial queries can all be used by people who know SQL. The BI tools often supply rich visualization tooling, such as various chart and map widgets.
 
Screen Shot 2020-06-17 at 11.42.02 AM How does the BI Server work?
In a way, you can think of the BI Server as a 'reverse' Virtual Graph. The BI Server converts SQL queries to SPARQL queries using a predefined mapping or it can inspect the data model to presume a standard mapping. The mapping defines tables and columns. Alternately, a Stardog stored query can be a table with the projected variables as columns.
 
Screen Shot 2020-06-17 at 11.42.02 AM What can I do when this data is in my preferred BI tool?
Once the data is populated in your BI tool of choice, you can query and manipulate the data as if it was a SQL. The interface is read-only though, so it will not accept data manipulation requests (insert, delete etc.). 
 
Screen Shot 2020-06-17 at 11.42.02 AM How do I define a table?
Tables are defined by a mapping or storing a select query. Please refer to the following documentation on our docs page for additional information: 
 
Screen Shot 2020-06-17 at 11.42.02 AM How do set appropriate permissions?
When you set up the Stardog connection in your BI tool, you specify a Stardog username and password. That user has the same access they do if they were accessing Stardog directly.
 
Screen Shot 2020-06-17 at 11.42.02 AM How do I turn reasoning on?
Please refer to the following documentation on our docs page for additional information: 
 
Screen Shot 2020-06-17 at 11.42.02 AM How does Security work?
When creating a connection in the BI client, authenticate with your Stardog username and password. The user will have same access through the BI client that they would through Stardog directly.
Please refer to the following documentation on our docs page for additional information: 

 

Stardog-logo-lockup 180px-2