Oracle Cloud Infrastructure v2.17.0 published on Friday, Nov 15, 2024 by Pulumi
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
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testDatabaseToolsConnection = oci.DatabaseTools.getDatabaseToolsConnection({
databaseToolsConnectionId: testDatabaseToolsConnectionOciDatabaseToolsDatabaseToolsConnection.id,
});
import pulumi
import pulumi_oci as oci
test_database_tools_connection = oci.DatabaseTools.get_database_tools_connection(database_tools_connection_id=test_database_tools_connection_oci_database_tools_database_tools_connection["id"])
package main
import (
"github.com/pulumi/pulumi-oci/sdk/v2/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: testDatabaseToolsConnectionOciDatabaseToolsDatabaseToolsConnection.Id,
}, 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 testDatabaseToolsConnection = Oci.DatabaseTools.GetDatabaseToolsConnection.Invoke(new()
{
DatabaseToolsConnectionId = testDatabaseToolsConnectionOciDatabaseToolsDatabaseToolsConnection.Id,
});
});
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(testDatabaseToolsConnectionOciDatabaseToolsDatabaseToolsConnection.id())
.build());
}
}
variables:
testDatabaseToolsConnection:
fn::invoke:
Function: oci:DatabaseTools:getDatabaseToolsConnection
Arguments:
databaseToolsConnectionId: ${testDatabaseToolsConnectionOciDatabaseToolsDatabaseToolsConnection.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:
- Database
Tools stringConnection Id - The OCID of a Database Tools connection.
- Database
Tools stringConnection Id - The OCID of a Database Tools connection.
- database
Tools StringConnection Id - The OCID of a Database Tools connection.
- database
Tools stringConnection Id - The OCID of a Database Tools connection.
- database_
tools_ strconnection_ id - The OCID of a Database Tools connection.
- database
Tools StringConnection Id - The OCID of a Database Tools connection.
getDatabaseToolsConnection Result
The following output properties are available:
- Advanced
Properties Dictionary<string, string> - The advanced connection properties key-value pair (for example,
oracle.net.ssl_server_dn_match
). - Compartment
Id string - The OCID of the compartment containing the Database Tools connection.
- Connection
String string - The connect descriptor or Easy Connect Naming method used to connect to the database.
- Database
Tools stringConnection Id - Dictionary<string, string>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Display
Name string - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Dictionary<string, string>
- 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.
- Key
Stores List<GetDatabase Tools Connection Key Store> - 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 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.
- Locks
List<Get
Database Tools Connection Lock> - Locks associated with this resource.
- Private
Endpoint stringId - The OCID of the Database Tools private endpoint used to access the database in the customer VCN.
- Proxy
Clients List<GetDatabase Tools Connection Proxy Client> - The proxy client information.
- List<Get
Database Tools Connection Related Resource> - A related resource
- Runtime
Support string - Specifies whether this connection is supported by the Database Tools Runtime.
- State string
- The current state of the Database Tools connection.
- Dictionary<string, string>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Time
Created string - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- Time
Updated string - The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.
- Type string
- The Database Tools connection type.
- Url string
- The JDBC URL used to connect to the Generic JDBC database system.
- User
Name string - The database user name.
- User
Passwords List<GetDatabase Tools Connection User Password> - The user password.
- Advanced
Properties map[string]string - The advanced connection properties key-value pair (for example,
oracle.net.ssl_server_dn_match
). - Compartment
Id string - The OCID of the compartment containing the Database Tools connection.
- Connection
String string - The connect descriptor or Easy Connect Naming method used to connect to the database.
- Database
Tools stringConnection Id - map[string]string
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Display
Name string - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- map[string]string
- 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.
- Key
Stores []GetDatabase Tools Connection Key Store - 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 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.
- Locks
[]Get
Database Tools Connection Lock - Locks associated with this resource.
- Private
Endpoint stringId - The OCID of the Database Tools private endpoint used to access the database in the customer VCN.
- Proxy
Clients []GetDatabase Tools Connection Proxy Client - The proxy client information.
- []Get
Database Tools Connection Related Resource - A related resource
- Runtime
Support string - Specifies whether this connection is supported by the Database Tools Runtime.
- State string
- The current state of the Database Tools connection.
- map[string]string
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Time
Created string - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- Time
Updated string - The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.
- Type string
- The Database Tools connection type.
- Url string
- The JDBC URL used to connect to the Generic JDBC database system.
- User
Name string - The database user name.
- User
Passwords []GetDatabase Tools Connection User Password - The user password.
- advanced
Properties Map<String,String> - The advanced connection properties key-value pair (for example,
oracle.net.ssl_server_dn_match
). - compartment
Id String - The OCID of the compartment containing the Database Tools connection.
- connection
String String - The connect descriptor or Easy Connect Naming method used to connect to the database.
- database
Tools StringConnection Id - Map<String,String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display
Name String - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Map<String,String>
- 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.
- key
Stores List<GetConnection Key Store> - 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 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.
- locks
List<Get
Connection Lock> - Locks associated with this resource.
- private
Endpoint StringId - The OCID of the Database Tools private endpoint used to access the database in the customer VCN.
- proxy
Clients List<GetConnection Proxy Client> - The proxy client information.
- List<Get
Connection Related Resource> - A related resource
- runtime
Support String - Specifies whether this connection is supported by the Database Tools Runtime.
- state String
- The current state of the Database Tools connection.
- Map<String,String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created String - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- time
Updated String - The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.
- type String
- The Database Tools connection type.
- url String
- The JDBC URL used to connect to the Generic JDBC database system.
- user
Name String - The database user name.
- user
Passwords List<GetConnection User Password> - The user password.
- advanced
Properties {[key: string]: string} - The advanced connection properties key-value pair (for example,
oracle.net.ssl_server_dn_match
). - compartment
Id string - The OCID of the compartment containing the Database Tools connection.
- connection
String string - The connect descriptor or Easy Connect Naming method used to connect to the database.
- database
Tools stringConnection Id - {[key: string]: string}
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display
Name string - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- {[key: string]: string}
- 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.
- key
Stores GetDatabase Tools Connection Key Store[] - 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 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.
- locks
Get
Database Tools Connection Lock[] - Locks associated with this resource.
- private
Endpoint stringId - The OCID of the Database Tools private endpoint used to access the database in the customer VCN.
- proxy
Clients GetDatabase Tools Connection Proxy Client[] - The proxy client information.
- Get
Database Tools Connection Related Resource[] - A related resource
- runtime
Support string - Specifies whether this connection is supported by the Database Tools Runtime.
- state string
- The current state of the Database Tools connection.
- {[key: string]: string}
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created string - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- time
Updated string - The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.
- type string
- The Database Tools connection type.
- url string
- The JDBC URL used to connect to the Generic JDBC database system.
- user
Name string - The database user name.
- user
Passwords GetDatabase Tools Connection User Password[] - The user password.
- advanced_
properties Mapping[str, str] - 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_ strconnection_ id - Mapping[str, str]
- 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.
- Mapping[str, str]
- 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 Sequence[databasetools.Get Database Tools Connection Key Store] - 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.
- locks
Sequence[databasetools.
Get Database Tools Connection Lock] - Locks associated with this resource.
- private_
endpoint_ strid - The OCID of the Database Tools private endpoint used to access the database in the customer VCN.
- proxy_
clients Sequence[databasetools.Get Database Tools Connection Proxy Client] - The proxy client information.
- Sequence[databasetools.
Get Database Tools Connection Related Resource] - A related resource
- runtime_
support str - Specifies whether this connection is supported by the Database Tools Runtime.
- state str
- The current state of the Database Tools connection.
- Mapping[str, str]
- 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.
- url str
- The JDBC URL used to connect to the Generic JDBC database system.
- user_
name str - The database user name.
- user_
passwords Sequence[databasetools.Get Database Tools Connection User Password] - The user password.
- advanced
Properties Map<String> - The advanced connection properties key-value pair (for example,
oracle.net.ssl_server_dn_match
). - compartment
Id String - The OCID of the compartment containing the Database Tools connection.
- connection
String String - The connect descriptor or Easy Connect Naming method used to connect to the database.
- database
Tools StringConnection Id - Map<String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display
Name String - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Map<String>
- 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.
- key
Stores 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.
- lifecycle
Details 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.
- locks List<Property Map>
- Locks associated with this resource.
- private
Endpoint StringId - The OCID of the Database Tools private endpoint used to access the database in the customer VCN.
- proxy
Clients List<Property Map> - The proxy client information.
- List<Property Map>
- A related resource
- runtime
Support String - Specifies whether this connection is supported by the Database Tools Runtime.
- state String
- The current state of the Database Tools connection.
- Map<String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- time
Created String - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- time
Updated String - The time the DatabaseToolsConnection was updated. An RFC3339 formatted datetime string.
- type String
- The Database Tools connection type.
- url String
- The JDBC URL used to connect to the Generic JDBC database system.
- user
Name String - The database user name.
- user
Passwords List<Property Map> - The user password.
Supporting Types
GetDatabaseToolsConnectionKeyStore
- Key
Store List<GetContents Database Tools Connection Key Store Key Store Content> - The key store content.
- Key
Store List<GetPasswords Database Tools Connection Key Store Key Store Password> - The key store password.
- Key
Store stringType - The key store type.
- Key
Store []GetContents Database Tools Connection Key Store Key Store Content - The key store content.
- Key
Store []GetPasswords Database Tools Connection Key Store Key Store Password - The key store password.
- Key
Store stringType - The key store type.
- key
Store List<GetContents Connection Key Store Key Store Content> - The key store content.
- key
Store List<GetPasswords Connection Key Store Key Store Password> - The key store password.
- key
Store StringType - The key store type.
- key
Store GetContents Database Tools Connection Key Store Key Store Content[] - The key store content.
- key
Store GetPasswords Database Tools Connection Key Store Key Store Password[] - The key store password.
- key
Store stringType - The key store type.
- key_
store_ Sequence[databasetools.contents Get Database Tools Connection Key Store Key Store Content] - The key store content.
- key_
store_ Sequence[databasetools.passwords Get Database Tools Connection Key Store Key Store Password] - The key store password.
- key_
store_ strtype - The key store type.
- key
Store List<Property Map>Contents - The key store content.
- key
Store List<Property Map>Passwords - The key store password.
- key
Store StringType - The key store type.
GetDatabaseToolsConnectionKeyStoreKeyStoreContent
- secret_
id str - The OCID of the secret containing the user password.
- value_
type str - The value type of the user password.
GetDatabaseToolsConnectionKeyStoreKeyStorePassword
- secret_
id str - The OCID of the secret containing the user password.
- value_
type str - The value type of the user password.
GetDatabaseToolsConnectionLock
- Message string
- A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
- string
- The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
- Time
Created string - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- Type string
- The Database Tools connection type.
- Message string
- A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
- string
- The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
- Time
Created string - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- Type string
- The Database Tools connection type.
- message String
- A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
- String
- The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
- time
Created String - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- type String
- The Database Tools connection type.
- message string
- A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
- string
- The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
- time
Created string - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- type string
- The Database Tools connection type.
- message str
- A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
- str
- The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
- time_
created str - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- type str
- The Database Tools connection type.
- message String
- A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
- String
- The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
- time
Created String - The time the Database Tools connection was created. An RFC3339 formatted datetime string.
- type String
- The Database Tools connection type.
GetDatabaseToolsConnectionProxyClient
- Proxy
Authentication stringType - The proxy authentication type.
- Roles List<string>
- A list of database roles for the client. These roles are enabled if the proxy is authorized to use the roles on behalf of the client.
- User
Name string - The database user name.
- User
Passwords List<GetDatabase Tools Connection Proxy Client User Password> - The user password.
- Proxy
Authentication stringType - The proxy authentication type.
- Roles []string
- A list of database roles for the client. These roles are enabled if the proxy is authorized to use the roles on behalf of the client.
- User
Name string - The database user name.
- User
Passwords []GetDatabase Tools Connection Proxy Client User Password - The user password.
- proxy
Authentication StringType - The proxy authentication type.
- roles List<String>
- A list of database roles for the client. These roles are enabled if the proxy is authorized to use the roles on behalf of the client.
- user
Name String - The database user name.
- user
Passwords List<GetConnection Proxy Client User Password> - The user password.
- proxy
Authentication stringType - The proxy authentication type.
- roles string[]
- A list of database roles for the client. These roles are enabled if the proxy is authorized to use the roles on behalf of the client.
- user
Name string - The database user name.
- user
Passwords GetDatabase Tools Connection Proxy Client User Password[] - The user password.
- proxy_
authentication_ strtype - The proxy authentication type.
- roles Sequence[str]
- A list of database roles for the client. These roles are enabled if the proxy is authorized to use the roles on behalf of the client.
- user_
name str - The database user name.
- user_
passwords Sequence[databasetools.Get Database Tools Connection Proxy Client User Password] - The user password.
- proxy
Authentication StringType - The proxy authentication type.
- roles List<String>
- A list of database roles for the client. These roles are enabled if the proxy is authorized to use the roles on behalf of the client.
- user
Name String - The database user name.
- user
Passwords List<Property Map> - The user password.
GetDatabaseToolsConnectionProxyClientUserPassword
- secret_
id str - The OCID of the secret containing the user password.
- value_
type str - The value type of the user password.
GetDatabaseToolsConnectionRelatedResource
- Entity
Type string - The resource entity type.
- Identifier string
- The OCID of the related resource.
- Entity
Type string - The resource entity type.
- Identifier string
- The OCID of the related resource.
- entity
Type String - The resource entity type.
- identifier String
- The OCID of the related resource.
- entity
Type 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.
- entity
Type String - The resource entity type.
- identifier String
- The OCID of the related resource.
GetDatabaseToolsConnectionUserPassword
- secret_
id str - The OCID of the secret containing the user password.
- value_
type str - 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.