Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getDatabaseToolsConnection

This data source provides details about a specific Database Tools Connection resource in Oracle Cloud Infrastructure Database Tools service.

Gets details of the specified Database Tools connection.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testDatabaseToolsConnection = Oci.DatabaseTools.GetDatabaseToolsConnection.Invoke(new()
    {
        DatabaseToolsConnectionId = oci_database_tools_database_tools_connection.Test_database_tools_connection.Id,
    });

});
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := DatabaseTools.GetDatabaseToolsConnection(ctx, &databasetools.GetDatabaseToolsConnectionArgs{
			DatabaseToolsConnectionId: oci_database_tools_database_tools_connection.Test_database_tools_connection.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseTools.DatabaseToolsFunctions;
import com.pulumi.oci.DatabaseTools.inputs.GetDatabaseToolsConnectionArgs;
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 testDatabaseToolsConnection = DatabaseToolsFunctions.getDatabaseToolsConnection(GetDatabaseToolsConnectionArgs.builder()
            .databaseToolsConnectionId(oci_database_tools_database_tools_connection.test_database_tools_connection().id())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_database_tools_connection = oci.DatabaseTools.get_database_tools_connection(database_tools_connection_id=oci_database_tools_database_tools_connection["test_database_tools_connection"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDatabaseToolsConnection = oci.DatabaseTools.getDatabaseToolsConnection({
    databaseToolsConnectionId: oci_database_tools_database_tools_connection.test_database_tools_connection.id,
});
variables:
  testDatabaseToolsConnection:
    Fn::Invoke:
      Function: oci:DatabaseTools:getDatabaseToolsConnection
      Arguments:
        databaseToolsConnectionId: ${oci_database_tools_database_tools_connection.test_database_tools_connection.id}

Using getDatabaseToolsConnection

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 getDatabaseToolsConnection(args: GetDatabaseToolsConnectionArgs, opts?: InvokeOptions): Promise<GetDatabaseToolsConnectionResult>
function getDatabaseToolsConnectionOutput(args: GetDatabaseToolsConnectionOutputArgs, opts?: InvokeOptions): Output<GetDatabaseToolsConnectionResult>
def get_database_tools_connection(database_tools_connection_id: Optional[str] = None,
                                  opts: Optional[InvokeOptions] = None) -> GetDatabaseToolsConnectionResult
def get_database_tools_connection_output(database_tools_connection_id: Optional[pulumi.Input[str]] = None,
                                  opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseToolsConnectionResult]
func GetDatabaseToolsConnection(ctx *Context, args *GetDatabaseToolsConnectionArgs, opts ...InvokeOption) (*GetDatabaseToolsConnectionResult, error)
func GetDatabaseToolsConnectionOutput(ctx *Context, args *GetDatabaseToolsConnectionOutputArgs, opts ...InvokeOption) GetDatabaseToolsConnectionResultOutput

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

public static class GetDatabaseToolsConnection 
{
    public static Task<GetDatabaseToolsConnectionResult> InvokeAsync(GetDatabaseToolsConnectionArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseToolsConnectionResult> Invoke(GetDatabaseToolsConnectionInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabaseToolsConnectionResult> getDatabaseToolsConnection(GetDatabaseToolsConnectionArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
  function: oci:DatabaseTools/getDatabaseToolsConnection:getDatabaseToolsConnection
  arguments:
    # arguments dictionary

The following arguments are supported:

DatabaseToolsConnectionId string

The OCID of a Database Tools connection.

DatabaseToolsConnectionId string

The OCID of a Database Tools connection.

databaseToolsConnectionId String

The OCID of a Database Tools connection.

databaseToolsConnectionId string

The OCID of a Database Tools connection.

database_tools_connection_id str

The OCID of a Database Tools connection.

databaseToolsConnectionId String

The OCID of a Database Tools connection.

getDatabaseToolsConnection Result

The following output properties are available:

AdvancedProperties Dictionary<string, object>

The advanced connection properties key-value pair (for example, oracle.net.ssl_server_dn_match).

CompartmentId string

The OCID of the compartment containing the Database Tools connection.

ConnectionString string

The connect descriptor or Easy Connect Naming method used to connect to the database.

DatabaseToolsConnectionId string
DefinedTags Dictionary<string, object>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DisplayName string

A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

FreeformTags Dictionary<string, object>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

Id string

The OCID of the Database Tools connection.

KeyStores List<GetDatabaseToolsConnectionKeyStore>

The Oracle wallet or Java Keystores containing trusted certificates for authenticating the server's public certificate and the client private key and associated certificates required for client authentication.

LifecycleDetails string

A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.

PrivateEndpointId string

The OCID of the Database Tools private endpoint used to access the database in the customer VCN.

RelatedResources List<GetDatabaseToolsConnectionRelatedResource>

A related resource

State string

The current state of the Database Tools connection.

SystemTags Dictionary<string, object>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The time the Database Tools connection was created. An RFC3339 formatted datetime string.

TimeUpdated string

The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.

Type string

The Database Tools connection type.

UserName string

The database user name.

UserPasswords List<GetDatabaseToolsConnectionUserPassword>

The user password.

AdvancedProperties map[string]interface{}

The advanced connection properties key-value pair (for example, oracle.net.ssl_server_dn_match).

CompartmentId string

The OCID of the compartment containing the Database Tools connection.

ConnectionString string

The connect descriptor or Easy Connect Naming method used to connect to the database.

DatabaseToolsConnectionId string
DefinedTags map[string]interface{}

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

DisplayName string

A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

FreeformTags map[string]interface{}

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

Id string

The OCID of the Database Tools connection.

KeyStores []GetDatabaseToolsConnectionKeyStore

The Oracle wallet or Java Keystores containing trusted certificates for authenticating the server's public certificate and the client private key and associated certificates required for client authentication.

LifecycleDetails string

A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.

PrivateEndpointId string

The OCID of the Database Tools private endpoint used to access the database in the customer VCN.

RelatedResources []GetDatabaseToolsConnectionRelatedResource

A related resource

State string

The current state of the Database Tools connection.

SystemTags map[string]interface{}

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The time the Database Tools connection was created. An RFC3339 formatted datetime string.

TimeUpdated string

The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.

Type string

The Database Tools connection type.

UserName string

The database user name.

UserPasswords []GetDatabaseToolsConnectionUserPassword

The user password.

advancedProperties Map<String,Object>

The advanced connection properties key-value pair (for example, oracle.net.ssl_server_dn_match).

compartmentId String

The OCID of the compartment containing the Database Tools connection.

connectionString String

The connect descriptor or Easy Connect Naming method used to connect to the database.

databaseToolsConnectionId String
definedTags Map<String,Object>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

displayName String

A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeformTags Map<String,Object>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id String

The OCID of the Database Tools connection.

keyStores List<GetConnectionKeyStore>

The Oracle wallet or Java Keystores containing trusted certificates for authenticating the server's public certificate and the client private key and associated certificates required for client authentication.

lifecycleDetails String

A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.

privateEndpointId String

The OCID of the Database Tools private endpoint used to access the database in the customer VCN.

relatedResources List<GetConnectionRelatedResource>

A related resource

state String

The current state of the Database Tools connection.

systemTags Map<String,Object>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The time the Database Tools connection was created. An RFC3339 formatted datetime string.

timeUpdated String

The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.

type String

The Database Tools connection type.

userName String

The database user name.

userPasswords List<GetConnectionUserPassword>

The user password.

advancedProperties {[key: string]: any}

The advanced connection properties key-value pair (for example, oracle.net.ssl_server_dn_match).

compartmentId string

The OCID of the compartment containing the Database Tools connection.

connectionString string

The connect descriptor or Easy Connect Naming method used to connect to the database.

databaseToolsConnectionId string
definedTags {[key: string]: any}

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

displayName string

A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeformTags {[key: string]: any}

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id string

The OCID of the Database Tools connection.

keyStores GetDatabaseToolsConnectionKeyStore[]

The Oracle wallet or Java Keystores containing trusted certificates for authenticating the server's public certificate and the client private key and associated certificates required for client authentication.

lifecycleDetails string

A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.

privateEndpointId string

The OCID of the Database Tools private endpoint used to access the database in the customer VCN.

relatedResources GetDatabaseToolsConnectionRelatedResource[]

A related resource

state string

The current state of the Database Tools connection.

systemTags {[key: string]: any}

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated string

The time the Database Tools connection was created. An RFC3339 formatted datetime string.

timeUpdated string

The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.

type string

The Database Tools connection type.

userName string

The database user name.

userPasswords GetDatabaseToolsConnectionUserPassword[]

The user password.

advanced_properties Mapping[str, Any]

The advanced connection properties key-value pair (for example, oracle.net.ssl_server_dn_match).

compartment_id str

The OCID of the compartment containing the Database Tools connection.

connection_string str

The connect descriptor or Easy Connect Naming method used to connect to the database.

database_tools_connection_id str
defined_tags Mapping[str, Any]

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

display_name str

A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeform_tags Mapping[str, Any]

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id str

The OCID of the Database Tools connection.

key_stores GetDatabaseToolsConnectionKeyStore]

The Oracle wallet or Java Keystores containing trusted certificates for authenticating the server's public certificate and the client private key and associated certificates required for client authentication.

lifecycle_details str

A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.

private_endpoint_id str

The OCID of the Database Tools private endpoint used to access the database in the customer VCN.

related_resources GetDatabaseToolsConnectionRelatedResource]

A related resource

state str

The current state of the Database Tools connection.

system_tags Mapping[str, Any]

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

time_created str

The time the Database Tools connection was created. An RFC3339 formatted datetime string.

time_updated str

The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.

type str

The Database Tools connection type.

user_name str

The database user name.

user_passwords GetDatabaseToolsConnectionUserPassword]

The user password.

advancedProperties Map<Any>

The advanced connection properties key-value pair (for example, oracle.net.ssl_server_dn_match).

compartmentId String

The OCID of the compartment containing the Database Tools connection.

connectionString String

The connect descriptor or Easy Connect Naming method used to connect to the database.

databaseToolsConnectionId String
definedTags Map<Any>

Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

displayName String

A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeformTags Map<Any>

Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

id String

The OCID of the Database Tools connection.

keyStores List<Property Map>

The Oracle wallet or Java Keystores containing trusted certificates for authenticating the server's public certificate and the client private key and associated certificates required for client authentication.

lifecycleDetails String

A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.

privateEndpointId String

The OCID of the Database Tools private endpoint used to access the database in the customer VCN.

relatedResources List<Property Map>

A related resource

state String

The current state of the Database Tools connection.

systemTags Map<Any>

Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The time the Database Tools connection was created. An RFC3339 formatted datetime string.

timeUpdated String

The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.

type String

The Database Tools connection type.

userName String

The database user name.

userPasswords List<Property Map>

The user password.

Supporting Types

GetDatabaseToolsConnectionKeyStore

keyStoreContents List<Property Map>

The key store content.

keyStorePasswords List<Property Map>

The key store password.

keyStoreType String

The key store type.

GetDatabaseToolsConnectionKeyStoreKeyStoreContent

SecretId string

The OCID of the secret containing the user password.

ValueType string

The value type of the user password.

SecretId string

The OCID of the secret containing the user password.

ValueType string

The value type of the user password.

secretId String

The OCID of the secret containing the user password.

valueType String

The value type of the user password.

secretId string

The OCID of the secret containing the user password.

valueType string

The value type of the user password.

secret_id str

The OCID of the secret containing the user password.

value_type str

The value type of the user password.

secretId String

The OCID of the secret containing the user password.

valueType String

The value type of the user password.

GetDatabaseToolsConnectionKeyStoreKeyStorePassword

SecretId string

The OCID of the secret containing the user password.

ValueType string

The value type of the user password.

SecretId string

The OCID of the secret containing the user password.

ValueType string

The value type of the user password.

secretId String

The OCID of the secret containing the user password.

valueType String

The value type of the user password.

secretId string

The OCID of the secret containing the user password.

valueType string

The value type of the user password.

secret_id str

The OCID of the secret containing the user password.

value_type str

The value type of the user password.

secretId String

The OCID of the secret containing the user password.

valueType String

The value type of the user password.

GetDatabaseToolsConnectionRelatedResource

EntityType string

The resource entity type.

Identifier string

The OCID of the related resource.

EntityType string

The resource entity type.

Identifier string

The OCID of the related resource.

entityType String

The resource entity type.

identifier String

The OCID of the related resource.

entityType string

The resource entity type.

identifier string

The OCID of the related resource.

entity_type str

The resource entity type.

identifier str

The OCID of the related resource.

entityType String

The resource entity type.

identifier String

The OCID of the related resource.

GetDatabaseToolsConnectionUserPassword

SecretId string

The OCID of the secret containing the user password.

ValueType string

The value type of the user password.

SecretId string

The OCID of the secret containing the user password.

ValueType string

The value type of the user password.

secretId String

The OCID of the secret containing the user password.

valueType String

The value type of the user password.

secretId string

The OCID of the secret containing the user password.

valueType string

The value type of the user password.

secret_id str

The OCID of the secret containing the user password.

value_type str

The value type of the user password.

secretId String

The OCID of the secret containing the user password.

valueType String

The value type of the user password.

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.