SqlServerDataFeedSource Class

Package:
com.azure.ai.metricsadvisor.administration.models
Maven Artifact:
com.azure:azure-ai-metricsadvisor:1.2.12

public final class SqlServerDataFeedSource
extends DataFeedSource

The SQLServerDataFeedSource model.

Method Summary

Modifier and Type Method and 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 DataSourceCredentialEntity to authenticate the data source.
String getQuery()

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

Methods inherited from 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.

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.

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.

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.

getAuthenticationType

public DataSourceAuthenticationType getAuthenticationType()

Gets the authentication type to access the data source.

Returns:

The authentication type.

getCredentialId

public String getCredentialId()

Gets the id of the DataSourceCredentialEntity to authenticate the data source.

Returns:

The credential resource id.

getQuery

public String getQuery()

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

Returns:

the query.

Applies to