com.pulumi.azure.streamanalytics.kotlin.OutputMssqlArgs.kt Maven / Gradle / Ivy
@file:Suppress("NAME_SHADOWING", "DEPRECATION")
package com.pulumi.azure.streamanalytics.kotlin
import com.pulumi.azure.streamanalytics.OutputMssqlArgs.builder
import com.pulumi.core.Output
import com.pulumi.core.Output.of
import com.pulumi.kotlin.ConvertibleToJava
import com.pulumi.kotlin.PulumiTagMarker
import kotlin.Double
import kotlin.String
import kotlin.Suppress
import kotlin.jvm.JvmName
/**
* Manages a Stream Analytics Output to Microsoft SQL Server Database.
* ## Example Usage
*
* ```typescript
* import * as pulumi from "@pulumi/pulumi";
* import * as azure from "@pulumi/azure";
* const exampleResourceGroup = new azure.core.ResourceGroup("example", {
* name: "rg-example",
* location: "West Europe",
* });
* const example = azure.streamanalytics.getJobOutput({
* name: "example-job",
* resourceGroupName: exampleResourceGroup.name,
* });
* const exampleSqlServer = new azure.sql.SqlServer("example", {
* name: "example-server",
* resourceGroupName: exampleResourceGroup.name,
* location: exampleResourceGroup.location,
* version: "12.0",
* administratorLogin: "dbadmin",
* administratorLoginPassword: "example-password",
* });
* const exampleDatabase = new azure.sql.Database("example", {
* name: "exampledb",
* resourceGroupName: exampleResourceGroup.name,
* location: exampleResourceGroup.location,
* serverName: exampleSqlServer.name,
* requestedServiceObjectiveName: "S0",
* collation: "SQL_LATIN1_GENERAL_CP1_CI_AS",
* maxSizeBytes: "268435456000",
* createMode: "Default",
* });
* const exampleOutputMssql = new azure.streamanalytics.OutputMssql("example", {
* name: "example-output-sql",
* streamAnalyticsJobName: example.apply(example => example.name),
* resourceGroupName: example.apply(example => example.resourceGroupName),
* server: exampleSqlServer.fullyQualifiedDomainName,
* user: exampleSqlServer.administratorLogin,
* password: exampleSqlServer.administratorLoginPassword,
* database: exampleDatabase.name,
* table: "ExampleTable",
* });
* ```
* ```python
* import pulumi
* import pulumi_azure as azure
* example_resource_group = azure.core.ResourceGroup("example",
* name="rg-example",
* location="West Europe")
* example = azure.streamanalytics.get_job_output(name="example-job",
* resource_group_name=example_resource_group.name)
* example_sql_server = azure.sql.SqlServer("example",
* name="example-server",
* resource_group_name=example_resource_group.name,
* location=example_resource_group.location,
* version="12.0",
* administrator_login="dbadmin",
* administrator_login_password="example-password")
* example_database = azure.sql.Database("example",
* name="exampledb",
* resource_group_name=example_resource_group.name,
* location=example_resource_group.location,
* server_name=example_sql_server.name,
* requested_service_objective_name="S0",
* collation="SQL_LATIN1_GENERAL_CP1_CI_AS",
* max_size_bytes="268435456000",
* create_mode="Default")
* example_output_mssql = azure.streamanalytics.OutputMssql("example",
* name="example-output-sql",
* stream_analytics_job_name=example.name,
* resource_group_name=example.resource_group_name,
* server=example_sql_server.fully_qualified_domain_name,
* user=example_sql_server.administrator_login,
* password=example_sql_server.administrator_login_password,
* database=example_database.name,
* table="ExampleTable")
* ```
* ```csharp
* using System.Collections.Generic;
* using System.Linq;
* using Pulumi;
* using Azure = Pulumi.Azure;
* return await Deployment.RunAsync(() =>
* {
* var exampleResourceGroup = new Azure.Core.ResourceGroup("example", new()
* {
* Name = "rg-example",
* Location = "West Europe",
* });
* var example = Azure.StreamAnalytics.GetJob.Invoke(new()
* {
* Name = "example-job",
* ResourceGroupName = exampleResourceGroup.Name,
* });
* var exampleSqlServer = new Azure.Sql.SqlServer("example", new()
* {
* Name = "example-server",
* ResourceGroupName = exampleResourceGroup.Name,
* Location = exampleResourceGroup.Location,
* Version = "12.0",
* AdministratorLogin = "dbadmin",
* AdministratorLoginPassword = "example-password",
* });
* var exampleDatabase = new Azure.Sql.Database("example", new()
* {
* Name = "exampledb",
* ResourceGroupName = exampleResourceGroup.Name,
* Location = exampleResourceGroup.Location,
* ServerName = exampleSqlServer.Name,
* RequestedServiceObjectiveName = "S0",
* Collation = "SQL_LATIN1_GENERAL_CP1_CI_AS",
* MaxSizeBytes = "268435456000",
* CreateMode = "Default",
* });
* var exampleOutputMssql = new Azure.StreamAnalytics.OutputMssql("example", new()
* {
* Name = "example-output-sql",
* StreamAnalyticsJobName = example.Apply(getJobResult => getJobResult.Name),
* ResourceGroupName = example.Apply(getJobResult => getJobResult.ResourceGroupName),
* Server = exampleSqlServer.FullyQualifiedDomainName,
* User = exampleSqlServer.AdministratorLogin,
* Password = exampleSqlServer.AdministratorLoginPassword,
* Database = exampleDatabase.Name,
* Table = "ExampleTable",
* });
* });
* ```
* ```go
* package main
* import (
* "github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
* "github.com/pulumi/pulumi-azure/sdk/v5/go/azure/sql"
* "github.com/pulumi/pulumi-azure/sdk/v5/go/azure/streamanalytics"
* "github.com/pulumi/pulumi/sdk/v3/go/pulumi"
* )
* func main() {
* pulumi.Run(func(ctx *pulumi.Context) error {
* exampleResourceGroup, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
* Name: pulumi.String("rg-example"),
* Location: pulumi.String("West Europe"),
* })
* if err != nil {
* return err
* }
* example := streamanalytics.LookupJobOutput(ctx, streamanalytics.GetJobOutputArgs{
* Name: pulumi.String("example-job"),
* ResourceGroupName: exampleResourceGroup.Name,
* }, nil)
* exampleSqlServer, err := sql.NewSqlServer(ctx, "example", &sql.SqlServerArgs{
* Name: pulumi.String("example-server"),
* ResourceGroupName: exampleResourceGroup.Name,
* Location: exampleResourceGroup.Location,
* Version: pulumi.String("12.0"),
* AdministratorLogin: pulumi.String("dbadmin"),
* AdministratorLoginPassword: pulumi.String("example-password"),
* })
* if err != nil {
* return err
* }
* exampleDatabase, err := sql.NewDatabase(ctx, "example", &sql.DatabaseArgs{
* Name: pulumi.String("exampledb"),
* ResourceGroupName: exampleResourceGroup.Name,
* Location: exampleResourceGroup.Location,
* ServerName: exampleSqlServer.Name,
* RequestedServiceObjectiveName: pulumi.String("S0"),
* Collation: pulumi.String("SQL_LATIN1_GENERAL_CP1_CI_AS"),
* MaxSizeBytes: pulumi.String("268435456000"),
* CreateMode: pulumi.String("Default"),
* })
* if err != nil {
* return err
* }
* _, err = streamanalytics.NewOutputMssql(ctx, "example", &streamanalytics.OutputMssqlArgs{
* Name: pulumi.String("example-output-sql"),
* StreamAnalyticsJobName: example.ApplyT(func(example streamanalytics.GetJobResult) (*string, error) {
* return &example.Name, nil
* }).(pulumi.StringPtrOutput),
* ResourceGroupName: example.ApplyT(func(example streamanalytics.GetJobResult) (*string, error) {
* return &example.ResourceGroupName, nil
* }).(pulumi.StringPtrOutput),
* Server: exampleSqlServer.FullyQualifiedDomainName,
* User: exampleSqlServer.AdministratorLogin,
* Password: exampleSqlServer.AdministratorLoginPassword,
* Database: exampleDatabase.Name,
* Table: pulumi.String("ExampleTable"),
* })
* if err != nil {
* return err
* }
* return nil
* })
* }
* ```
* ```java
* 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());
* }
* }
* ```
* ```yaml
* resources:
* exampleResourceGroup:
* type: azure:core:ResourceGroup
* name: example
* properties:
* name: rg-example
* location: West Europe
* exampleSqlServer:
* type: azure:sql:SqlServer
* name: example
* properties:
* name: example-server
* resourceGroupName: ${exampleResourceGroup.name}
* location: ${exampleResourceGroup.location}
* version: '12.0'
* administratorLogin: dbadmin
* administratorLoginPassword: example-password
* exampleDatabase:
* type: azure:sql:Database
* name: example
* properties:
* name: exampledb
* resourceGroupName: ${exampleResourceGroup.name}
* location: ${exampleResourceGroup.location}
* serverName: ${exampleSqlServer.name}
* requestedServiceObjectiveName: S0
* collation: SQL_LATIN1_GENERAL_CP1_CI_AS
* maxSizeBytes: '268435456000'
* createMode: Default
* exampleOutputMssql:
* type: azure:streamanalytics:OutputMssql
* name: example
* properties:
* name: example-output-sql
* streamAnalyticsJobName: ${example.name}
* resourceGroupName: ${example.resourceGroupName}
* server: ${exampleSqlServer.fullyQualifiedDomainName}
* user: ${exampleSqlServer.administratorLogin}
* password: ${exampleSqlServer.administratorLoginPassword}
* database: ${exampleDatabase.name}
* table: ExampleTable
* variables:
* example:
* fn::invoke:
* Function: azure:streamanalytics:getJob
* Arguments:
* name: example-job
* resourceGroupName: ${exampleResourceGroup.name}
* ```
*
* ## Import
* Stream Analytics Outputs to Microsoft SQL Server Database can be imported using the `resource id`, e.g.
* ```sh
* $ pulumi import azure:streamanalytics/outputMssql:OutputMssql example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.StreamAnalytics/streamingJobs/job1/outputs/output1
* ```
* @property authenticationMode The authentication mode for the Stream Output. Possible values are `Msi` and `ConnectionString`. Defaults to `ConnectionString`.
* @property database The MS SQL database name where the reference table exists. Changing this forces a new resource to be created.
* @property maxBatchCount The max batch count to write to the SQL Database. Defaults to `10000`. Possible values are between `1` and `1073741824`.
* @property maxWriterCount 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.
* @property name The name of the Stream Output. Changing this forces a new resource to be created.
* @property password Password used together with username, to login to the Microsoft SQL Server. Required if `authentication_mode` is `ConnectionString`.
* @property resourceGroupName The name of the Resource Group where the Stream Analytics Job exists. Changing this forces a new resource to be created.
* @property server The SQL server url. Changing this forces a new resource to be created.
* @property streamAnalyticsJobName The name of the Stream Analytics Job. Changing this forces a new resource to be created.
* @property table Table in the database that the output points to. Changing this forces a new resource to be created.
* @property user Username used to login to the Microsoft SQL Server. Changing this forces a new resource to be created. Required if `authentication_mode` is `ConnectionString`.
*/
public data class OutputMssqlArgs(
public val authenticationMode: Output? = null,
public val database: Output? = null,
public val maxBatchCount: Output? = null,
public val maxWriterCount: Output? = null,
public val name: Output? = null,
public val password: Output? = null,
public val resourceGroupName: Output? = null,
public val server: Output? = null,
public val streamAnalyticsJobName: Output? = null,
public val table: Output? = null,
public val user: Output? = null,
) : ConvertibleToJava {
override fun toJava(): com.pulumi.azure.streamanalytics.OutputMssqlArgs =
com.pulumi.azure.streamanalytics.OutputMssqlArgs.builder()
.authenticationMode(authenticationMode?.applyValue({ args0 -> args0 }))
.database(database?.applyValue({ args0 -> args0 }))
.maxBatchCount(maxBatchCount?.applyValue({ args0 -> args0 }))
.maxWriterCount(maxWriterCount?.applyValue({ args0 -> args0 }))
.name(name?.applyValue({ args0 -> args0 }))
.password(password?.applyValue({ args0 -> args0 }))
.resourceGroupName(resourceGroupName?.applyValue({ args0 -> args0 }))
.server(server?.applyValue({ args0 -> args0 }))
.streamAnalyticsJobName(streamAnalyticsJobName?.applyValue({ args0 -> args0 }))
.table(table?.applyValue({ args0 -> args0 }))
.user(user?.applyValue({ args0 -> args0 })).build()
}
/**
* Builder for [OutputMssqlArgs].
*/
@PulumiTagMarker
public class OutputMssqlArgsBuilder internal constructor() {
private var authenticationMode: Output? = null
private var database: Output? = null
private var maxBatchCount: Output? = null
private var maxWriterCount: Output? = null
private var name: Output? = null
private var password: Output? = null
private var resourceGroupName: Output? = null
private var server: Output? = null
private var streamAnalyticsJobName: Output? = null
private var table: Output? = null
private var user: Output? = null
/**
* @param value The authentication mode for the Stream Output. Possible values are `Msi` and `ConnectionString`. Defaults to `ConnectionString`.
*/
@JvmName("vwavchvrqwadhqwd")
public suspend fun authenticationMode(`value`: Output) {
this.authenticationMode = value
}
/**
* @param value The MS SQL database name where the reference table exists. Changing this forces a new resource to be created.
*/
@JvmName("gftjpvumiqbhyfnk")
public suspend fun database(`value`: Output) {
this.database = value
}
/**
* @param value The max batch count to write to the SQL Database. Defaults to `10000`. Possible values are between `1` and `1073741824`.
*/
@JvmName("aguwlnsssvcixclw")
public suspend fun maxBatchCount(`value`: Output) {
this.maxBatchCount = value
}
/**
* @param value 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.
*/
@JvmName("hkrtffvgdthremfj")
public suspend fun maxWriterCount(`value`: Output) {
this.maxWriterCount = value
}
/**
* @param value The name of the Stream Output. Changing this forces a new resource to be created.
*/
@JvmName("letjtqplujwdpfqj")
public suspend fun name(`value`: Output) {
this.name = value
}
/**
* @param value Password used together with username, to login to the Microsoft SQL Server. Required if `authentication_mode` is `ConnectionString`.
*/
@JvmName("gfpiflmleqeymmvx")
public suspend fun password(`value`: Output) {
this.password = value
}
/**
* @param value The name of the Resource Group where the Stream Analytics Job exists. Changing this forces a new resource to be created.
*/
@JvmName("thhgnyulxjqhotom")
public suspend fun resourceGroupName(`value`: Output) {
this.resourceGroupName = value
}
/**
* @param value The SQL server url. Changing this forces a new resource to be created.
*/
@JvmName("xxvseqnfhrolnmkc")
public suspend fun server(`value`: Output) {
this.server = value
}
/**
* @param value The name of the Stream Analytics Job. Changing this forces a new resource to be created.
*/
@JvmName("rotjcahlhlbcevfy")
public suspend fun streamAnalyticsJobName(`value`: Output) {
this.streamAnalyticsJobName = value
}
/**
* @param value Table in the database that the output points to. Changing this forces a new resource to be created.
*/
@JvmName("yghjdugjtsgmgsdq")
public suspend fun table(`value`: Output) {
this.table = value
}
/**
* @param value Username used to login to the Microsoft SQL Server. Changing this forces a new resource to be created. Required if `authentication_mode` is `ConnectionString`.
*/
@JvmName("rxlfgxerhbsobseq")
public suspend fun user(`value`: Output) {
this.user = value
}
/**
* @param value The authentication mode for the Stream Output. Possible values are `Msi` and `ConnectionString`. Defaults to `ConnectionString`.
*/
@JvmName("cjqyagwamrauwuak")
public suspend fun authenticationMode(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.authenticationMode = mapped
}
/**
* @param value The MS SQL database name where the reference table exists. Changing this forces a new resource to be created.
*/
@JvmName("iigufpmqwagcxoth")
public suspend fun database(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.database = mapped
}
/**
* @param value The max batch count to write to the SQL Database. Defaults to `10000`. Possible values are between `1` and `1073741824`.
*/
@JvmName("lqfbscxtrexnhaoe")
public suspend fun maxBatchCount(`value`: Double?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.maxBatchCount = mapped
}
/**
* @param value 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.
*/
@JvmName("flglfaelswssjjeo")
public suspend fun maxWriterCount(`value`: Double?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.maxWriterCount = mapped
}
/**
* @param value The name of the Stream Output. Changing this forces a new resource to be created.
*/
@JvmName("sfexybnsnolsluhv")
public suspend fun name(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.name = mapped
}
/**
* @param value Password used together with username, to login to the Microsoft SQL Server. Required if `authentication_mode` is `ConnectionString`.
*/
@JvmName("dcrsuvqynasxifng")
public suspend fun password(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.password = mapped
}
/**
* @param value The name of the Resource Group where the Stream Analytics Job exists. Changing this forces a new resource to be created.
*/
@JvmName("egtdaocbxxcgfgvv")
public suspend fun resourceGroupName(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.resourceGroupName = mapped
}
/**
* @param value The SQL server url. Changing this forces a new resource to be created.
*/
@JvmName("twafbjvhmphkwnvf")
public suspend fun server(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.server = mapped
}
/**
* @param value The name of the Stream Analytics Job. Changing this forces a new resource to be created.
*/
@JvmName("mhkeyouelfrkilbu")
public suspend fun streamAnalyticsJobName(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.streamAnalyticsJobName = mapped
}
/**
* @param value Table in the database that the output points to. Changing this forces a new resource to be created.
*/
@JvmName("ursbkcmyqhgyhrae")
public suspend fun table(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.table = mapped
}
/**
* @param value Username used to login to the Microsoft SQL Server. Changing this forces a new resource to be created. Required if `authentication_mode` is `ConnectionString`.
*/
@JvmName("ggaliiveycvubtct")
public suspend fun user(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.user = mapped
}
internal fun build(): OutputMssqlArgs = OutputMssqlArgs(
authenticationMode = authenticationMode,
database = database,
maxBatchCount = maxBatchCount,
maxWriterCount = maxWriterCount,
name = name,
password = password,
resourceGroupName = resourceGroupName,
server = server,
streamAnalyticsJobName = streamAnalyticsJobName,
table = table,
user = user,
)
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy