Class SqlServerDataFeedSource
java.lang.Object
com.azure.ai.metricsadvisor.administration.models.DataFeedSource
com.azure.ai.metricsadvisor.administration.models.SqlServerDataFeedSource
The SQLServerDataFeedSource model.
-
Method Summary
Modifier and TypeMethodDescriptionstatic SqlServerDataFeedSource
fromBasicCredential
(String connectionString, String query) Create a SQLServerDataFeedSource with credential included in theconnectionString
as plain text.static SqlServerDataFeedSource
fromConnectionStringCredential
(String query, String credentialId) Create a SQLServerDataFeedSource with thecredentialId
identifying a credential entity of typeDataSourceSqlServerConnectionString
that contains the SQL connection string.static SqlServerDataFeedSource
fromManagedIdentityCredential
(String connectionString, String query) Create a SQLServerDataFeedSource with theconnectionString
containing the resource id of the SQL server on which metrics advisor has MSI access.static SqlServerDataFeedSource
fromServicePrincipalCredential
(String connectionString, String query, String credentialId) Create a SQLServerDataFeedSource with thecredentialId
identifying a credential entity of typeDataSourceServicePrincipal
, the entity contains Service Principal to access the SQL Server.static SqlServerDataFeedSource
fromServicePrincipalInKeyVaultCredential
(String connectionString, String query, String credentialId) Create a SQLServerDataFeedSource with thecredentialId
identifying a credential entity of typeDataSourceServicePrincipalInKeyVault
, the entity contains details of the KeyVault holding the Service Principal to access the SQL Server.Gets the authentication type to access the data source.Gets the id of thecredential resource
to authenticate the data source.getQuery()
Get the query that retrieves the values to be analyzed for anomalies.
-
Method Details
-
fromBasicCredential
Create a SQLServerDataFeedSource with credential included in theconnectionString
as plain text.- Parameters:
connectionString
- The SQL server connection string.query
- The query that retrieves the values to be analyzed for anomalies.- Returns:
- The SQLServerDataFeedSource.
-
fromManagedIdentityCredential
public static SqlServerDataFeedSource fromManagedIdentityCredential(String connectionString, String query) Create a SQLServerDataFeedSource with theconnectionString
containing the resource id of the SQL server on which metrics advisor has MSI access.- Parameters:
connectionString
- The SQL server connection string.query
- The query that retrieves the values to be analyzed for anomalies.- Returns:
- The SQLServerDataFeedSource.
-
fromConnectionStringCredential
public static SqlServerDataFeedSource fromConnectionStringCredential(String query, String credentialId) Create a SQLServerDataFeedSource with thecredentialId
identifying a credential entity of typeDataSourceSqlServerConnectionString
that contains the SQL connection string.- Parameters:
query
- The query that retrieves the values to be analyzed for anomalies.credentialId
- The unique id of a credential entity of typeDataSourceSqlServerConnectionString
.- Returns:
- The SQLServerDataFeedSource.
-
fromServicePrincipalCredential
public static SqlServerDataFeedSource fromServicePrincipalCredential(String connectionString, String query, String credentialId) Create a SQLServerDataFeedSource with thecredentialId
identifying a credential entity of typeDataSourceServicePrincipal
, the entity contains Service Principal to access the SQL Server.- Parameters:
connectionString
- The SQL server connection string.query
- The query that retrieves the values to be analyzed for anomalies.credentialId
- The unique id of a credential entity of typeDataSourceServicePrincipal
.- Returns:
- The SQLServerDataFeedSource.
-
fromServicePrincipalInKeyVaultCredential
public static SqlServerDataFeedSource fromServicePrincipalInKeyVaultCredential(String connectionString, String query, String credentialId) Create a SQLServerDataFeedSource with thecredentialId
identifying a credential entity of typeDataSourceServicePrincipalInKeyVault
, the entity contains details of the KeyVault holding the Service Principal to access the SQL Server.- Parameters:
connectionString
- The SQL server connection string.query
- The query that retrieves the values to be analyzed for anomalies.credentialId
- The unique id of a credential entity of typeDataSourceServicePrincipalInKeyVault
.- Returns:
- The SQLServerDataFeedSource.
-
getQuery
Get the query that retrieves the values to be analyzed for anomalies.- Returns:
- the query.
-
getCredentialId
Gets the id of thecredential resource
to authenticate the data source.- Returns:
- The credential resource id.
-
getAuthenticationType
Gets the authentication type to access the data source.- Returns:
- The authentication type.
-