airbyte 0.7.0-beta2, Mar 7 25

airbyte 0.7.0-beta2 published on Friday, Mar 7, 2025 by airbytehq

airbyte.DestinationMssql

Explore with Pulumi AI

airbyte 0.7.0-beta2 published on Friday, Mar 7, 2025 by airbytehq

Example Usage

Coming soon!

Coming soon!

Coming soon!

Coming soon!

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.airbyte.DestinationMssql;
import com.pulumi.airbyte.DestinationMssqlArgs;
import com.pulumi.airbyte.inputs.DestinationMssqlConfigurationArgs;
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 myDestinationMssql = new DestinationMssql("myDestinationMssql", DestinationMssqlArgs.builder()
            .configuration(DestinationMssqlConfigurationArgs.builder()
                .database("...my_database...")
                .host("...my_host...")
                .jdbc_url_params("...my_jdbc_url_params...")
                .password("...my_password...")
                .port(1433)
                .raw_data_schema("...my_raw_data_schema...")
                .schema("public")
                .ssl_method(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
                .tunnel_method(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
                .username("...my_username...")
                .build())
            .definitionId("a282fec3-7b94-4274-9620-860fbc85f5d6")
            .workspaceId("2e9afd8a-c9ca-4f91-bf9f-71f1a7c362df")
            .build());

    }
}

resources:
  myDestinationMssql:
    type: airbyte:DestinationMssql
    properties:
      configuration:
        database: '...my_database...'
        host: '...my_host...'
        jdbc_url_params: '...my_jdbc_url_params...'
        password: '...my_password...'
        port: 1433
        raw_data_schema: '...my_raw_data_schema...'
        schema: public
        ssl_method:
          encryptedTrustServerCertificate: {}
          encryptedVerifyCertificate:
            hostNameInCertificate: '...my_host_name_in_certificate...'
          unencrypted: {}
        tunnel_method:
          noTunnel: {}
          passwordAuthentication:
            tunnelHost: '...my_tunnel_host...'
            tunnelPort: 22
            tunnelUser: '...my_tunnel_user...'
            tunnelUserPassword: '...my_tunnel_user_password...'
          sshKeyAuthentication:
            sshKey: '...my_ssh_key...'
            tunnelHost: '...my_tunnel_host...'
            tunnelPort: 22
            tunnelUser: '...my_tunnel_user...'
        username: '...my_username...'
      definitionId: a282fec3-7b94-4274-9620-860fbc85f5d6
      workspaceId: 2e9afd8a-c9ca-4f91-bf9f-71f1a7c362df

Create DestinationMssql Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new DestinationMssql(name: string, args: DestinationMssqlArgs, opts?: CustomResourceOptions);

@overload
def DestinationMssql(resource_name: str,
                     args: DestinationMssqlArgs,
                     opts: Optional[ResourceOptions] = None)

@overload
def DestinationMssql(resource_name: str,
                     opts: Optional[ResourceOptions] = None,
                     configuration: Optional[DestinationMssqlConfigurationArgs] = None,
                     workspace_id: Optional[str] = None,
                     definition_id: Optional[str] = None,
                     name: Optional[str] = None)

func NewDestinationMssql(ctx *Context, name string, args DestinationMssqlArgs, opts ...ResourceOption) (*DestinationMssql, error)

public DestinationMssql(string name, DestinationMssqlArgs args, CustomResourceOptions? opts = null)

public DestinationMssql(String name, DestinationMssqlArgs args)
public DestinationMssql(String name, DestinationMssqlArgs args, CustomResourceOptions options)

type: airbyte:DestinationMssql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name string: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

var destinationMssqlResource = new Airbyte.DestinationMssql("destinationMssqlResource", new()
{
    Configuration = new Airbyte.Inputs.DestinationMssqlConfigurationArgs
    {
        Database = "string",
        Host = "string",
        Username = "string",
        JdbcUrlParams = "string",
        Password = "string",
        Port = 0,
        RawDataSchema = "string",
        Schema = "string",
        SslMethod = new Airbyte.Inputs.DestinationMssqlConfigurationSslMethodArgs
        {
            EncryptedTrustServerCertificate = null,
            EncryptedVerifyCertificate = new Airbyte.Inputs.DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs
            {
                HostNameInCertificate = "string",
            },
            Unencrypted = null,
        },
        TunnelMethod = new Airbyte.Inputs.DestinationMssqlConfigurationTunnelMethodArgs
        {
            NoTunnel = null,
            PasswordAuthentication = new Airbyte.Inputs.DestinationMssqlConfigurationTunnelMethodPasswordAuthenticationArgs
            {
                TunnelHost = "string",
                TunnelUser = "string",
                TunnelUserPassword = "string",
                TunnelPort = 0,
            },
            SshKeyAuthentication = new Airbyte.Inputs.DestinationMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs
            {
                SshKey = "string",
                TunnelHost = "string",
                TunnelUser = "string",
                TunnelPort = 0,
            },
        },
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
});

example, err := airbyte.NewDestinationMssql(ctx, "destinationMssqlResource", &airbyte.DestinationMssqlArgs{
Configuration: &.DestinationMssqlConfigurationArgs{
Database: pulumi.String("string"),
Host: pulumi.String("string"),
Username: pulumi.String("string"),
JdbcUrlParams: pulumi.String("string"),
Password: pulumi.String("string"),
Port: pulumi.Float64(0),
RawDataSchema: pulumi.String("string"),
Schema: pulumi.String("string"),
SslMethod: &.DestinationMssqlConfigurationSslMethodArgs{
EncryptedTrustServerCertificate: &.DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificateArgs{
},
EncryptedVerifyCertificate: &.DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs{
HostNameInCertificate: pulumi.String("string"),
},
Unencrypted: &.DestinationMssqlConfigurationSslMethodUnencryptedArgs{
},
},
TunnelMethod: &.DestinationMssqlConfigurationTunnelMethodArgs{
NoTunnel: &.DestinationMssqlConfigurationTunnelMethodNoTunnelArgs{
},
PasswordAuthentication: &.DestinationMssqlConfigurationTunnelMethodPasswordAuthenticationArgs{
TunnelHost: pulumi.String("string"),
TunnelUser: pulumi.String("string"),
TunnelUserPassword: pulumi.String("string"),
TunnelPort: pulumi.Float64(0),
},
SshKeyAuthentication: &.DestinationMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs{
SshKey: pulumi.String("string"),
TunnelHost: pulumi.String("string"),
TunnelUser: pulumi.String("string"),
TunnelPort: pulumi.Float64(0),
},
},
},
WorkspaceId: pulumi.String("string"),
DefinitionId: pulumi.String("string"),
Name: pulumi.String("string"),
})

var destinationMssqlResource = new DestinationMssql("destinationMssqlResource", DestinationMssqlArgs.builder()
    .configuration(DestinationMssqlConfigurationArgs.builder()
        .database("string")
        .host("string")
        .username("string")
        .jdbcUrlParams("string")
        .password("string")
        .port(0)
        .rawDataSchema("string")
        .schema("string")
        .sslMethod(DestinationMssqlConfigurationSslMethodArgs.builder()
            .encryptedTrustServerCertificate()
            .encryptedVerifyCertificate(DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs.builder()
                .hostNameInCertificate("string")
                .build())
            .unencrypted()
            .build())
        .tunnelMethod(DestinationMssqlConfigurationTunnelMethodArgs.builder()
            .noTunnel()
            .passwordAuthentication(DestinationMssqlConfigurationTunnelMethodPasswordAuthenticationArgs.builder()
                .tunnelHost("string")
                .tunnelUser("string")
                .tunnelUserPassword("string")
                .tunnelPort(0)
                .build())
            .sshKeyAuthentication(DestinationMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs.builder()
                .sshKey("string")
                .tunnelHost("string")
                .tunnelUser("string")
                .tunnelPort(0)
                .build())
            .build())
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .build());

destination_mssql_resource = airbyte.DestinationMssql("destinationMssqlResource",
    configuration={
        "database": "string",
        "host": "string",
        "username": "string",
        "jdbc_url_params": "string",
        "password": "string",
        "port": 0,
        "raw_data_schema": "string",
        "schema": "string",
        "ssl_method": {
            "encrypted_trust_server_certificate": {},
            "encrypted_verify_certificate": {
                "host_name_in_certificate": "string",
            },
            "unencrypted": {},
        },
        "tunnel_method": {
            "no_tunnel": {},
            "password_authentication": {
                "tunnel_host": "string",
                "tunnel_user": "string",
                "tunnel_user_password": "string",
                "tunnel_port": 0,
            },
            "ssh_key_authentication": {
                "ssh_key": "string",
                "tunnel_host": "string",
                "tunnel_user": "string",
                "tunnel_port": 0,
            },
        },
    },
    workspace_id="string",
    definition_id="string",
    name="string")

const destinationMssqlResource = new airbyte.DestinationMssql("destinationMssqlResource", {
    configuration: {
        database: "string",
        host: "string",
        username: "string",
        jdbcUrlParams: "string",
        password: "string",
        port: 0,
        rawDataSchema: "string",
        schema: "string",
        sslMethod: {
            encryptedTrustServerCertificate: {},
            encryptedVerifyCertificate: {
                hostNameInCertificate: "string",
            },
            unencrypted: {},
        },
        tunnelMethod: {
            noTunnel: {},
            passwordAuthentication: {
                tunnelHost: "string",
                tunnelUser: "string",
                tunnelUserPassword: "string",
                tunnelPort: 0,
            },
            sshKeyAuthentication: {
                sshKey: "string",
                tunnelHost: "string",
                tunnelUser: "string",
                tunnelPort: 0,
            },
        },
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
});

type: airbyte:DestinationMssql
properties:
    configuration:
        database: string
        host: string
        jdbcUrlParams: string
        password: string
        port: 0
        rawDataSchema: string
        schema: string
        sslMethod:
            encryptedTrustServerCertificate: {}
            encryptedVerifyCertificate:
                hostNameInCertificate: string
            unencrypted: {}
        tunnelMethod:
            noTunnel: {}
            passwordAuthentication:
                tunnelHost: string
                tunnelPort: 0
                tunnelUser: string
                tunnelUserPassword: string
            sshKeyAuthentication:
                sshKey: string
                tunnelHost: string
                tunnelPort: 0
                tunnelUser: string
        username: string
    definitionId: string
    name: string
    workspaceId: string

DestinationMssql Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The DestinationMssql resource accepts the following input properties:

Configuration DestinationMssqlConfiguration
WorkspaceId string
DefinitionId string: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
Name string: Name of the destination e.g. dev-mysql-instance.

Configuration DestinationMssqlConfigurationArgs
WorkspaceId string
DefinitionId string: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
Name string: Name of the destination e.g. dev-mysql-instance.

configuration DestinationMssqlConfiguration
workspaceId String
definitionId String: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name String: Name of the destination e.g. dev-mysql-instance.

configuration DestinationMssqlConfiguration
workspaceId string
definitionId string: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name string: Name of the destination e.g. dev-mysql-instance.

configuration DestinationMssqlConfigurationArgs
workspace_id str
definition_id str: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name str: Name of the destination e.g. dev-mysql-instance.

configuration Property Map
workspaceId String
definitionId String: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name String: Name of the destination e.g. dev-mysql-instance.

Outputs

All input properties are implicitly available as output properties. Additionally, the DestinationMssql resource produces the following output properties:

CreatedAt double
DestinationId string
DestinationType string
Id string: The provider-assigned unique ID for this managed resource.

CreatedAt float64
DestinationId string
DestinationType string
Id string: The provider-assigned unique ID for this managed resource.

createdAt Double
destinationId String
destinationType String
id String: The provider-assigned unique ID for this managed resource.

createdAt number
destinationId string
destinationType string
id string: The provider-assigned unique ID for this managed resource.

created_at float
destination_id str
destination_type str
id str: The provider-assigned unique ID for this managed resource.

createdAt Number
destinationId String
destinationType String
id String: The provider-assigned unique ID for this managed resource.

Look up Existing DestinationMssql Resource

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

public static get(name: string, id: Input<ID>, state?: DestinationMssqlState, opts?: CustomResourceOptions): DestinationMssql

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[DestinationMssqlConfigurationArgs] = None,
        created_at: Optional[float] = None,
        definition_id: Optional[str] = None,
        destination_id: Optional[str] = None,
        destination_type: Optional[str] = None,
        name: Optional[str] = None,
        workspace_id: Optional[str] = None) -> DestinationMssql

func GetDestinationMssql(ctx *Context, name string, id IDInput, state *DestinationMssqlState, opts ...ResourceOption) (*DestinationMssql, error)

public static DestinationMssql Get(string name, Input<string> id, DestinationMssqlState? state, CustomResourceOptions? opts = null)

public static DestinationMssql get(String name, Output<String> id, DestinationMssqlState state, CustomResourceOptions options)

resources:  _:    type: airbyte:DestinationMssql    get:      id: ${id}

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

resource_name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

The following state arguments are supported:

Configuration DestinationMssqlConfiguration
CreatedAt double
DefinitionId string: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
DestinationId string
DestinationType string
Name string: Name of the destination e.g. dev-mysql-instance.
WorkspaceId string

Configuration DestinationMssqlConfigurationArgs
CreatedAt float64
DefinitionId string: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
DestinationId string
DestinationType string
Name string: Name of the destination e.g. dev-mysql-instance.
WorkspaceId string

configuration DestinationMssqlConfiguration
createdAt Double
definitionId String: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destinationId String
destinationType String
name String: Name of the destination e.g. dev-mysql-instance.
workspaceId String

configuration DestinationMssqlConfiguration
createdAt number
definitionId string: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destinationId string
destinationType string
name string: Name of the destination e.g. dev-mysql-instance.
workspaceId string

configuration DestinationMssqlConfigurationArgs
created_at float
definition_id str: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destination_id str
destination_type str
name str: Name of the destination e.g. dev-mysql-instance.
workspace_id str

configuration Property Map
createdAt Number
definitionId String: The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destinationId String
destinationType String
name String: Name of the destination e.g. dev-mysql-instance.
workspaceId String

Supporting Types

DestinationMssqlConfiguration, DestinationMssqlConfigurationArgs

Database string: The name of the MSSQL database.
Host string: The host name of the MSSQL database.
Username string: The username which is used to access the database.
JdbcUrlParams string: Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
Password string: The password associated with this username.
Port double: The port of the MSSQL database. Default: 1433
RawDataSchema string: The schema to write raw tables into (default: airbyte_internal)
Schema string: The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
SslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
TunnelMethod DestinationMssqlConfigurationTunnelMethod: Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

Database string: The name of the MSSQL database.
Host string: The host name of the MSSQL database.
Username string: The username which is used to access the database.
JdbcUrlParams string: Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
Password string: The password associated with this username.
Port float64: The port of the MSSQL database. Default: 1433
RawDataSchema string: The schema to write raw tables into (default: airbyte_internal)
Schema string: The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
SslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
TunnelMethod DestinationMssqlConfigurationTunnelMethod: Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database String: The name of the MSSQL database.
host String: The host name of the MSSQL database.
username String: The username which is used to access the database.
jdbcUrlParams String: Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
password String: The password associated with this username.
port Double: The port of the MSSQL database. Default: 1433
rawDataSchema String: The schema to write raw tables into (default: airbyte_internal)
schema String: The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
sslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
tunnelMethod DestinationMssqlConfigurationTunnelMethod: Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database string: The name of the MSSQL database.
host string: The host name of the MSSQL database.
username string: The username which is used to access the database.
jdbcUrlParams string: Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
password string: The password associated with this username.
port number: The port of the MSSQL database. Default: 1433
rawDataSchema string: The schema to write raw tables into (default: airbyte_internal)
schema string: The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
sslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
tunnelMethod DestinationMssqlConfigurationTunnelMethod: Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database str: The name of the MSSQL database.
host str: The host name of the MSSQL database.
username str: The username which is used to access the database.
jdbc_url_params str: Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
password str: The password associated with this username.
port float: The port of the MSSQL database. Default: 1433
raw_data_schema str: The schema to write raw tables into (default: airbyte_internal)
schema str: The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
ssl_method DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
tunnel_method DestinationMssqlConfigurationTunnelMethod: Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

database String: The name of the MSSQL database.
host String: The host name of the MSSQL database.
username String: The username which is used to access the database.
jdbcUrlParams String: Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
password String: The password associated with this username.
port Number: The port of the MSSQL database. Default: 1433
rawDataSchema String: The schema to write raw tables into (default: airbyte_internal)
schema String: The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
sslMethod Property Map: The encryption method which is used to communicate with the database.
tunnelMethod Property Map: Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

DestinationMssqlConfigurationSslMethod, DestinationMssqlConfigurationSslMethodArgs

EncryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
EncryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
Unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

EncryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
EncryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
Unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encrypted_trust_server_certificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
encrypted_verify_certificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encryptedTrustServerCertificate Property Map: Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate Property Map: Verify and use the certificate provided by the server.
unencrypted Property Map: The data transfer will not be encrypted.

DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate, DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs

HostNameInCertificate string: Specifies the host name of the server. The value of this property must match the subject property of the certificate.

HostNameInCertificate string: Specifies the host name of the server. The value of this property must match the subject property of the certificate.

hostNameInCertificate String: Specifies the host name of the server. The value of this property must match the subject property of the certificate.

hostNameInCertificate string: Specifies the host name of the server. The value of this property must match the subject property of the certificate.

host_name_in_certificate str: Specifies the host name of the server. The value of this property must match the subject property of the certificate.

hostNameInCertificate String: Specifies the host name of the server. The value of this property must match the subject property of the certificate.

DestinationMssqlConfigurationTunnelMethod, DestinationMssqlConfigurationTunnelMethodArgs

NoTunnel DestinationMssqlConfigurationTunnelMethodNoTunnel
PasswordAuthentication DestinationMssqlConfigurationTunnelMethodPasswordAuthentication
SshKeyAuthentication DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication

NoTunnel DestinationMssqlConfigurationTunnelMethodNoTunnel
PasswordAuthentication DestinationMssqlConfigurationTunnelMethodPasswordAuthentication
SshKeyAuthentication DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication

noTunnel DestinationMssqlConfigurationTunnelMethodNoTunnel
passwordAuthentication DestinationMssqlConfigurationTunnelMethodPasswordAuthentication
sshKeyAuthentication DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication

noTunnel DestinationMssqlConfigurationTunnelMethodNoTunnel
passwordAuthentication DestinationMssqlConfigurationTunnelMethodPasswordAuthentication
sshKeyAuthentication DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication

no_tunnel DestinationMssqlConfigurationTunnelMethodNoTunnel
password_authentication DestinationMssqlConfigurationTunnelMethodPasswordAuthentication
ssh_key_authentication DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication

noTunnel Property Map
passwordAuthentication Property Map
sshKeyAuthentication Property Map

DestinationMssqlConfigurationTunnelMethodPasswordAuthentication, DestinationMssqlConfigurationTunnelMethodPasswordAuthenticationArgs

TunnelHost string: Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser string: OS-level username for logging into the jump server host
TunnelUserPassword string: OS-level password for logging into the jump server host
TunnelPort double: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

TunnelHost string: Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser string: OS-level username for logging into the jump server host
TunnelUserPassword string: OS-level password for logging into the jump server host
TunnelPort float64: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

tunnelHost String: Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser String: OS-level username for logging into the jump server host
tunnelUserPassword String: OS-level password for logging into the jump server host
tunnelPort Double: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

tunnelHost string: Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser string: OS-level username for logging into the jump server host
tunnelUserPassword string: OS-level password for logging into the jump server host
tunnelPort number: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

tunnel_host str: Hostname of the jump server host that allows inbound ssh tunnel.
tunnel_user str: OS-level username for logging into the jump server host
tunnel_user_password str: OS-level password for logging into the jump server host
tunnel_port float: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

tunnelHost String: Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser String: OS-level username for logging into the jump server host
tunnelUserPassword String: OS-level password for logging into the jump server host
tunnelPort Number: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication, DestinationMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs

SshKey string: OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
TunnelHost string: Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser string: OS-level username for logging into the jump server host.
TunnelPort double: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

SshKey string: OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
TunnelHost string: Hostname of the jump server host that allows inbound ssh tunnel.
TunnelUser string: OS-level username for logging into the jump server host.
TunnelPort float64: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

sshKey String: OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnelHost String: Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser String: OS-level username for logging into the jump server host.
tunnelPort Double: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

sshKey string: OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnelHost string: Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser string: OS-level username for logging into the jump server host.
tunnelPort number: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

ssh_key str: OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnel_host str: Hostname of the jump server host that allows inbound ssh tunnel.
tunnel_user str: OS-level username for logging into the jump server host.
tunnel_port float: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

sshKey String: OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
tunnelHost String: Hostname of the jump server host that allows inbound ssh tunnel.
tunnelUser String: OS-level username for logging into the jump server host.
tunnelPort Number: Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

Import

$ pulumi import airbyte:index/destinationMssql:DestinationMssql my_airbyte_destination_mssql ""

To learn more about importing existing cloud resources, see Importing resources.

Package Details

Repository: airbyte airbytehq/terraform-provider-airbyte
License
Notes: This Pulumi package is based on the airbyte Terraform Provider.

airbyte 0.7.0-beta2 published on Friday, Mar 7, 2025 by airbytehq

airbytehq/terraform-provider-airbyte

airbyte.DestinationMssql

On this page

On this page

Example Usage

Create DestinationMssql Resource

Constructor syntax

Parameters

Constructor example

DestinationMssql Resource Properties

Inputs

Outputs

Look up Existing DestinationMssql Resource

Supporting Types

DestinationMssqlConfiguration, DestinationMssqlConfigurationArgs

DestinationMssqlConfigurationSslMethod, DestinationMssqlConfigurationSslMethodArgs

DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate, DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs

DestinationMssqlConfigurationTunnelMethod, DestinationMssqlConfigurationTunnelMethodArgs

DestinationMssqlConfigurationTunnelMethodPasswordAuthentication, DestinationMssqlConfigurationTunnelMethodPasswordAuthenticationArgs

DestinationMssqlConfigurationTunnelMethodSshKeyAuthentication, DestinationMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs

Import

Package Details

On this page

On this page