Share via


SqlServerDataFeedSource Class

Definition

Describes an SQL Server data source which ingests data into a DataFeed for anomaly detection.

public class SqlServerDataFeedSource : Azure.AI.MetricsAdvisor.Administration.DataFeedSource
type SqlServerDataFeedSource = class
    inherit DataFeedSource
Public Class SqlServerDataFeedSource
Inherits DataFeedSource
Inheritance
SqlServerDataFeedSource

Constructors

SqlServerDataFeedSource(String, String)

Initializes a new instance of the SqlServerDataFeedSource class. This constructor requires a connectionString and is intended to be used with the authentication types Basic (default), ManagedIdentity, ServicePrincipal, or ServicePrincipalInKeyVault. If you intend to use SqlConnectionString authentication, see SqlServerDataFeedSource(String).

SqlServerDataFeedSource(String)

Initializes a new instance of the SqlServerDataFeedSource class. This constructor does not set a Azure.AI.MetricsAdvisor.Administration.SqlServerDataFeedSource.ConnectionString, so you must assign an SqlServerDataFeedSource.AuthenticationType to the Authentication property. Currently, only the SqlConnectionString authentication is supported without a connection string. If you intend to use another type of authentication, see SqlServerDataFeedSource(String, String).

Properties

Authentication

The method used to authenticate to this SqlServerDataFeedSource. Be aware that some authentication types require you to have a DataSourceCredentialEntity in the service. In this case, you also need to set the property DataSourceCredentialId to specify which credential to use. Defaults to Basic.

DataSourceCredentialId

The ID of the DataSourceCredentialEntity to use for authentication. The type of authentication to use must also be specified in the property Authentication.

DataSourceKind

The data source kind.

(Inherited from DataFeedSource)
Query

The query to retrieve the data to be ingested.

Methods

UpdateConnectionString(String)

Updates the connection string.

Applies to