Microsoft SQL Server
Steps to connect to Microsoft SQL Server
- Steps to make connection to MSSQL Database:
- Login to the Zetaris platform
- Click on NDP Fabric Builder.
![](https://kbase.zetaris.com/hubfs/image-png-Nov-02-2022-03-44-06-4810-AM.png)
- Click
next to Virtual Database Sources to launch the connection dialog.
![](https://kbase.zetaris.com/hubfs/image-png-Nov-02-2022-03-43-55-1843-AM.png)
- On step 1 click Next.
![](https://kbase.zetaris.com/hubfs/image-png-Nov-02-2022-03-44-25-7643-AM.png)
- Upon reaching Step 2 Please provide the following connection details below:
- Datasource: MS SQL
- Data source name: Provide a name
- Description: Provide a description
- JDBC server class: com.microsoft.sqlserver.jdbc.SQLServerDriver
- JDBC URL: jdbc:sqlserver://hostname:portname/databaseinstance
- Username: Your MS SQLconnection username
- Password: Your MS SQLconnection password
- Parameters: if you have a specific schema to connect to
- eg. schema [your schema name]
![](https://kbase.zetaris.com/hubfs/image-png-Nov-03-2022-11-12-23-8861-PM.png)
- Once all the details are filled select next to proceed.
- You will see a list of tables associated with the database and schema as part of Step 3.
- Select all the tables you want to pull in and then select next.
- A summary of the data source to be crated will be provided as part of Step 4. Once satisfied with the summary select Register.
- Your newly created virtual database source will appear under virtual database sources.
![Capture-3](https://kbase.zetaris.com/hs-fs/hubfs/Capture-3.png?width=688&height=420&name=Capture-3.png)
- To view the contents of your table click on the preview button
![preview](https://kbase.zetaris.com/hs-fs/hubfs/preview.png?width=18&name=preview.png)