Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getExternalMySqlDatabaseConnectors
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getExternalMySqlDatabaseConnectors

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides the list of External My Sql Database Connectors in Oracle Cloud Infrastructure Database Management service.

    Gets the list of External MySQL Database connectors.

    Example Usage

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

const testExternalMySqlDatabaseConnectors = oci.DatabaseManagement.getExternalMySqlDatabaseConnectors({
    compartmentId: compartmentId,
    name: externalMySqlDatabaseConnectorName,
});

    import pulumi
import pulumi_oci as oci

test_external_my_sql_database_connectors = oci.DatabaseManagement.get_external_my_sql_database_connectors(compartment_id=compartment_id,
    name=external_my_sql_database_connector_name)

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetExternalMySqlDatabaseConnectors(ctx, &databasemanagement.GetExternalMySqlDatabaseConnectorsArgs{
			CompartmentId: compartmentId,
			Name:          pulumi.StringRef(externalMySqlDatabaseConnectorName),
		}, nil)
		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 testExternalMySqlDatabaseConnectors = Oci.DatabaseManagement.GetExternalMySqlDatabaseConnectors.Invoke(new()
    {
        CompartmentId = compartmentId,
        Name = externalMySqlDatabaseConnectorName,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetExternalMySqlDatabaseConnectorsArgs;
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) {
        final var testExternalMySqlDatabaseConnectors = DatabaseManagementFunctions.getExternalMySqlDatabaseConnectors(GetExternalMySqlDatabaseConnectorsArgs.builder()
            .compartmentId(compartmentId)
            .name(externalMySqlDatabaseConnectorName)
            .build());

    }
}

    variables:
  testExternalMySqlDatabaseConnectors:
    fn::invoke:
      function: oci:DatabaseManagement:getExternalMySqlDatabaseConnectors
      arguments:
        compartmentId: ${compartmentId}
        name: ${externalMySqlDatabaseConnectorName}

    Using getExternalMySqlDatabaseConnectors

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getExternalMySqlDatabaseConnectors(args: GetExternalMySqlDatabaseConnectorsArgs, opts?: InvokeOptions): Promise<GetExternalMySqlDatabaseConnectorsResult>
function getExternalMySqlDatabaseConnectorsOutput(args: GetExternalMySqlDatabaseConnectorsOutputArgs, opts?: InvokeOptions): Output<GetExternalMySqlDatabaseConnectorsResult>
    def get_external_my_sql_database_connectors(compartment_id: Optional[str] = None,
                                            filters: Optional[Sequence[_databasemanagement.GetExternalMySqlDatabaseConnectorsFilter]] = None,
                                            name: Optional[str] = None,
                                            opts: Optional[InvokeOptions] = None) -> GetExternalMySqlDatabaseConnectorsResult
def get_external_my_sql_database_connectors_output(compartment_id: Optional[pulumi.Input[str]] = None,
                                            filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetExternalMySqlDatabaseConnectorsFilterArgs]]]] = None,
                                            name: Optional[pulumi.Input[str]] = None,
                                            opts: Optional[InvokeOptions] = None) -> Output[GetExternalMySqlDatabaseConnectorsResult]
    func GetExternalMySqlDatabaseConnectors(ctx *Context, args *GetExternalMySqlDatabaseConnectorsArgs, opts ...InvokeOption) (*GetExternalMySqlDatabaseConnectorsResult, error)
func GetExternalMySqlDatabaseConnectorsOutput(ctx *Context, args *GetExternalMySqlDatabaseConnectorsOutputArgs, opts ...InvokeOption) GetExternalMySqlDatabaseConnectorsResultOutput

    > Note: This function is named GetExternalMySqlDatabaseConnectors in the Go SDK.

    public static class GetExternalMySqlDatabaseConnectors 
{
    public static Task<GetExternalMySqlDatabaseConnectorsResult> InvokeAsync(GetExternalMySqlDatabaseConnectorsArgs args, InvokeOptions? opts = null)
    public static Output<GetExternalMySqlDatabaseConnectorsResult> Invoke(GetExternalMySqlDatabaseConnectorsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetExternalMySqlDatabaseConnectorsResult> getExternalMySqlDatabaseConnectors(GetExternalMySqlDatabaseConnectorsArgs args, InvokeOptions options)
public static Output<GetExternalMySqlDatabaseConnectorsResult> getExternalMySqlDatabaseConnectors(GetExternalMySqlDatabaseConnectorsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseManagement/getExternalMySqlDatabaseConnectors:getExternalMySqlDatabaseConnectors
  arguments:
    # arguments dictionary

    The following arguments are supported:

    CompartmentId string
    The OCID of the compartment.
    Filters List<GetExternalMySqlDatabaseConnectorsFilter>
    Name string
    The parameter to filter by MySQL Database System type.
    CompartmentId string
    The OCID of the compartment.
    Filters []GetExternalMySqlDatabaseConnectorsFilter
    Name string
    The parameter to filter by MySQL Database System type.
    compartmentId String
    The OCID of the compartment.
    filters List<GetExternalMySqlDatabaseConnectorsFilter>
    name String
    The parameter to filter by MySQL Database System type.
    compartmentId string
    The OCID of the compartment.
    filters GetExternalMySqlDatabaseConnectorsFilter[]
    name string
    The parameter to filter by MySQL Database System type.
    compartment_id str
    The OCID of the compartment.
    filters Sequence[databasemanagement.GetExternalMySqlDatabaseConnectorsFilter]
    name str
    The parameter to filter by MySQL Database System type.
    compartmentId String
    The OCID of the compartment.
    filters List<Property Map>
    name String
    The parameter to filter by MySQL Database System type.

    getExternalMySqlDatabaseConnectors Result

    The following output properties are available:

    CompartmentId string
    OCID of compartment for the External MySQL connector.
    Id string
    The provider-assigned unique ID for this managed resource.
    MySqlConnectorCollections List<GetExternalMySqlDatabaseConnectorsMySqlConnectorCollection>
    The list of my_sql_connector_collection.
    Filters List<GetExternalMySqlDatabaseConnectorsFilter>
    Name string
    External MySQL Database Connector Name.
    CompartmentId string
    OCID of compartment for the External MySQL connector.
    Id string
    The provider-assigned unique ID for this managed resource.
    MySqlConnectorCollections []GetExternalMySqlDatabaseConnectorsMySqlConnectorCollection
    The list of my_sql_connector_collection.
    Filters []GetExternalMySqlDatabaseConnectorsFilter
    Name string
    External MySQL Database Connector Name.
    compartmentId String
    OCID of compartment for the External MySQL connector.
    id String
    The provider-assigned unique ID for this managed resource.
    mySqlConnectorCollections List<GetExternalMySqlDatabaseConnectorsMySqlConnectorCollection>
    The list of my_sql_connector_collection.
    filters List<GetExternalMySqlDatabaseConnectorsFilter>
    name String
    External MySQL Database Connector Name.
    compartmentId string
    OCID of compartment for the External MySQL connector.
    id string
    The provider-assigned unique ID for this managed resource.
    mySqlConnectorCollections GetExternalMySqlDatabaseConnectorsMySqlConnectorCollection[]
    The list of my_sql_connector_collection.
    filters GetExternalMySqlDatabaseConnectorsFilter[]
    name string
    External MySQL Database Connector Name.
    compartment_id str
    OCID of compartment for the External MySQL connector.
    id str
    The provider-assigned unique ID for this managed resource.
    my_sql_connector_collections Sequence[databasemanagement.GetExternalMySqlDatabaseConnectorsMySqlConnectorCollection]
    The list of my_sql_connector_collection.
    filters Sequence[databasemanagement.GetExternalMySqlDatabaseConnectorsFilter]
    name str
    External MySQL Database Connector Name.
    compartmentId String
    OCID of compartment for the External MySQL connector.
    id String
    The provider-assigned unique ID for this managed resource.
    mySqlConnectorCollections List<Property Map>
    The list of my_sql_connector_collection.
    filters List<Property Map>
    name String
    External MySQL Database Connector Name.

    Supporting Types

    GetExternalMySqlDatabaseConnectorsFilter

    Name string
    The parameter to filter by MySQL Database System type.
    Values List<string>
    Regex bool
    Name string
    The parameter to filter by MySQL Database System type.
    Values []string
    Regex bool
    name String
    The parameter to filter by MySQL Database System type.
    values List<String>
    regex Boolean
    name string
    The parameter to filter by MySQL Database System type.
    values string[]
    regex boolean
    name str
    The parameter to filter by MySQL Database System type.
    values Sequence[str]
    regex bool
    name String
    The parameter to filter by MySQL Database System type.
    values List<String>
    regex Boolean

    GetExternalMySqlDatabaseConnectorsMySqlConnectorCollection

    GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItem

    AssociatedServices string
    Oracle Cloud Infrastructure Services associated with this connector.
    CheckConnectionStatusTrigger int
    CompartmentId string
    The OCID of the compartment.
    ConnectionStatus string
    Connection Status
    ConnectorDetails List<GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItemConnectorDetail>
    ConnectorType string
    Connector Type.
    CredentialType string
    Credential type used to connect to database.
    ExternalDatabaseId string
    OCID of MySQL Database resource
    HostName string
    Host name for Connector.
    Id string
    OCID of MySQL Database Connector.
    IsTestConnectionParam bool
    MacsAgentId string
    Agent Id of the MACS agent.
    Name string
    The parameter to filter by MySQL Database System type.
    NetworkProtocol string
    Network Protocol.
    Port int
    Connector port.
    SourceDatabase string
    Name of MySQL Database.
    SourceDatabaseType string
    Type of MySQL Database.
    SslSecretId string
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    SslSecretName string
    Name of the SSL secret, if TCPS with SSL is used to connect to database.
    State string
    Indicates lifecycle state of the resource.
    TimeConnectionStatusUpdated string
    Time when connection status was last updated.
    TimeCreated string
    Connector creation time.
    TimeUpdated string
    Connector update time.
    AssociatedServices string
    Oracle Cloud Infrastructure Services associated with this connector.
    CheckConnectionStatusTrigger int
    CompartmentId string
    The OCID of the compartment.
    ConnectionStatus string
    Connection Status
    ConnectorDetails []GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItemConnectorDetail
    ConnectorType string
    Connector Type.
    CredentialType string
    Credential type used to connect to database.
    ExternalDatabaseId string
    OCID of MySQL Database resource
    HostName string
    Host name for Connector.
    Id string
    OCID of MySQL Database Connector.
    IsTestConnectionParam bool
    MacsAgentId string
    Agent Id of the MACS agent.
    Name string
    The parameter to filter by MySQL Database System type.
    NetworkProtocol string
    Network Protocol.
    Port int
    Connector port.
    SourceDatabase string
    Name of MySQL Database.
    SourceDatabaseType string
    Type of MySQL Database.
    SslSecretId string
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    SslSecretName string
    Name of the SSL secret, if TCPS with SSL is used to connect to database.
    State string
    Indicates lifecycle state of the resource.
    TimeConnectionStatusUpdated string
    Time when connection status was last updated.
    TimeCreated string
    Connector creation time.
    TimeUpdated string
    Connector update time.
    associatedServices String
    Oracle Cloud Infrastructure Services associated with this connector.
    checkConnectionStatusTrigger Integer
    compartmentId String
    The OCID of the compartment.
    connectionStatus String
    Connection Status
    connectorDetails List<GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItemConnectorDetail>
    connectorType String
    Connector Type.
    credentialType String
    Credential type used to connect to database.
    externalDatabaseId String
    OCID of MySQL Database resource
    hostName String
    Host name for Connector.
    id String
    OCID of MySQL Database Connector.
    isTestConnectionParam Boolean
    macsAgentId String
    Agent Id of the MACS agent.
    name String
    The parameter to filter by MySQL Database System type.
    networkProtocol String
    Network Protocol.
    port Integer
    Connector port.
    sourceDatabase String
    Name of MySQL Database.
    sourceDatabaseType String
    Type of MySQL Database.
    sslSecretId String
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    sslSecretName String
    Name of the SSL secret, if TCPS with SSL is used to connect to database.
    state String
    Indicates lifecycle state of the resource.
    timeConnectionStatusUpdated String
    Time when connection status was last updated.
    timeCreated String
    Connector creation time.
    timeUpdated String
    Connector update time.
    associatedServices string
    Oracle Cloud Infrastructure Services associated with this connector.
    checkConnectionStatusTrigger number
    compartmentId string
    The OCID of the compartment.
    connectionStatus string
    Connection Status
    connectorDetails GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItemConnectorDetail[]
    connectorType string
    Connector Type.
    credentialType string
    Credential type used to connect to database.
    externalDatabaseId string
    OCID of MySQL Database resource
    hostName string
    Host name for Connector.
    id string
    OCID of MySQL Database Connector.
    isTestConnectionParam boolean
    macsAgentId string
    Agent Id of the MACS agent.
    name string
    The parameter to filter by MySQL Database System type.
    networkProtocol string
    Network Protocol.
    port number
    Connector port.
    sourceDatabase string
    Name of MySQL Database.
    sourceDatabaseType string
    Type of MySQL Database.
    sslSecretId string
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    sslSecretName string
    Name of the SSL secret, if TCPS with SSL is used to connect to database.
    state string
    Indicates lifecycle state of the resource.
    timeConnectionStatusUpdated string
    Time when connection status was last updated.
    timeCreated string
    Connector creation time.
    timeUpdated string
    Connector update time.
    associated_services str
    Oracle Cloud Infrastructure Services associated with this connector.
    check_connection_status_trigger int
    compartment_id str
    The OCID of the compartment.
    connection_status str
    Connection Status
    connector_details Sequence[databasemanagement.GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItemConnectorDetail]
    connector_type str
    Connector Type.
    credential_type str
    Credential type used to connect to database.
    external_database_id str
    OCID of MySQL Database resource
    host_name str
    Host name for Connector.
    id str
    OCID of MySQL Database Connector.
    is_test_connection_param bool
    macs_agent_id str
    Agent Id of the MACS agent.
    name str
    The parameter to filter by MySQL Database System type.
    network_protocol str
    Network Protocol.
    port int
    Connector port.
    source_database str
    Name of MySQL Database.
    source_database_type str
    Type of MySQL Database.
    ssl_secret_id str
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    ssl_secret_name str
    Name of the SSL secret, if TCPS with SSL is used to connect to database.
    state str
    Indicates lifecycle state of the resource.
    time_connection_status_updated str
    Time when connection status was last updated.
    time_created str
    Connector creation time.
    time_updated str
    Connector update time.
    associatedServices String
    Oracle Cloud Infrastructure Services associated with this connector.
    checkConnectionStatusTrigger Number
    compartmentId String
    The OCID of the compartment.
    connectionStatus String
    Connection Status
    connectorDetails List<Property Map>
    connectorType String
    Connector Type.
    credentialType String
    Credential type used to connect to database.
    externalDatabaseId String
    OCID of MySQL Database resource
    hostName String
    Host name for Connector.
    id String
    OCID of MySQL Database Connector.
    isTestConnectionParam Boolean
    macsAgentId String
    Agent Id of the MACS agent.
    name String
    The parameter to filter by MySQL Database System type.
    networkProtocol String
    Network Protocol.
    port Number
    Connector port.
    sourceDatabase String
    Name of MySQL Database.
    sourceDatabaseType String
    Type of MySQL Database.
    sslSecretId String
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    sslSecretName String
    Name of the SSL secret, if TCPS with SSL is used to connect to database.
    state String
    Indicates lifecycle state of the resource.
    timeConnectionStatusUpdated String
    Time when connection status was last updated.
    timeCreated String
    Connector creation time.
    timeUpdated String
    Connector update time.

    GetExternalMySqlDatabaseConnectorsMySqlConnectorCollectionItemConnectorDetail

    CredentialType string
    Credential type used to connect to database.
    DisplayName string
    ExternalDatabaseId string
    OCID of MySQL Database resource
    HostName string
    Host name for Connector.
    MacsAgentId string
    Agent Id of the MACS agent.
    NetworkProtocol string
    Network Protocol.
    Port int
    Connector port.
    SslSecretId string
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    CredentialType string
    Credential type used to connect to database.
    DisplayName string
    ExternalDatabaseId string
    OCID of MySQL Database resource
    HostName string
    Host name for Connector.
    MacsAgentId string
    Agent Id of the MACS agent.
    NetworkProtocol string
    Network Protocol.
    Port int
    Connector port.
    SslSecretId string
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    credentialType String
    Credential type used to connect to database.
    displayName String
    externalDatabaseId String
    OCID of MySQL Database resource
    hostName String
    Host name for Connector.
    macsAgentId String
    Agent Id of the MACS agent.
    networkProtocol String
    Network Protocol.
    port Integer
    Connector port.
    sslSecretId String
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    credentialType string
    Credential type used to connect to database.
    displayName string
    externalDatabaseId string
    OCID of MySQL Database resource
    hostName string
    Host name for Connector.
    macsAgentId string
    Agent Id of the MACS agent.
    networkProtocol string
    Network Protocol.
    port number
    Connector port.
    sslSecretId string
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    credential_type str
    Credential type used to connect to database.
    display_name str
    external_database_id str
    OCID of MySQL Database resource
    host_name str
    Host name for Connector.
    macs_agent_id str
    Agent Id of the MACS agent.
    network_protocol str
    Network Protocol.
    port int
    Connector port.
    ssl_secret_id str
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.
    credentialType String
    Credential type used to connect to database.
    displayName String
    externalDatabaseId String
    OCID of MySQL Database resource
    hostName String
    Host name for Connector.
    macsAgentId String
    Agent Id of the MACS agent.
    networkProtocol String
    Network Protocol.
    port Number
    Connector port.
    sslSecretId String
    OCID of the SSL secret, if TCPS with SSL is used to connect to database.

    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.27.0 published on Thursday, Mar 20, 2025 by Pulumi
    pulumi/pulumi-oci