Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getDatabaseInsight

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

Gets details of a database insight.

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testDatabaseInsight = Output.Create(Oci.Opsi.GetDatabaseInsight.InvokeAsync(new Oci.Opsi.GetDatabaseInsightArgs
        {
            DatabaseInsightId = oci_opsi_database_insight.Test_database_insight.Id,
        }));
    }

}
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Opsi.GetDatabaseInsight(ctx, &opsi.GetDatabaseInsightArgs{
			DatabaseInsightId: oci_opsi_database_insight.Test_database_insight.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_database_insight = oci.Opsi.get_database_insight(database_insight_id=oci_opsi_database_insight["test_database_insight"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDatabaseInsight = oci.Opsi.getDatabaseInsight({
    databaseInsightId: oci_opsi_database_insight.test_database_insight.id,
});

Coming soon!

Using getDatabaseInsight

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 getDatabaseInsight(args: GetDatabaseInsightArgs, opts?: InvokeOptions): Promise<GetDatabaseInsightResult>
function getDatabaseInsightOutput(args: GetDatabaseInsightOutputArgs, opts?: InvokeOptions): Output<GetDatabaseInsightResult>
def get_database_insight(database_insight_id: Optional[str] = None,
                         opts: Optional[InvokeOptions] = None) -> GetDatabaseInsightResult
def get_database_insight_output(database_insight_id: Optional[pulumi.Input[str]] = None,
                         opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseInsightResult]
func GetDatabaseInsight(ctx *Context, args *GetDatabaseInsightArgs, opts ...InvokeOption) (*GetDatabaseInsightResult, error)
func GetDatabaseInsightOutput(ctx *Context, args *GetDatabaseInsightOutputArgs, opts ...InvokeOption) GetDatabaseInsightResultOutput

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

public static class GetDatabaseInsight 
{
    public static Task<GetDatabaseInsightResult> InvokeAsync(GetDatabaseInsightArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseInsightResult> Invoke(GetDatabaseInsightInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabaseInsightResult> getDatabaseInsight(GetDatabaseInsightArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:Opsi/getDatabaseInsight:getDatabaseInsight
  Arguments:
    # Arguments dictionary

The following arguments are supported:

DatabaseInsightId string

Unique database insight identifier

DatabaseInsightId string

Unique database insight identifier

databaseInsightId String

Unique database insight identifier

databaseInsightId string

Unique database insight identifier

database_insight_id str

Unique database insight identifier

databaseInsightId String

Unique database insight identifier

getDatabaseInsight Result

The following output properties are available:

CompartmentId string

Compartment identifier of the database

ConnectionCredentialDetails List<GetDatabaseInsightConnectionCredentialDetail>

User credential details to connect to the database. This is supplied via the External Database Service.

ConnectionDetails List<GetDatabaseInsightConnectionDetail>

Connection details to connect to the database. HostName, protocol, and port should be specified.

CredentialDetails List<GetDatabaseInsightCredentialDetail>

User credential details to connect to the database.

DatabaseConnectionStatusDetails string

A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

DatabaseDisplayName string

Display name of database

DatabaseId string

The OCID of the database.

DatabaseInsightId string
DatabaseName string

Name of database

DatabaseResourceType string

Oracle Cloud Infrastructure database resource type

DatabaseType string

Operations Insights internal representation of the database type.

DatabaseVersion string

The version of the database.

DefinedTags Dictionary<string, object>

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

DeploymentType string
EnterpriseManagerBridgeId string

OPSI Enterprise Manager Bridge OCID

EnterpriseManagerEntityDisplayName string

Enterprise Manager Entity Display Name

EnterpriseManagerEntityIdentifier string

Enterprise Manager Entity Unique Identifier

EnterpriseManagerEntityName string

Enterprise Manager Entity Name

EnterpriseManagerEntityType string

Enterprise Manager Entity Type

EnterpriseManagerIdentifier string

Enterprise Manager Unqiue Identifier

EntitySource string

Source of the database entity.

ExadataInsightId string

The OCID of the Exadata insight.

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

Database insight identifier

LifecycleDetails string

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

OpsiPrivateEndpointId string

The OCID of the OPSI private endpoint

ProcessorCount int

Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

ServiceName string

Database service name used for connection requests.

State string

The current state of the database.

Status string

Indicates the status of a database insight in Operations Insights

SystemTags Dictionary<string, object>

System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The time the the database insight was first enabled. An RFC3339 formatted datetime string

TimeUpdated string

The time the database insight was updated. An RFC3339 formatted datetime string

CompartmentId string

Compartment identifier of the database

ConnectionCredentialDetails []GetDatabaseInsightConnectionCredentialDetail

User credential details to connect to the database. This is supplied via the External Database Service.

ConnectionDetails []GetDatabaseInsightConnectionDetail

Connection details to connect to the database. HostName, protocol, and port should be specified.

CredentialDetails []GetDatabaseInsightCredentialDetail

User credential details to connect to the database.

DatabaseConnectionStatusDetails string

A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

DatabaseDisplayName string

Display name of database

DatabaseId string

The OCID of the database.

DatabaseInsightId string
DatabaseName string

Name of database

DatabaseResourceType string

Oracle Cloud Infrastructure database resource type

DatabaseType string

Operations Insights internal representation of the database type.

DatabaseVersion string

The version of the database.

DefinedTags map[string]interface{}

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

DeploymentType string
EnterpriseManagerBridgeId string

OPSI Enterprise Manager Bridge OCID

EnterpriseManagerEntityDisplayName string

Enterprise Manager Entity Display Name

EnterpriseManagerEntityIdentifier string

Enterprise Manager Entity Unique Identifier

EnterpriseManagerEntityName string

Enterprise Manager Entity Name

EnterpriseManagerEntityType string

Enterprise Manager Entity Type

EnterpriseManagerIdentifier string

Enterprise Manager Unqiue Identifier

EntitySource string

Source of the database entity.

ExadataInsightId string

The OCID of the Exadata insight.

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

Database insight identifier

LifecycleDetails string

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

OpsiPrivateEndpointId string

The OCID of the OPSI private endpoint

ProcessorCount int

Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

ServiceName string

Database service name used for connection requests.

State string

The current state of the database.

Status string

Indicates the status of a database insight in Operations Insights

SystemTags map[string]interface{}

System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

TimeCreated string

The time the the database insight was first enabled. An RFC3339 formatted datetime string

TimeUpdated string

The time the database insight was updated. An RFC3339 formatted datetime string

compartmentId String

Compartment identifier of the database

connectionCredentialDetails List<GetDatabaseInsightConnectionCredentialDetail>

User credential details to connect to the database. This is supplied via the External Database Service.

connectionDetails List<GetDatabaseInsightConnectionDetail>

Connection details to connect to the database. HostName, protocol, and port should be specified.

credentialDetails List<GetDatabaseInsightCredentialDetail>

User credential details to connect to the database.

databaseConnectionStatusDetails String

A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

databaseDisplayName String

Display name of database

databaseId String

The OCID of the database.

databaseInsightId String
databaseName String

Name of database

databaseResourceType String

Oracle Cloud Infrastructure database resource type

databaseType String

Operations Insights internal representation of the database type.

databaseVersion String

The version of the database.

definedTags Map<String,Object>

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

deploymentType String
enterpriseManagerBridgeId String

OPSI Enterprise Manager Bridge OCID

enterpriseManagerEntityDisplayName String

Enterprise Manager Entity Display Name

enterpriseManagerEntityIdentifier String

Enterprise Manager Entity Unique Identifier

enterpriseManagerEntityName String

Enterprise Manager Entity Name

enterpriseManagerEntityType String

Enterprise Manager Entity Type

enterpriseManagerIdentifier String

Enterprise Manager Unqiue Identifier

entitySource String

Source of the database entity.

exadataInsightId String

The OCID of the Exadata insight.

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

Database insight identifier

lifecycleDetails String

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

opsiPrivateEndpointId String

The OCID of the OPSI private endpoint

processorCount Integer

Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

serviceName String

Database service name used for connection requests.

state String

The current state of the database.

status String

Indicates the status of a database insight in Operations Insights

systemTags Map<String,Object>

System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The time the the database insight was first enabled. An RFC3339 formatted datetime string

timeUpdated String

The time the database insight was updated. An RFC3339 formatted datetime string

compartmentId string

Compartment identifier of the database

connectionCredentialDetails GetDatabaseInsightConnectionCredentialDetail[]

User credential details to connect to the database. This is supplied via the External Database Service.

connectionDetails GetDatabaseInsightConnectionDetail[]

Connection details to connect to the database. HostName, protocol, and port should be specified.

credentialDetails GetDatabaseInsightCredentialDetail[]

User credential details to connect to the database.

databaseConnectionStatusDetails string

A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

databaseDisplayName string

Display name of database

databaseId string

The OCID of the database.

databaseInsightId string
databaseName string

Name of database

databaseResourceType string

Oracle Cloud Infrastructure database resource type

databaseType string

Operations Insights internal representation of the database type.

databaseVersion string

The version of the database.

definedTags {[key: string]: any}

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

deploymentType string
enterpriseManagerBridgeId string

OPSI Enterprise Manager Bridge OCID

enterpriseManagerEntityDisplayName string

Enterprise Manager Entity Display Name

enterpriseManagerEntityIdentifier string

Enterprise Manager Entity Unique Identifier

enterpriseManagerEntityName string

Enterprise Manager Entity Name

enterpriseManagerEntityType string

Enterprise Manager Entity Type

enterpriseManagerIdentifier string

Enterprise Manager Unqiue Identifier

entitySource string

Source of the database entity.

exadataInsightId string

The OCID of the Exadata insight.

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

Database insight identifier

lifecycleDetails string

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

opsiPrivateEndpointId string

The OCID of the OPSI private endpoint

processorCount number

Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

serviceName string

Database service name used for connection requests.

state string

The current state of the database.

status string

Indicates the status of a database insight in Operations Insights

systemTags {[key: string]: any}

System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated string

The time the the database insight was first enabled. An RFC3339 formatted datetime string

timeUpdated string

The time the database insight was updated. An RFC3339 formatted datetime string

compartment_id str

Compartment identifier of the database

connection_credential_details GetDatabaseInsightConnectionCredentialDetail]

User credential details to connect to the database. This is supplied via the External Database Service.

connection_details GetDatabaseInsightConnectionDetail]

Connection details to connect to the database. HostName, protocol, and port should be specified.

credential_details GetDatabaseInsightCredentialDetail]

User credential details to connect to the database.

database_connection_status_details str

A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

database_display_name str

Display name of database

database_id str

The OCID of the database.

database_insight_id str
database_name str

Name of database

database_resource_type str

Oracle Cloud Infrastructure database resource type

database_type str

Operations Insights internal representation of the database type.

database_version str

The version of the database.

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"}

deployment_type str
enterprise_manager_bridge_id str

OPSI Enterprise Manager Bridge OCID

enterprise_manager_entity_display_name str

Enterprise Manager Entity Display Name

enterprise_manager_entity_identifier str

Enterprise Manager Entity Unique Identifier

enterprise_manager_entity_name str

Enterprise Manager Entity Name

enterprise_manager_entity_type str

Enterprise Manager Entity Type

enterprise_manager_identifier str

Enterprise Manager Unqiue Identifier

entity_source str

Source of the database entity.

exadata_insight_id str

The OCID of the Exadata insight.

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

Database insight identifier

lifecycle_details str

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

opsi_private_endpoint_id str

The OCID of the OPSI private endpoint

processor_count int

Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

service_name str

Database service name used for connection requests.

state str

The current state of the database.

status str

Indicates the status of a database insight in Operations Insights

system_tags Mapping[str, Any]

System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

time_created str

The time the the database insight was first enabled. An RFC3339 formatted datetime string

time_updated str

The time the database insight was updated. An RFC3339 formatted datetime string

compartmentId String

Compartment identifier of the database

connectionCredentialDetails List<Property Map>

User credential details to connect to the database. This is supplied via the External Database Service.

connectionDetails List<Property Map>

Connection details to connect to the database. HostName, protocol, and port should be specified.

credentialDetails List<Property Map>

User credential details to connect to the database.

databaseConnectionStatusDetails String

A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

databaseDisplayName String

Display name of database

databaseId String

The OCID of the database.

databaseInsightId String
databaseName String

Name of database

databaseResourceType String

Oracle Cloud Infrastructure database resource type

databaseType String

Operations Insights internal representation of the database type.

databaseVersion String

The version of the database.

definedTags Map<Any>

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

deploymentType String
enterpriseManagerBridgeId String

OPSI Enterprise Manager Bridge OCID

enterpriseManagerEntityDisplayName String

Enterprise Manager Entity Display Name

enterpriseManagerEntityIdentifier String

Enterprise Manager Entity Unique Identifier

enterpriseManagerEntityName String

Enterprise Manager Entity Name

enterpriseManagerEntityType String

Enterprise Manager Entity Type

enterpriseManagerIdentifier String

Enterprise Manager Unqiue Identifier

entitySource String

Source of the database entity.

exadataInsightId String

The OCID of the Exadata insight.

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

Database insight identifier

lifecycleDetails String

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

opsiPrivateEndpointId String

The OCID of the OPSI private endpoint

processorCount Number

Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

serviceName String

Database service name used for connection requests.

state String

The current state of the database.

status String

Indicates the status of a database insight in Operations Insights

systemTags Map<Any>

System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

timeCreated String

The time the the database insight was first enabled. An RFC3339 formatted datetime string

timeUpdated String

The time the database insight was updated. An RFC3339 formatted datetime string

Supporting Types

GetDatabaseInsightConnectionCredentialDetail

CredentialSourceName string

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

CredentialType string

Credential type.

PasswordSecretId string

The secret OCID mapping to the database credentials.

Role string

database user role.

UserName string

database user name.

CredentialSourceName string

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

CredentialType string

Credential type.

PasswordSecretId string

The secret OCID mapping to the database credentials.

Role string

database user role.

UserName string

database user name.

credentialSourceName String

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credentialType String

Credential type.

passwordSecretId String

The secret OCID mapping to the database credentials.

role String

database user role.

userName String

database user name.

credentialSourceName string

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credentialType string

Credential type.

passwordSecretId string

The secret OCID mapping to the database credentials.

role string

database user role.

userName string

database user name.

credential_source_name str

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credential_type str

Credential type.

password_secret_id str

The secret OCID mapping to the database credentials.

role str

database user role.

user_name str

database user name.

credentialSourceName String

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credentialType String

Credential type.

passwordSecretId String

The secret OCID mapping to the database credentials.

role String

database user role.

userName String

database user name.

GetDatabaseInsightConnectionDetail

HostName string

Name of the listener host that will be used to create the connect string to the database.

Hosts List<GetDatabaseInsightConnectionDetailHost>

List of hosts and port for private endpoint accessed database resource.

Port int

Listener port number used for connection requests.

Protocol string

Protocol used for connection requests for private endpoint accssed database resource.

ServiceName string

Database service name used for connection requests.

HostName string

Name of the listener host that will be used to create the connect string to the database.

Hosts []GetDatabaseInsightConnectionDetailHost

List of hosts and port for private endpoint accessed database resource.

Port int

Listener port number used for connection requests.

Protocol string

Protocol used for connection requests for private endpoint accssed database resource.

ServiceName string

Database service name used for connection requests.

hostName String

Name of the listener host that will be used to create the connect string to the database.

hosts List<GetDatabaseInsightConnectionDetailHost>

List of hosts and port for private endpoint accessed database resource.

port Integer

Listener port number used for connection requests.

protocol String

Protocol used for connection requests for private endpoint accssed database resource.

serviceName String

Database service name used for connection requests.

hostName string

Name of the listener host that will be used to create the connect string to the database.

hosts GetDatabaseInsightConnectionDetailHost[]

List of hosts and port for private endpoint accessed database resource.

port number

Listener port number used for connection requests.

protocol string

Protocol used for connection requests for private endpoint accssed database resource.

serviceName string

Database service name used for connection requests.

host_name str

Name of the listener host that will be used to create the connect string to the database.

hosts GetDatabaseInsightConnectionDetailHost]

List of hosts and port for private endpoint accessed database resource.

port int

Listener port number used for connection requests.

protocol str

Protocol used for connection requests for private endpoint accssed database resource.

service_name str

Database service name used for connection requests.

hostName String

Name of the listener host that will be used to create the connect string to the database.

hosts List<Property Map>

List of hosts and port for private endpoint accessed database resource.

port Number

Listener port number used for connection requests.

protocol String

Protocol used for connection requests for private endpoint accssed database resource.

serviceName String

Database service name used for connection requests.

GetDatabaseInsightConnectionDetailHost

HostIp string

Host IP used for connection requests for Cloud DB resource.

Port int

Listener port number used for connection requests.

HostIp string

Host IP used for connection requests for Cloud DB resource.

Port int

Listener port number used for connection requests.

hostIp String

Host IP used for connection requests for Cloud DB resource.

port Integer

Listener port number used for connection requests.

hostIp string

Host IP used for connection requests for Cloud DB resource.

port number

Listener port number used for connection requests.

host_ip str

Host IP used for connection requests for Cloud DB resource.

port int

Listener port number used for connection requests.

hostIp String

Host IP used for connection requests for Cloud DB resource.

port Number

Listener port number used for connection requests.

GetDatabaseInsightCredentialDetail

CredentialSourceName string

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

CredentialType string

Credential type.

PasswordSecretId string

The secret OCID mapping to the database credentials.

Role string

database user role.

UserName string

database user name.

CredentialSourceName string

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

CredentialType string

Credential type.

PasswordSecretId string

The secret OCID mapping to the database credentials.

Role string

database user role.

UserName string

database user name.

credentialSourceName String

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credentialType String

Credential type.

passwordSecretId String

The secret OCID mapping to the database credentials.

role String

database user role.

userName String

database user name.

credentialSourceName string

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credentialType string

Credential type.

passwordSecretId string

The secret OCID mapping to the database credentials.

role string

database user role.

userName string

database user name.

credential_source_name str

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credential_type str

Credential type.

password_secret_id str

The secret OCID mapping to the database credentials.

role str

database user role.

user_name str

database user name.

credentialSourceName String

Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

credentialType String

Credential type.

passwordSecretId String

The secret OCID mapping to the database credentials.

role String

database user role.

userName String

database user name.

Package Details

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

This Pulumi package is based on the oci Terraform Provider.