Microsoft SQL Server

Microsoft SQL Server Integration

Example Terraform Resource Usage

---

resource "apono_integration" "mssql-integration" {
  name                     = "Microsoft SQL Server"
  type                     = "mssql"
  connector_id             = "apono-connector-id"
  connected_resource_types = ["resource-type-1", "resource-type-2"]
  metadata = {
    hostname = "<Hostname>"
    port = "<Port>"
    dbname = "<Database Name>"
    credentials_rotation_period_in_days = "<Credentials rotation period (in days)>"
    credentials_cleanup_period_in_days = "<User cleanup after access is revoked (in days)>"
  }
  kubernetes_secret = {
    name      = "name_template_value"
    namespace = "namespace_template_value"
  }
}

Schema

---

• type mssql

• connected_resource_types List of resource types to sync. The following are the available resource type/s you can use:

  • mssql

  • mssql-server-role

  • mssql-database

  • mssql-schema

  • mssql-table

  • mssql-view

  • mssql-function

  • mssql-procedure

  • mssql-role

Metadata

• hostname (Required | String) Hostname

• port (Required | String) Port

  • Default value: 1433

• dbname (Required | String) Database Name

  • Default value: master

• credentials_rotation_period_in_days (Optional | String) Credentials rotation period (in days)

• credentials_cleanup_period_in_days (Optional | String) User cleanup after access is revoked (in days)