# Create virtual graph from db in MSSQLSERVER

**URL:** <https://community.stardog.com/t/create-virtual-graph-from-db-in-mssqlserver/1052>\
**Category:** Support\
**Created:** [May 17, 2018, 2:11pm UTC](https://community.stardog.com/t/create-virtual-graph-from-db-in-mssqlserver/1052 "2018-05-17T14:11:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rohitp1191](https://avatars.discourse-cdn.com/v4/letter/r/a5b964/32.png) [@rohitp1191](https://community.stardog.com/u/rohitp1191)\
**Post date:** [May 17, 2018, 2:11pm UTC](https://community.stardog.com/t/create-virtual-graph-from-db-in-mssqlserver/1052/1 "2018-05-17T14:11:51Z")

</div>

Hello Team  
I am totally new to stardog and I am trying to create virtual graph from a database “TestDatabase\_Demo” in MSSQLSERVER (this will add schema to virtual graph) but stuck with .properties file.How to get jdbc.url,jdbc.username,jdbc.password,jdbc.driver.

---

<div class="post-metadata">

**Author:** ![jess](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/jess/32/10_2.png) [@jess](https://community.stardog.com/u/jess)\
**Post date:** [May 17, 2018, 2:33pm UTC](https://community.stardog.com/t/create-virtual-graph-from-db-in-mssqlserver/1052/2 "2018-05-17T14:33:34Z")

</div>

Hi,

Please refer to SQL Server documentation on the procedure to construct the JDBC URL:

> **[Building the connection URL - JDBC Driver for SQL Server](https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017)**
>
> Learn the format of the connection string used by the Microsoft JDBC Driver for SQL Server. Samples of connection strings are included in the examples section.

The JDBC driver name should be `com.microsoft.sqlserver.jdbc.SQLServerDriver`. You will need to deploy this driver jar in your Stardog instance.

Jess

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [May 31, 2018, 2:33pm UTC](https://community.stardog.com/t/create-virtual-graph-from-db-in-mssqlserver/1052/3 "2018-05-31T14:33:36Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.