This page discusses administering Stardog’s Business Intelligence (BI) Server. For more information on the BI Server’s supported clients and their usage, please see the section on BI Tools and SQL Queries.
Stardog provides a facility to bridge the flexible schema of the graph data model to the traditional relational model required by business intelligence tools using SQL. This enables seamless use of business intelligence and visualization tools such as Tableau and Power BI.
Using this feature requires creating a schema mapping from Stardog’s data model to a relational data model. This mapping will be used to generate a relational schema. After creating the schema, the full power of SQL becomes available to relational clients.
Authentication requirements dictate that users created in versions of Stardog prior to
7.0.2 will need to have their password reset before connecting through the BI server. This requirement is not applicable if LDAP authentication is configured.
To integrate with business intelligence applications, Stardog includes a BI Server that makes Stardog communicate like a fully SQL-compliant RDBMS. The BI Server can be configured to run inside Stardog using the following configuration options in
| ||Turns on the BI Server. Must be set to |
| ||Controls the TCP port which the SQL query endpoint listens on. The default port is |
| ||Controls when changes to the schema mappings are visible to new BI connections. The default value is |
The schema mapping is stored in a named graph which can be configured separately for each database. The
sql.schema.graph database option should be set to IRI of the named graph which stores the schema. The default value is
If the schema mapping is not manually added by the user and the database configuration option
sql.schema.auto is set to
true (which is the default value) then a schema mapping will be automatically created and used. Read more about this in the BI Tools and SQL Queries section.
The BI Server uses the same authentication mechanisms configured globally in the Stardog instance. This is generally transparent but may require special configuration in the MySQL client. MySQL’s ODBC driver requires the “cleartext” password authentication to be enabled when using LDAP authentication. This can be done by setting
ENABLE_CLEARTEXT_PLUGIN=1 when editing DSN file or by checking the “Enable Cleartext Authentication” option of the “Connection” tab in the GUI configuration
The BI Server supports SSL/TLS connections which is especially important when sending cleartext passwords with LDAP authentication as described above. The required configuration is to provide a server key as documented in Configuring Stardog to use SSL. The BI Server currently only reads the SSL/TLS keyStore property from the JVM arguments, not from
When the server key is provided, the BI Server will advertise SSL/TLS capability to clients. Preventing the use of unencrypted connections can be done on the client side. MySQL’s ODBC driver can be configured with
SSLMODE=REQUIRED. MySQL’s JDBC driver can be configured with
To see the SPARQL queries that are generated by the BI server, add this element to the
<Loggers> section of your
log4j2.xml file and restart Stardog:
<Logger name="com.complexible.stardog.serf.sql.planner.SparqlEnumerator" level="DEBUG" additivity="false"> <AppenderRef ref="stardogAppender"/> </Logger>
See the Logging section in the Server Administration chapter for more information on configuring your