{
  "documentation_url": "https://docs.multiwoven.com/integrations/sources/mssql",
  "stream_type": "dynamic",
  "connection_specification": {
    "$schema": "http://json-schema.org/draft-07/schema#",
    "title": "MicrosoftSql",
    "type": "object",
    "required": ["host", "port", "database", "schema"],
    "properties": {
      "credentials": {
        "title": "",
        "type": "object",
        "required": ["auth_type", "username", "password"],
        "properties": {
          "auth_type": {
            "type": "string",
            "default": "username/password",
            "order": 0,
            "readOnly": true
          },
          "username": {
            "description": "Username refers to your individual MS SQL login credentials. At a minimum, the user associated with these credentials must be granted read access to the data intended for synchronization.",
            "examples": ["MSSQL_USER"],
            "type": "string",
            "title": "Username",
            "order": 1
          },
          "password": {
            "description": "This field requires the password associated with the user account specified in the preceding section.",
            "type": "string",
            "multiwoven_secret": true,
            "title": "Password",
            "order": 2
          }
        },
        "order": 0
      },
      "host": {
        "description": "The hostname or IP address of your MS SQL server.",
        "examples": ["127.0.0.1"],
        "type": "string",
        "title": "Host",
        "order": 1
      },
      "port": {
        "description": "The port number for your MS SQL server, which defaults to 1433, may vary based on your configuration. ",
        "examples": ["1433"],
        "type": "string",
        "title": "Port",
        "order": 2
      },
      "database": {
        "description": "The specific MS SQL database to connect to.",
        "examples": ["MSSQL_DB"],
        "type": "string",
        "title": "Database",
        "order": 3
      },
      "schema": {
        "description": "The schema within the MS SQL database.",
        "examples": ["dbo"],
        "type": "string",
        "title": "Schema",
        "order": 4
      }
    }
  }
}