Package com.azure.ai.metricsadvisor.administration.models

Class SqlServerDataFeedSource

java.lang.Object

com.azure.ai.metricsadvisor.administration.models.DataFeedSource

com.azure.ai.metricsadvisor.administration.models.SqlServerDataFeedSource

public final class SqlServerDataFeedSource
extends DataFeedSource

The SQLServerDataFeedSource model.

Method Summary

Modifier and Type	Method	Description
static SqlServerDataFeedSource	fromBasicCredential(String connectionString, String query)	Create a SQLServerDataFeedSource with credential included in the connectionString as plain text.
static SqlServerDataFeedSource	fromConnectionStringCredential(String query, String credentialId)	Create a SQLServerDataFeedSource with the credentialId identifying a credential entity of type DataSourceSqlServerConnectionString that contains the SQL connection string.
static SqlServerDataFeedSource	fromManagedIdentityCredential(String connectionString, String query)	Create a SQLServerDataFeedSource with the connectionString 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 the credentialId identifying a credential entity of type DataSourceServicePrincipal, the entity contains Service Principal to access the SQL Server.
static SqlServerDataFeedSource	fromServicePrincipalInKeyVaultCredential(String connectionString, String query, String credentialId)	Create a SQLServerDataFeedSource with the credentialId identifying a credential entity of type DataSourceServicePrincipalInKeyVault, the entity contains details of the KeyVault holding the Service Principal to access the SQL Server.
DataSourceAuthenticationType	getAuthenticationType()	Gets the authentication type to access the data source.
String	getCredentialId()	Gets the id of the credential resource to authenticate the data source.
String	getQuery()	Get the query that retrieves the values to be analyzed for anomalies.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

fromBasicCredential

public static SqlServerDataFeedSource fromBasicCredential(String connectionString,
 String query)

Create a SQLServerDataFeedSource with credential included in the connectionString 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 the connectionString 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 the credentialId identifying a credential entity of type DataSourceSqlServerConnectionString 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 type DataSourceSqlServerConnectionString.

Returns:

The SQLServerDataFeedSource.

fromServicePrincipalCredential

public static SqlServerDataFeedSource fromServicePrincipalCredential(String connectionString,
 String query,
 String credentialId)

Create a SQLServerDataFeedSource with the credentialId identifying a credential entity of type DataSourceServicePrincipal, 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 type DataSourceServicePrincipal.

Returns:

The SQLServerDataFeedSource.

fromServicePrincipalInKeyVaultCredential

public static SqlServerDataFeedSource fromServicePrincipalInKeyVaultCredential(String connectionString,
 String query,
 String credentialId)

Create a SQLServerDataFeedSource with the credentialId identifying a credential entity of type DataSourceServicePrincipalInKeyVault, 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 type DataSourceServicePrincipalInKeyVault.

Returns:

The SQLServerDataFeedSource.

getQuery

public String getQuery()

Get the query that retrieves the values to be analyzed for anomalies.

Returns:

the query.

getCredentialId

public String getCredentialId()

Gets the id of the credential resource to authenticate the data source.

Returns:

The credential resource id.

getAuthenticationType

public DataSourceAuthenticationType getAuthenticationType()

Gets the authentication type to access the data source.

Returns:

The authentication type.