Skip to content

Connecting to SQL Server

Archived PuppyGraph 0.x documentation

This is the archived 0.x documentation. For new deployments, use puppygraph/puppygraph:latest (PuppyGraph 1.x) and the current docs. The 0.x schemas and UI described here don't apply to 1.x; see Migrating from v0.

Prerequisites

  • PuppyGraph version 0.95 or higher.
  • The SQL Server instance is accessible over the network from the PuppyGraph instance.

Configuration

Configuration Explanation
Username The username used to connect to the SQL Server database
Password The password associated with the database user account
JDBC URI A JDBC compatible connection URI of the data source. Read this page for more details on how to construct the URI.
JDBC Driver Class

The class name of the SQL server JDBC driver.

The default value is com.microsoft.sqlserver.jdbc.SQLServerDriver, and typically you don’t need to change it.
JDBC Driver URL

The URL of the SQL server JDBC driver.

Please choose the version of the driver that is compatible with your SQL Server instance.

Demo

See Querying SQL Server Data as a Graph for a complete demo for SQL Server. The demo includes setting up the connection to a SQL Server instance.