Class OutputMssql

Manages a Stream Analytics Output to Microsoft SQL Server Database.

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var exampleResourceGroup = Output.Create(Azure.Core.GetResourceGroup.InvokeAsync(new Azure.Core.GetResourceGroupArgs
    {
        Name = "example-resources",
    }));
    var exampleJob = Output.Create(Azure.StreamAnalytics.GetJob.InvokeAsync(new Azure.StreamAnalytics.GetJobArgs
    {
        Name = "example-job",
        ResourceGroupName = azurerm_resource_group.Example.Name,
    }));
    var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new Azure.Sql.SqlServerArgs
    {
        ResourceGroupName = azurerm_resource_group.Example.Name,
        Location = azurerm_resource_group.Example.Location,
        Version = "12.0",
        AdministratorLogin = "dbadmin",
        AdministratorLoginPassword = "example-password",
    });
    var exampleDatabase = new Azure.Sql.Database("exampleDatabase", new Azure.Sql.DatabaseArgs
    {
        ResourceGroupName = azurerm_resource_group.Example.Name,
        Location = azurerm_resource_group.Example.Location,
        ServerName = exampleSqlServer.Name,
        RequestedServiceObjectiveName = "S0",
        Collation = "SQL_LATIN1_GENERAL_CP1_CI_AS",
        MaxSizeBytes = "268435456000",
        CreateMode = "Default",
    });
    var exampleOutputMssql = new Azure.StreamAnalytics.OutputMssql("exampleOutputMssql", new Azure.StreamAnalytics.OutputMssqlArgs
    {
        StreamAnalyticsJobName = azurerm_stream_analytics_job.Example.Name,
        ResourceGroupName = azurerm_stream_analytics_job.Example.Resource_group_name,
        Server = exampleSqlServer.FullyQualifiedDomainName,
        User = exampleSqlServer.AdministratorLogin,
        Password = exampleSqlServer.AdministratorLoginPassword,
        Database = exampleDatabase.Name,
        Table = "ExampleTable",
    });
}

}

Inheritance

System.Object

Resource

CustomResource

OutputMssql

Inherited Members

CustomResource.Id

Resource.GetResourceType()

Resource.GetResourceName()

Resource.Urn

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Pulumi.Azure.StreamAnalytics

Assembly: Pulumi.Azure.dll

Syntax

public class OutputMssql : CustomResource

Constructors

OutputMssql(String, OutputMssqlArgs, CustomResourceOptions)

Create a OutputMssql resource with the given unique name, arguments, and options.

Declaration

public OutputMssql(string name, OutputMssqlArgs args, CustomResourceOptions options = null)

Parameters

Type	Name	Description
System.String	name	The unique name of the resource
OutputMssqlArgs	args	The arguments used to populate this resource's properties
CustomResourceOptions	options	A bag of options that control this resource's behavior

Properties

Database

Declaration

public Output<string> Database { get; }

Property Value

Type	Description
Output<System.String>

Name

The name of the Stream Output. Changing this forces a new resource to be created.

Declaration

public Output<string> Name { get; }

Property Value

Type	Description
Output<System.String>

Password

Password used together with username, to login to the Microsoft SQL Server. Changing this forces a new resource to be created.

Declaration

public Output<string> Password { get; }

Property Value

Type	Description
Output<System.String>

ResourceGroupName

The name of the Resource Group where the Stream Analytics Job exists. Changing this forces a new resource to be created.

Declaration

public Output<string> ResourceGroupName { get; }

Property Value

Type	Description
Output<System.String>

Server

The SQL server url. Changing this forces a new resource to be created.

Declaration

public Output<string> Server { get; }

Property Value

Type	Description
Output<System.String>

StreamAnalyticsJobName

The name of the Stream Analytics Job. Changing this forces a new resource to be created.

Declaration

public Output<string> StreamAnalyticsJobName { get; }

Property Value

Type	Description
Output<System.String>

Table

Table in the database that the output points to. Changing this forces a new resource to be created.

Declaration

public Output<string> Table { get; }

Property Value

Type	Description
Output<System.String>

User

Username used to login to the Microsoft SQL Server. Changing this forces a new resource to be created.

Declaration

public Output<string> User { get; }

Property Value

Type	Description
Output<System.String>

Methods

Get(String, Input<String>, OutputMssqlState, CustomResourceOptions)

Get an existing OutputMssql resource's state with the given name, ID, and optional extra properties used to qualify the lookup.

Declaration

public static OutputMssql Get(string name, Input<string> id, OutputMssqlState state = null, CustomResourceOptions options = null)

Parameters

Type	Name	Description
System.String	name	The unique name of the resulting resource.
Input<System.String>	id	The unique provider ID of the resource to lookup.
OutputMssqlState	state	Any extra arguments used during the lookup.
CustomResourceOptions	options	A bag of options that control this resource's behavior

Returns

Type	Description
OutputMssql