Oracle Cloud Infrastructure v0.20.0, May 31 23

oci.DatabaseTools.getDatabaseToolsConnection

Explore with Pulumi AI

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 System.Linq;
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=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))

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<GetDatabaseToolsConnectionKeyStoreKeyStoreContent>: The key store content.
KeyStorePasswords List<GetDatabaseToolsConnectionKeyStoreKeyStorePassword>: The key store password.
KeyStoreType string: The key store type.

KeyStoreContents []GetDatabaseToolsConnectionKeyStoreKeyStoreContent: The key store content.
KeyStorePasswords []GetDatabaseToolsConnectionKeyStoreKeyStorePassword: The key store password.
KeyStoreType string: The key store type.

keyStoreContents List<GetConnectionKeyStoreKeyStoreContent>: The key store content.
keyStorePasswords List<GetConnectionKeyStoreKeyStorePassword>: The key store password.
keyStoreType String: The key store type.

keyStoreContents GetDatabaseToolsConnectionKeyStoreKeyStoreContent[]: The key store content.
keyStorePasswords GetDatabaseToolsConnectionKeyStoreKeyStorePassword[]: The key store password.
keyStoreType string: The key store type.

key_store_contents GetDatabaseToolsConnectionKeyStoreKeyStoreContent]: The key store content.
key_store_passwords GetDatabaseToolsConnectionKeyStoreKeyStorePassword]: The key store password.
key_store_type str: The key store type.

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: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.