pulumi-azure-kotlin/com.pulumi.azure.streamanalytics.kotlin/OutputMssqlArgs

OutputMssqlArgs

data class OutputMssqlArgs(val authenticationMode: Output<String>? = null, val database: Output<String>? = null, val maxBatchCount: Output<Double>? = null, val maxWriterCount: Output<Double>? = null, val name: Output<String>? = null, val password: Output<String>? = null, val resourceGroupName: Output<String>? = null, val server: Output<String>? = null, val streamAnalyticsJobName: Output<String>? = null, val table: Output<String>? = null, val user: Output<String>? = null) : ConvertibleToJava<OutputMssqlArgs>

Manages a Stream Analytics Output to Microsoft SQL Server Database.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.streamanalytics.StreamanalyticsFunctions;
import com.pulumi.azure.streamanalytics.inputs.GetJobArgs;
import com.pulumi.azure.sql.SqlServer;
import com.pulumi.azure.sql.SqlServerArgs;
import com.pulumi.azure.sql.Database;
import com.pulumi.azure.sql.DatabaseArgs;
import com.pulumi.azure.streamanalytics.OutputMssql;
import com.pulumi.azure.streamanalytics.OutputMssqlArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
            .name("rg-example")
            .location("West Europe")
            .build());
        final var example = StreamanalyticsFunctions.getJob(GetJobArgs.builder()
            .name("example-job")
            .resourceGroupName(exampleResourceGroup.name())
            .build());
        var exampleSqlServer = new SqlServer("exampleSqlServer", SqlServerArgs.builder()
            .name("example-server")
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .version("12.0")
            .administratorLogin("dbadmin")
            .administratorLoginPassword("example-password")
            .build());
        var exampleDatabase = new Database("exampleDatabase", DatabaseArgs.builder()
            .name("exampledb")
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .serverName(exampleSqlServer.name())
            .requestedServiceObjectiveName("S0")
            .collation("SQL_LATIN1_GENERAL_CP1_CI_AS")
            .maxSizeBytes("268435456000")
            .createMode("Default")
            .build());
        var exampleOutputMssql = new OutputMssql("exampleOutputMssql", OutputMssqlArgs.builder()
            .name("example-output-sql")
            .streamAnalyticsJobName(example.applyValue(getJobResult -> getJobResult).applyValue(example -> example.applyValue(getJobResult -> getJobResult.name())))
            .resourceGroupName(example.applyValue(getJobResult -> getJobResult).applyValue(example -> example.applyValue(getJobResult -> getJobResult.resourceGroupName())))
            .server(exampleSqlServer.fullyQualifiedDomainName())
            .user(exampleSqlServer.administratorLogin())
            .password(exampleSqlServer.administratorLoginPassword())
            .database(exampleDatabase.name())
            .table("ExampleTable")
            .build());
    }
}

Import

Stream Analytics Outputs to Microsoft SQL Server Database can be imported using the resource id, e.g.

$ pulumi import azure:streamanalytics/outputMssql:OutputMssql example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.StreamAnalytics/streamingJobs/job1/outputs/output1

Constructors

OutputMssqlArgs

fun OutputMssqlArgs(authenticationMode: Output<String>? = null, database: Output<String>? = null, maxBatchCount: Output<Double>? = null, maxWriterCount: Output<Double>? = null, name: Output<String>? = null, password: Output<String>? = null, resourceGroupName: Output<String>? = null, server: Output<String>? = null, streamAnalyticsJobName: Output<String>? = null, table: Output<String>? = null, user: Output<String>? = null)

Functions

toJava

open override fun toJava(): OutputMssqlArgs

Properties

authenticationMode

val authenticationMode: Output<String>? = null

The authentication mode for the Stream Output. Possible values are Msi and ConnectionString. Defaults to ConnectionString.

database

val database: Output<String>? = null

The MS SQL database name where the reference table exists. Changing this forces a new resource to be created.

maxBatchCount

val maxBatchCount: Output<Double>? = null

The max batch count to write to the SQL Database. Defaults to 10000. Possible values are between 1 and 1073741824.

maxWriterCount

val maxWriterCount: Output<Double>? = null

The max writer count for the SQL Database. Defaults to 1. Possible values are 0 which bases the writer count on the query partition and 1 which corresponds to a single writer.

name

val name: Output<String>? = null

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

password

val password: Output<String>? = null

Password used together with username, to login to the Microsoft SQL Server. Required if authentication_mode is ConnectionString.

resourceGroupName

val resourceGroupName: Output<String>? = null

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

server

val server: Output<String>? = null

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

streamAnalyticsJobName

val streamAnalyticsJobName: Output<String>? = null

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

table

val table: Output<String>? = null

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

user

val user: Output<String>? = null

Username used to login to the Microsoft SQL Server. Changing this forces a new resource to be created. Required if authentication_mode is ConnectionString.