Data Source Connections
      Back to home
      1. Zetaris Support - Knowledge Base
      2. Connecting to Data Sources
      3. Data Source Connections

      Microsoft SQL Server

      Steps to connect to Microsoft SQL Server

      1. Steps to make connection to MSSQL Database:
      2. Login to the Zetaris platform
      3. Click on NDP Fabric Builder.

      4. Click  next to Virtual Database Sources to launch the connection dialog.

      5. On step 1 click Next.



      6. Upon reaching Step 2 Please provide the following connection details below:
        1. Datasource: MS SQL
        2. Data source name: Provide a name
        3. Description: Provide a description
        4. JDBC server class: com.microsoft.sqlserver.jdbc.SQLServerDriver
        5. JDBC URL: jdbc:sqlserver://hostname:portname/databaseinstance
        6. Username: Your MS SQLconnection username
        7. Password: Your MS SQLconnection password
        8. Parameters: if you have a specific schema to connect to
          1. eg. schema [your schema name]
      7. Once all the details are filled select next to proceed.
      8. You will see a list of tables associated with the database and schema as part of Step 3.
      9. Select all the tables you want to pull in and then select next.
      10. A summary of the data source to be crated will be provided as part of Step 4. Once satisfied with the summary select Register.
      11. Your newly created virtual database source will appear under virtual database sources.Capture-3
      12. To view the contents of your table click on the preview button preview