Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi IDP Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. ExternalDatabaseConnector
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.Database.ExternalDatabaseConnector

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This resource provides the External Database Connector resource in Oracle Cloud Infrastructure Database service.

    Creates a new external database connector.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testExternalDatabaseConnector = new oci.database.ExternalDatabaseConnector("test_external_database_connector", {
    connectionCredentials: {
        credentialName: externalDatabaseConnectorConnectionCredentialsCredentialName,
        credentialType: externalDatabaseConnectorConnectionCredentialsCredentialType,
        password: externalDatabaseConnectorConnectionCredentialsPassword,
        role: externalDatabaseConnectorConnectionCredentialsRole,
        sslSecretId: testSecret.id,
        username: externalDatabaseConnectorConnectionCredentialsUsername,
    },
    connectionString: {
        hostname: externalDatabaseConnectorConnectionStringHostname,
        port: externalDatabaseConnectorConnectionStringPort,
        protocol: externalDatabaseConnectorConnectionStringProtocol,
        service: externalDatabaseConnectorConnectionStringService,
    },
    connectorAgentId: testConnectorAgent.id,
    displayName: externalDatabaseConnectorDisplayName,
    externalDatabaseId: testDatabase.id,
    connectorType: externalDatabaseConnectorConnectorType,
    definedTags: externalDatabaseConnectorDefinedTags,
    freeformTags: {
        Department: "Finance",
    },
});

    import pulumi
import pulumi_oci as oci

test_external_database_connector = oci.database.ExternalDatabaseConnector("test_external_database_connector",
    connection_credentials={
        "credential_name": external_database_connector_connection_credentials_credential_name,
        "credential_type": external_database_connector_connection_credentials_credential_type,
        "password": external_database_connector_connection_credentials_password,
        "role": external_database_connector_connection_credentials_role,
        "ssl_secret_id": test_secret["id"],
        "username": external_database_connector_connection_credentials_username,
    },
    connection_string={
        "hostname": external_database_connector_connection_string_hostname,
        "port": external_database_connector_connection_string_port,
        "protocol": external_database_connector_connection_string_protocol,
        "service": external_database_connector_connection_string_service,
    },
    connector_agent_id=test_connector_agent["id"],
    display_name=external_database_connector_display_name,
    external_database_id=test_database["id"],
    connector_type=external_database_connector_connector_type,
    defined_tags=external_database_connector_defined_tags,
    freeform_tags={
        "Department": "Finance",
    })

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/database"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := database.NewExternalDatabaseConnector(ctx, "test_external_database_connector", &database.ExternalDatabaseConnectorArgs{
			ConnectionCredentials: &database.ExternalDatabaseConnectorConnectionCredentialsArgs{
				CredentialName: pulumi.Any(externalDatabaseConnectorConnectionCredentialsCredentialName),
				CredentialType: pulumi.Any(externalDatabaseConnectorConnectionCredentialsCredentialType),
				Password:       pulumi.Any(externalDatabaseConnectorConnectionCredentialsPassword),
				Role:           pulumi.Any(externalDatabaseConnectorConnectionCredentialsRole),
				SslSecretId:    pulumi.Any(testSecret.Id),
				Username:       pulumi.Any(externalDatabaseConnectorConnectionCredentialsUsername),
			},
			ConnectionString: &database.ExternalDatabaseConnectorConnectionStringArgs{
				Hostname: pulumi.Any(externalDatabaseConnectorConnectionStringHostname),
				Port:     pulumi.Any(externalDatabaseConnectorConnectionStringPort),
				Protocol: pulumi.Any(externalDatabaseConnectorConnectionStringProtocol),
				Service:  pulumi.Any(externalDatabaseConnectorConnectionStringService),
			},
			ConnectorAgentId:   pulumi.Any(testConnectorAgent.Id),
			DisplayName:        pulumi.Any(externalDatabaseConnectorDisplayName),
			ExternalDatabaseId: pulumi.Any(testDatabase.Id),
			ConnectorType:      pulumi.Any(externalDatabaseConnectorConnectorType),
			DefinedTags:        pulumi.Any(externalDatabaseConnectorDefinedTags),
			FreeformTags: pulumi.StringMap{
				"Department": pulumi.String("Finance"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testExternalDatabaseConnector = new Oci.Database.ExternalDatabaseConnector("test_external_database_connector", new()
    {
        ConnectionCredentials = new Oci.Database.Inputs.ExternalDatabaseConnectorConnectionCredentialsArgs
        {
            CredentialName = externalDatabaseConnectorConnectionCredentialsCredentialName,
            CredentialType = externalDatabaseConnectorConnectionCredentialsCredentialType,
            Password = externalDatabaseConnectorConnectionCredentialsPassword,
            Role = externalDatabaseConnectorConnectionCredentialsRole,
            SslSecretId = testSecret.Id,
            Username = externalDatabaseConnectorConnectionCredentialsUsername,
        },
        ConnectionString = new Oci.Database.Inputs.ExternalDatabaseConnectorConnectionStringArgs
        {
            Hostname = externalDatabaseConnectorConnectionStringHostname,
            Port = externalDatabaseConnectorConnectionStringPort,
            Protocol = externalDatabaseConnectorConnectionStringProtocol,
            Service = externalDatabaseConnectorConnectionStringService,
        },
        ConnectorAgentId = testConnectorAgent.Id,
        DisplayName = externalDatabaseConnectorDisplayName,
        ExternalDatabaseId = testDatabase.Id,
        ConnectorType = externalDatabaseConnectorConnectorType,
        DefinedTags = externalDatabaseConnectorDefinedTags,
        FreeformTags = 
        {
            { "Department", "Finance" },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.ExternalDatabaseConnector;
import com.pulumi.oci.Database.ExternalDatabaseConnectorArgs;
import com.pulumi.oci.Database.inputs.ExternalDatabaseConnectorConnectionCredentialsArgs;
import com.pulumi.oci.Database.inputs.ExternalDatabaseConnectorConnectionStringArgs;
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 testExternalDatabaseConnector = new ExternalDatabaseConnector("testExternalDatabaseConnector", ExternalDatabaseConnectorArgs.builder()
            .connectionCredentials(ExternalDatabaseConnectorConnectionCredentialsArgs.builder()
                .credentialName(externalDatabaseConnectorConnectionCredentialsCredentialName)
                .credentialType(externalDatabaseConnectorConnectionCredentialsCredentialType)
                .password(externalDatabaseConnectorConnectionCredentialsPassword)
                .role(externalDatabaseConnectorConnectionCredentialsRole)
                .sslSecretId(testSecret.id())
                .username(externalDatabaseConnectorConnectionCredentialsUsername)
                .build())
            .connectionString(ExternalDatabaseConnectorConnectionStringArgs.builder()
                .hostname(externalDatabaseConnectorConnectionStringHostname)
                .port(externalDatabaseConnectorConnectionStringPort)
                .protocol(externalDatabaseConnectorConnectionStringProtocol)
                .service(externalDatabaseConnectorConnectionStringService)
                .build())
            .connectorAgentId(testConnectorAgent.id())
            .displayName(externalDatabaseConnectorDisplayName)
            .externalDatabaseId(testDatabase.id())
            .connectorType(externalDatabaseConnectorConnectorType)
            .definedTags(externalDatabaseConnectorDefinedTags)
            .freeformTags(Map.of("Department", "Finance"))
            .build());

    }
}

    resources:
  testExternalDatabaseConnector:
    type: oci:Database:ExternalDatabaseConnector
    name: test_external_database_connector
    properties:
      connectionCredentials:
        credentialName: ${externalDatabaseConnectorConnectionCredentialsCredentialName}
        credentialType: ${externalDatabaseConnectorConnectionCredentialsCredentialType}
        password: ${externalDatabaseConnectorConnectionCredentialsPassword}
        role: ${externalDatabaseConnectorConnectionCredentialsRole}
        sslSecretId: ${testSecret.id}
        username: ${externalDatabaseConnectorConnectionCredentialsUsername}
      connectionString:
        hostname: ${externalDatabaseConnectorConnectionStringHostname}
        port: ${externalDatabaseConnectorConnectionStringPort}
        protocol: ${externalDatabaseConnectorConnectionStringProtocol}
        service: ${externalDatabaseConnectorConnectionStringService}
      connectorAgentId: ${testConnectorAgent.id}
      displayName: ${externalDatabaseConnectorDisplayName}
      externalDatabaseId: ${testDatabase.id}
      connectorType: ${externalDatabaseConnectorConnectorType}
      definedTags: ${externalDatabaseConnectorDefinedTags}
      freeformTags:
        Department: Finance

    Create ExternalDatabaseConnector Resource

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

    Constructor syntax

    new ExternalDatabaseConnector(name: string, args: ExternalDatabaseConnectorArgs, opts?: CustomResourceOptions);
    @overload
def ExternalDatabaseConnector(resource_name: str,
                              args: ExternalDatabaseConnectorArgs,
                              opts: Optional[ResourceOptions] = None)

@overload
def ExternalDatabaseConnector(resource_name: str,
                              opts: Optional[ResourceOptions] = None,
                              connection_credentials: Optional[ExternalDatabaseConnectorConnectionCredentialsArgs] = None,
                              connection_string: Optional[ExternalDatabaseConnectorConnectionStringArgs] = None,
                              connector_agent_id: Optional[str] = None,
                              display_name: Optional[str] = None,
                              external_database_id: Optional[str] = None,
                              connector_type: Optional[str] = None,
                              defined_tags: Optional[Mapping[str, str]] = None,
                              freeform_tags: Optional[Mapping[str, str]] = None)
    func NewExternalDatabaseConnector(ctx *Context, name string, args ExternalDatabaseConnectorArgs, opts ...ResourceOption) (*ExternalDatabaseConnector, error)
    public ExternalDatabaseConnector(string name, ExternalDatabaseConnectorArgs args, CustomResourceOptions? opts = null)
    public ExternalDatabaseConnector(String name, ExternalDatabaseConnectorArgs args)
public ExternalDatabaseConnector(String name, ExternalDatabaseConnectorArgs args, CustomResourceOptions options)

    type: oci:Database:ExternalDatabaseConnector
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 ExternalDatabaseConnectorArgs
    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 ExternalDatabaseConnectorArgs
    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 ExternalDatabaseConnectorArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ExternalDatabaseConnectorArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ExternalDatabaseConnectorArgs
    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 externalDatabaseConnectorResource = new Oci.Database.ExternalDatabaseConnector("externalDatabaseConnectorResource", new()
{
    ConnectionCredentials = new Oci.Database.Inputs.ExternalDatabaseConnectorConnectionCredentialsArgs
    {
        CredentialName = "string",
        CredentialType = "string",
        Password = "string",
        Role = "string",
        SslSecretId = "string",
        Username = "string",
    },
    ConnectionString = new Oci.Database.Inputs.ExternalDatabaseConnectorConnectionStringArgs
    {
        Hostname = "string",
        Port = 0,
        Protocol = "string",
        Service = "string",
    },
    ConnectorAgentId = "string",
    DisplayName = "string",
    ExternalDatabaseId = "string",
    ConnectorType = "string",
    DefinedTags = 
    {
        { "string", "string" },
    },
    FreeformTags = 
    {
        { "string", "string" },
    },
});

    example, err := database.NewExternalDatabaseConnector(ctx, "externalDatabaseConnectorResource", &database.ExternalDatabaseConnectorArgs{
	ConnectionCredentials: &database.ExternalDatabaseConnectorConnectionCredentialsArgs{
		CredentialName: pulumi.String("string"),
		CredentialType: pulumi.String("string"),
		Password:       pulumi.String("string"),
		Role:           pulumi.String("string"),
		SslSecretId:    pulumi.String("string"),
		Username:       pulumi.String("string"),
	},
	ConnectionString: &database.ExternalDatabaseConnectorConnectionStringArgs{
		Hostname: pulumi.String("string"),
		Port:     pulumi.Int(0),
		Protocol: pulumi.String("string"),
		Service:  pulumi.String("string"),
	},
	ConnectorAgentId:   pulumi.String("string"),
	DisplayName:        pulumi.String("string"),
	ExternalDatabaseId: pulumi.String("string"),
	ConnectorType:      pulumi.String("string"),
	DefinedTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	FreeformTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
})

    var externalDatabaseConnectorResource = new ExternalDatabaseConnector("externalDatabaseConnectorResource", ExternalDatabaseConnectorArgs.builder()
    .connectionCredentials(ExternalDatabaseConnectorConnectionCredentialsArgs.builder()
        .credentialName("string")
        .credentialType("string")
        .password("string")
        .role("string")
        .sslSecretId("string")
        .username("string")
        .build())
    .connectionString(ExternalDatabaseConnectorConnectionStringArgs.builder()
        .hostname("string")
        .port(0)
        .protocol("string")
        .service("string")
        .build())
    .connectorAgentId("string")
    .displayName("string")
    .externalDatabaseId("string")
    .connectorType("string")
    .definedTags(Map.of("string", "string"))
    .freeformTags(Map.of("string", "string"))
    .build());

    external_database_connector_resource = oci.database.ExternalDatabaseConnector("externalDatabaseConnectorResource",
    connection_credentials={
        "credential_name": "string",
        "credential_type": "string",
        "password": "string",
        "role": "string",
        "ssl_secret_id": "string",
        "username": "string",
    },
    connection_string={
        "hostname": "string",
        "port": 0,
        "protocol": "string",
        "service": "string",
    },
    connector_agent_id="string",
    display_name="string",
    external_database_id="string",
    connector_type="string",
    defined_tags={
        "string": "string",
    },
    freeform_tags={
        "string": "string",
    })

    const externalDatabaseConnectorResource = new oci.database.ExternalDatabaseConnector("externalDatabaseConnectorResource", {
    connectionCredentials: {
        credentialName: "string",
        credentialType: "string",
        password: "string",
        role: "string",
        sslSecretId: "string",
        username: "string",
    },
    connectionString: {
        hostname: "string",
        port: 0,
        protocol: "string",
        service: "string",
    },
    connectorAgentId: "string",
    displayName: "string",
    externalDatabaseId: "string",
    connectorType: "string",
    definedTags: {
        string: "string",
    },
    freeformTags: {
        string: "string",
    },
});

    type: oci:Database:ExternalDatabaseConnector
properties:
    connectionCredentials:
        credentialName: string
        credentialType: string
        password: string
        role: string
        sslSecretId: string
        username: string
    connectionString:
        hostname: string
        port: 0
        protocol: string
        service: string
    connectorAgentId: string
    connectorType: string
    definedTags:
        string: string
    displayName: string
    externalDatabaseId: string
    freeformTags:
        string: string

    ExternalDatabaseConnector 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 ExternalDatabaseConnector resource accepts the following input properties:

    ConnectionCredentials ExternalDatabaseConnectorConnectionCredentials
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    ConnectionString ExternalDatabaseConnectorConnectionString
    (Updatable) The Oracle Database connection string.
    ConnectorAgentId string
    The ID of the agent used for the external database connector.
    DisplayName string
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    ExternalDatabaseId string
    The OCID of the external database resource.
    ConnectorType string
    (Updatable) The type of connector used by the external database resource.
    DefinedTags Dictionary<string, string>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    FreeformTags Dictionary<string, string>

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    ConnectionCredentials ExternalDatabaseConnectorConnectionCredentialsArgs
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    ConnectionString ExternalDatabaseConnectorConnectionStringArgs
    (Updatable) The Oracle Database connection string.
    ConnectorAgentId string
    The ID of the agent used for the external database connector.
    DisplayName string
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    ExternalDatabaseId string
    The OCID of the external database resource.
    ConnectorType string
    (Updatable) The type of connector used by the external database resource.
    DefinedTags map[string]string
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    FreeformTags map[string]string

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    connectionCredentials ExternalConnectorConnectionCredentials
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connectionString ExternalConnectorConnectionString
    (Updatable) The Oracle Database connection string.
    connectorAgentId String
    The ID of the agent used for the external database connector.
    displayName String
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    externalDatabaseId String
    The OCID of the external database resource.
    connectorType String
    (Updatable) The type of connector used by the external database resource.
    definedTags Map<String,String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    freeformTags Map<String,String>

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    connectionCredentials ExternalDatabaseConnectorConnectionCredentials
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connectionString ExternalDatabaseConnectorConnectionString
    (Updatable) The Oracle Database connection string.
    connectorAgentId string
    The ID of the agent used for the external database connector.
    displayName string
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    externalDatabaseId string
    The OCID of the external database resource.
    connectorType string
    (Updatable) The type of connector used by the external database resource.
    definedTags {[key: string]: string}
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    freeformTags {[key: string]: string}

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    connection_credentials ExternalDatabaseConnectorConnectionCredentialsArgs
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connection_string ExternalDatabaseConnectorConnectionStringArgs
    (Updatable) The Oracle Database connection string.
    connector_agent_id str
    The ID of the agent used for the external database connector.
    display_name str
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    external_database_id str
    The OCID of the external database resource.
    connector_type str
    (Updatable) The type of connector used by the external database resource.
    defined_tags Mapping[str, str]
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    freeform_tags Mapping[str, str]

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    connectionCredentials Property Map
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connectionString Property Map
    (Updatable) The Oracle Database connection string.
    connectorAgentId String
    The ID of the agent used for the external database connector.
    displayName String
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    externalDatabaseId String
    The OCID of the external database resource.
    connectorType String
    (Updatable) The type of connector used by the external database resource.
    definedTags Map<String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    freeformTags Map<String>

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Outputs

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

    CompartmentId string
    The OCID of the compartment.
    ConnectionStatus string
    The status of connectivity to the external database.
    Id string
    The provider-assigned unique ID for this managed resource.
    LifecycleDetails string
    Additional information about the current lifecycle state.
    State string
    The current lifecycle state of the external database connector resource.
    TimeConnectionStatusLastUpdated string
    The date and time the connectionStatus of this external connector was last updated.
    TimeCreated string
    The date and time the external connector was created.
    CompartmentId string
    The OCID of the compartment.
    ConnectionStatus string
    The status of connectivity to the external database.
    Id string
    The provider-assigned unique ID for this managed resource.
    LifecycleDetails string
    Additional information about the current lifecycle state.
    State string
    The current lifecycle state of the external database connector resource.
    TimeConnectionStatusLastUpdated string
    The date and time the connectionStatus of this external connector was last updated.
    TimeCreated string
    The date and time the external connector was created.
    compartmentId String
    The OCID of the compartment.
    connectionStatus String
    The status of connectivity to the external database.
    id String
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails String
    Additional information about the current lifecycle state.
    state String
    The current lifecycle state of the external database connector resource.
    timeConnectionStatusLastUpdated String
    The date and time the connectionStatus of this external connector was last updated.
    timeCreated String
    The date and time the external connector was created.
    compartmentId string
    The OCID of the compartment.
    connectionStatus string
    The status of connectivity to the external database.
    id string
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails string
    Additional information about the current lifecycle state.
    state string
    The current lifecycle state of the external database connector resource.
    timeConnectionStatusLastUpdated string
    The date and time the connectionStatus of this external connector was last updated.
    timeCreated string
    The date and time the external connector was created.
    compartment_id str
    The OCID of the compartment.
    connection_status str
    The status of connectivity to the external database.
    id str
    The provider-assigned unique ID for this managed resource.
    lifecycle_details str
    Additional information about the current lifecycle state.
    state str
    The current lifecycle state of the external database connector resource.
    time_connection_status_last_updated str
    The date and time the connectionStatus of this external connector was last updated.
    time_created str
    The date and time the external connector was created.
    compartmentId String
    The OCID of the compartment.
    connectionStatus String
    The status of connectivity to the external database.
    id String
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails String
    Additional information about the current lifecycle state.
    state String
    The current lifecycle state of the external database connector resource.
    timeConnectionStatusLastUpdated String
    The date and time the connectionStatus of this external connector was last updated.
    timeCreated String
    The date and time the external connector was created.

    Look up Existing ExternalDatabaseConnector Resource

    Get an existing ExternalDatabaseConnector 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?: ExternalDatabaseConnectorState, opts?: CustomResourceOptions): ExternalDatabaseConnector
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        compartment_id: Optional[str] = None,
        connection_credentials: Optional[ExternalDatabaseConnectorConnectionCredentialsArgs] = None,
        connection_status: Optional[str] = None,
        connection_string: Optional[ExternalDatabaseConnectorConnectionStringArgs] = None,
        connector_agent_id: Optional[str] = None,
        connector_type: Optional[str] = None,
        defined_tags: Optional[Mapping[str, str]] = None,
        display_name: Optional[str] = None,
        external_database_id: Optional[str] = None,
        freeform_tags: Optional[Mapping[str, str]] = None,
        lifecycle_details: Optional[str] = None,
        state: Optional[str] = None,
        time_connection_status_last_updated: Optional[str] = None,
        time_created: Optional[str] = None) -> ExternalDatabaseConnector
    func GetExternalDatabaseConnector(ctx *Context, name string, id IDInput, state *ExternalDatabaseConnectorState, opts ...ResourceOption) (*ExternalDatabaseConnector, error)
    public static ExternalDatabaseConnector Get(string name, Input<string> id, ExternalDatabaseConnectorState? state, CustomResourceOptions? opts = null)
    public static ExternalDatabaseConnector get(String name, Output<String> id, ExternalDatabaseConnectorState state, CustomResourceOptions options)
    resources:  _:    type: oci:Database:ExternalDatabaseConnector    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:
    CompartmentId string
    The OCID of the compartment.
    ConnectionCredentials ExternalDatabaseConnectorConnectionCredentials
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    ConnectionStatus string
    The status of connectivity to the external database.
    ConnectionString ExternalDatabaseConnectorConnectionString
    (Updatable) The Oracle Database connection string.
    ConnectorAgentId string
    The ID of the agent used for the external database connector.
    ConnectorType string
    (Updatable) The type of connector used by the external database resource.
    DefinedTags Dictionary<string, string>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    DisplayName string
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    ExternalDatabaseId string
    The OCID of the external database resource.
    FreeformTags Dictionary<string, string>

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    LifecycleDetails string
    Additional information about the current lifecycle state.
    State string
    The current lifecycle state of the external database connector resource.
    TimeConnectionStatusLastUpdated string
    The date and time the connectionStatus of this external connector was last updated.
    TimeCreated string
    The date and time the external connector was created.
    CompartmentId string
    The OCID of the compartment.
    ConnectionCredentials ExternalDatabaseConnectorConnectionCredentialsArgs
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    ConnectionStatus string
    The status of connectivity to the external database.
    ConnectionString ExternalDatabaseConnectorConnectionStringArgs
    (Updatable) The Oracle Database connection string.
    ConnectorAgentId string
    The ID of the agent used for the external database connector.
    ConnectorType string
    (Updatable) The type of connector used by the external database resource.
    DefinedTags map[string]string
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    DisplayName string
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    ExternalDatabaseId string
    The OCID of the external database resource.
    FreeformTags map[string]string

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    LifecycleDetails string
    Additional information about the current lifecycle state.
    State string
    The current lifecycle state of the external database connector resource.
    TimeConnectionStatusLastUpdated string
    The date and time the connectionStatus of this external connector was last updated.
    TimeCreated string
    The date and time the external connector was created.
    compartmentId String
    The OCID of the compartment.
    connectionCredentials ExternalConnectorConnectionCredentials
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connectionStatus String
    The status of connectivity to the external database.
    connectionString ExternalConnectorConnectionString
    (Updatable) The Oracle Database connection string.
    connectorAgentId String
    The ID of the agent used for the external database connector.
    connectorType String
    (Updatable) The type of connector used by the external database resource.
    definedTags Map<String,String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    displayName String
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    externalDatabaseId String
    The OCID of the external database resource.
    freeformTags Map<String,String>

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    lifecycleDetails String
    Additional information about the current lifecycle state.
    state String
    The current lifecycle state of the external database connector resource.
    timeConnectionStatusLastUpdated String
    The date and time the connectionStatus of this external connector was last updated.
    timeCreated String
    The date and time the external connector was created.
    compartmentId string
    The OCID of the compartment.
    connectionCredentials ExternalDatabaseConnectorConnectionCredentials
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connectionStatus string
    The status of connectivity to the external database.
    connectionString ExternalDatabaseConnectorConnectionString
    (Updatable) The Oracle Database connection string.
    connectorAgentId string
    The ID of the agent used for the external database connector.
    connectorType string
    (Updatable) The type of connector used by the external database resource.
    definedTags {[key: string]: string}
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    displayName string
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    externalDatabaseId string
    The OCID of the external database resource.
    freeformTags {[key: string]: string}

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    lifecycleDetails string
    Additional information about the current lifecycle state.
    state string
    The current lifecycle state of the external database connector resource.
    timeConnectionStatusLastUpdated string
    The date and time the connectionStatus of this external connector was last updated.
    timeCreated string
    The date and time the external connector was created.
    compartment_id str
    The OCID of the compartment.
    connection_credentials ExternalDatabaseConnectorConnectionCredentialsArgs
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connection_status str
    The status of connectivity to the external database.
    connection_string ExternalDatabaseConnectorConnectionStringArgs
    (Updatable) The Oracle Database connection string.
    connector_agent_id str
    The ID of the agent used for the external database connector.
    connector_type str
    (Updatable) The type of connector used by the external database resource.
    defined_tags Mapping[str, str]
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    display_name str
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    external_database_id str
    The OCID of the external database resource.
    freeform_tags Mapping[str, str]

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    lifecycle_details str
    Additional information about the current lifecycle state.
    state str
    The current lifecycle state of the external database connector resource.
    time_connection_status_last_updated str
    The date and time the connectionStatus of this external connector was last updated.
    time_created str
    The date and time the external connector was created.
    compartmentId String
    The OCID of the compartment.
    connectionCredentials Property Map
    (Updatable) Credentials used to connect to the database. Currently only the DETAILS type is supported for creating MACS connector crendentials.
    connectionStatus String
    The status of connectivity to the external database.
    connectionString Property Map
    (Updatable) The Oracle Database connection string.
    connectorAgentId String
    The ID of the agent used for the external database connector.
    connectorType String
    (Updatable) The type of connector used by the external database resource.
    definedTags Map<String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
    displayName String
    (Updatable) The user-friendly name for the external database connector. The name does not have to be unique.
    externalDatabaseId String
    The OCID of the external database resource.
    freeformTags Map<String>

    (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    lifecycleDetails String
    Additional information about the current lifecycle state.
    state String
    The current lifecycle state of the external database connector resource.
    timeConnectionStatusLastUpdated String
    The date and time the connectionStatus of this external connector was last updated.
    timeCreated String
    The date and time the external connector was created.

    Supporting Types

    ExternalDatabaseConnectorConnectionCredentials, ExternalDatabaseConnectorConnectionCredentialsArgs

    CredentialName string

    (Updatable) The name of the credential information that used to connect to the database. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.

    For example: inventorydb.abc112233445566778899

    CredentialType string
    (Updatable) The type of credential used to connect to the database.
    Password string
    (Updatable) The password that will be used to connect to the database.
    Role string
    (Updatable) The role of the user that will be connecting to the database.
    SslSecretId string
    (Updatable) The OCID of the Oracle Cloud Infrastructure secret.
    Username string
    (Updatable) The username that will be used to connect to the database.
    CredentialName string

    (Updatable) The name of the credential information that used to connect to the database. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.

    For example: inventorydb.abc112233445566778899

    CredentialType string
    (Updatable) The type of credential used to connect to the database.
    Password string
    (Updatable) The password that will be used to connect to the database.
    Role string
    (Updatable) The role of the user that will be connecting to the database.
    SslSecretId string
    (Updatable) The OCID of the Oracle Cloud Infrastructure secret.
    Username string
    (Updatable) The username that will be used to connect to the database.
    credentialName String

    (Updatable) The name of the credential information that used to connect to the database. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.

    For example: inventorydb.abc112233445566778899

    credentialType String
    (Updatable) The type of credential used to connect to the database.
    password String
    (Updatable) The password that will be used to connect to the database.
    role String
    (Updatable) The role of the user that will be connecting to the database.
    sslSecretId String
    (Updatable) The OCID of the Oracle Cloud Infrastructure secret.
    username String
    (Updatable) The username that will be used to connect to the database.
    credentialName string

    (Updatable) The name of the credential information that used to connect to the database. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.

    For example: inventorydb.abc112233445566778899

    credentialType string
    (Updatable) The type of credential used to connect to the database.
    password string
    (Updatable) The password that will be used to connect to the database.
    role string
    (Updatable) The role of the user that will be connecting to the database.
    sslSecretId string
    (Updatable) The OCID of the Oracle Cloud Infrastructure secret.
    username string
    (Updatable) The username that will be used to connect to the database.
    credential_name str

    (Updatable) The name of the credential information that used to connect to the database. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.

    For example: inventorydb.abc112233445566778899

    credential_type str
    (Updatable) The type of credential used to connect to the database.
    password str
    (Updatable) The password that will be used to connect to the database.
    role str
    (Updatable) The role of the user that will be connecting to the database.
    ssl_secret_id str
    (Updatable) The OCID of the Oracle Cloud Infrastructure secret.
    username str
    (Updatable) The username that will be used to connect to the database.
    credentialName String

    (Updatable) The name of the credential information that used to connect to the database. The name should be in "x.y" format, where the length of "x" has a maximum of 64 characters, and length of "y" has a maximum of 199 characters. The name strings can contain letters, numbers and the underscore character only. Other characters are not valid, except for the "." character that separates the "x" and "y" portions of the name. IMPORTANT - The name must be unique within the Oracle Cloud Infrastructure region the credential is being created in. If you specify a name that duplicates the name of another credential within the same Oracle Cloud Infrastructure region, you may overwrite or corrupt the credential that is already using the name.

    For example: inventorydb.abc112233445566778899

    credentialType String
    (Updatable) The type of credential used to connect to the database.
    password String
    (Updatable) The password that will be used to connect to the database.
    role String
    (Updatable) The role of the user that will be connecting to the database.
    sslSecretId String
    (Updatable) The OCID of the Oracle Cloud Infrastructure secret.
    username String
    (Updatable) The username that will be used to connect to the database.

    ExternalDatabaseConnectorConnectionString, ExternalDatabaseConnectorConnectionStringArgs

    Hostname string
    (Updatable) The host name of the database.
    Port int
    (Updatable) The port used to connect to the database.
    Protocol string
    (Updatable) The protocol used to connect to the database.
    Service string
    (Updatable) The name of the service alias used to connect to the database.
    Hostname string
    (Updatable) The host name of the database.
    Port int
    (Updatable) The port used to connect to the database.
    Protocol string
    (Updatable) The protocol used to connect to the database.
    Service string
    (Updatable) The name of the service alias used to connect to the database.
    hostname String
    (Updatable) The host name of the database.
    port Integer
    (Updatable) The port used to connect to the database.
    protocol String
    (Updatable) The protocol used to connect to the database.
    service String
    (Updatable) The name of the service alias used to connect to the database.
    hostname string
    (Updatable) The host name of the database.
    port number
    (Updatable) The port used to connect to the database.
    protocol string
    (Updatable) The protocol used to connect to the database.
    service string
    (Updatable) The name of the service alias used to connect to the database.
    hostname str
    (Updatable) The host name of the database.
    port int
    (Updatable) The port used to connect to the database.
    protocol str
    (Updatable) The protocol used to connect to the database.
    service str
    (Updatable) The name of the service alias used to connect to the database.
    hostname String
    (Updatable) The host name of the database.
    port Number
    (Updatable) The port used to connect to the database.
    protocol String
    (Updatable) The protocol used to connect to the database.
    service String
    (Updatable) The name of the service alias used to connect to the database.

    Import

    ExternalDatabaseConnectors can be imported using the id, e.g.

    $ pulumi import oci:Database/externalDatabaseConnector:ExternalDatabaseConnector test_external_database_connector "id"

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

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci