Oracle Cloud Infrastructure v2.27.0, Mar 20 25

Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi

oci.GoldenGate.getPipelineSchemaTables

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi

Example Usage

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

const testPipelineSchemaTables = oci.GoldenGate.getPipelineSchemaTables({
    pipelineId: testPipeline.id,
    sourceSchemaName: pipelineSchemaTableSourceSchemaName,
    targetSchemaName: pipelineSchemaTableTargetSchemaName,
    displayName: pipelineSchemaTableDisplayName,
});

import pulumi
import pulumi_oci as oci

test_pipeline_schema_tables = oci.GoldenGate.get_pipeline_schema_tables(pipeline_id=test_pipeline["id"],
    source_schema_name=pipeline_schema_table_source_schema_name,
    target_schema_name=pipeline_schema_table_target_schema_name,
    display_name=pipeline_schema_table_display_name)

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := goldengate.GetPipelineSchemaTables(ctx, &goldengate.GetPipelineSchemaTablesArgs{
			PipelineId:       testPipeline.Id,
			SourceSchemaName: pipelineSchemaTableSourceSchemaName,
			TargetSchemaName: pipelineSchemaTableTargetSchemaName,
			DisplayName:      pulumi.StringRef(pipelineSchemaTableDisplayName),
		}, 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 testPipelineSchemaTables = Oci.GoldenGate.GetPipelineSchemaTables.Invoke(new()
    {
        PipelineId = testPipeline.Id,
        SourceSchemaName = pipelineSchemaTableSourceSchemaName,
        TargetSchemaName = pipelineSchemaTableTargetSchemaName,
        DisplayName = pipelineSchemaTableDisplayName,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.GoldenGate.GoldenGateFunctions;
import com.pulumi.oci.GoldenGate.inputs.GetPipelineSchemaTablesArgs;
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 testPipelineSchemaTables = GoldenGateFunctions.getPipelineSchemaTables(GetPipelineSchemaTablesArgs.builder()
            .pipelineId(testPipeline.id())
            .sourceSchemaName(pipelineSchemaTableSourceSchemaName)
            .targetSchemaName(pipelineSchemaTableTargetSchemaName)
            .displayName(pipelineSchemaTableDisplayName)
            .build());

    }
}

variables:
  testPipelineSchemaTables:
    fn::invoke:
      function: oci:GoldenGate:getPipelineSchemaTables
      arguments:
        pipelineId: ${testPipeline.id}
        sourceSchemaName: ${pipelineSchemaTableSourceSchemaName}
        targetSchemaName: ${pipelineSchemaTableTargetSchemaName}
        displayName: ${pipelineSchemaTableDisplayName}

Using getPipelineSchemaTables

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 getPipelineSchemaTables(args: GetPipelineSchemaTablesArgs, opts?: InvokeOptions): Promise<GetPipelineSchemaTablesResult>
function getPipelineSchemaTablesOutput(args: GetPipelineSchemaTablesOutputArgs, opts?: InvokeOptions): Output<GetPipelineSchemaTablesResult>

def get_pipeline_schema_tables(display_name: Optional[str] = None,
                               filters: Optional[Sequence[_goldengate.GetPipelineSchemaTablesFilter]] = None,
                               pipeline_id: Optional[str] = None,
                               source_schema_name: Optional[str] = None,
                               target_schema_name: Optional[str] = None,
                               opts: Optional[InvokeOptions] = None) -> GetPipelineSchemaTablesResult
def get_pipeline_schema_tables_output(display_name: Optional[pulumi.Input[str]] = None,
                               filters: Optional[pulumi.Input[Sequence[pulumi.Input[_goldengate.GetPipelineSchemaTablesFilterArgs]]]] = None,
                               pipeline_id: Optional[pulumi.Input[str]] = None,
                               source_schema_name: Optional[pulumi.Input[str]] = None,
                               target_schema_name: Optional[pulumi.Input[str]] = None,
                               opts: Optional[InvokeOptions] = None) -> Output[GetPipelineSchemaTablesResult]

func GetPipelineSchemaTables(ctx *Context, args *GetPipelineSchemaTablesArgs, opts ...InvokeOption) (*GetPipelineSchemaTablesResult, error)
func GetPipelineSchemaTablesOutput(ctx *Context, args *GetPipelineSchemaTablesOutputArgs, opts ...InvokeOption) GetPipelineSchemaTablesResultOutput

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

public static class GetPipelineSchemaTables 
{
    public static Task<GetPipelineSchemaTablesResult> InvokeAsync(GetPipelineSchemaTablesArgs args, InvokeOptions? opts = null)
    public static Output<GetPipelineSchemaTablesResult> Invoke(GetPipelineSchemaTablesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetPipelineSchemaTablesResult> getPipelineSchemaTables(GetPipelineSchemaTablesArgs args, InvokeOptions options)
public static Output<GetPipelineSchemaTablesResult> getPipelineSchemaTables(GetPipelineSchemaTablesArgs args, InvokeOptions options)

fn::invoke:
  function: oci:GoldenGate/getPipelineSchemaTables:getPipelineSchemaTables
  arguments:
    # arguments dictionary

The following arguments are supported:

PipelineId string: The OCID of the pipeline created.
SourceSchemaName string: Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName string: Name of the target schema obtained from get schema endpoint of the created pipeline.
DisplayName string: A filter to return only the resources that match the entire 'displayName' given.
Filters List<GetPipelineSchemaTablesFilter>

PipelineId string: The OCID of the pipeline created.
SourceSchemaName string: Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName string: Name of the target schema obtained from get schema endpoint of the created pipeline.
DisplayName string: A filter to return only the resources that match the entire 'displayName' given.
Filters []GetPipelineSchemaTablesFilter

pipelineId String: The OCID of the pipeline created.
sourceSchemaName String: Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName String: Name of the target schema obtained from get schema endpoint of the created pipeline.
displayName String: A filter to return only the resources that match the entire 'displayName' given.
filters List<GetPipelineSchemaTablesFilter>

pipelineId string: The OCID of the pipeline created.
sourceSchemaName string: Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName string: Name of the target schema obtained from get schema endpoint of the created pipeline.
displayName string: A filter to return only the resources that match the entire 'displayName' given.
filters GetPipelineSchemaTablesFilter[]

pipeline_id str: The OCID of the pipeline created.
source_schema_name str: Name of the source schema obtained from get schema endpoint of the created pipeline.
target_schema_name str: Name of the target schema obtained from get schema endpoint of the created pipeline.
display_name str: A filter to return only the resources that match the entire 'displayName' given.
filters Sequence[goldengate.GetPipelineSchemaTablesFilter]

pipelineId String: The OCID of the pipeline created.
sourceSchemaName String: Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName String: Name of the target schema obtained from get schema endpoint of the created pipeline.
displayName String: A filter to return only the resources that match the entire 'displayName' given.
filters List<Property Map>

getPipelineSchemaTables Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
PipelineId string
PipelineSchemaTableCollections List<GetPipelineSchemaTablesPipelineSchemaTableCollection>: The list of pipeline_schema_table_collection.
SourceSchemaName string: The schema name from the database connection.
TargetSchemaName string: The schema name from the database connection.
DisplayName string
Filters List<GetPipelineSchemaTablesFilter>

Id string: The provider-assigned unique ID for this managed resource.
PipelineId string
PipelineSchemaTableCollections []GetPipelineSchemaTablesPipelineSchemaTableCollection: The list of pipeline_schema_table_collection.
SourceSchemaName string: The schema name from the database connection.
TargetSchemaName string: The schema name from the database connection.
DisplayName string
Filters []GetPipelineSchemaTablesFilter

id String: The provider-assigned unique ID for this managed resource.
pipelineId String
pipelineSchemaTableCollections List<GetPipelineSchemaTablesPipelineSchemaTableCollection>: The list of pipeline_schema_table_collection.
sourceSchemaName String: The schema name from the database connection.
targetSchemaName String: The schema name from the database connection.
displayName String
filters List<GetPipelineSchemaTablesFilter>

id string: The provider-assigned unique ID for this managed resource.
pipelineId string
pipelineSchemaTableCollections GetPipelineSchemaTablesPipelineSchemaTableCollection[]: The list of pipeline_schema_table_collection.
sourceSchemaName string: The schema name from the database connection.
targetSchemaName string: The schema name from the database connection.
displayName string
filters GetPipelineSchemaTablesFilter[]

id str: The provider-assigned unique ID for this managed resource.
pipeline_id str
pipeline_schema_table_collections Sequence[goldengate.GetPipelineSchemaTablesPipelineSchemaTableCollection]: The list of pipeline_schema_table_collection.
source_schema_name str: The schema name from the database connection.
target_schema_name str: The schema name from the database connection.
display_name str
filters Sequence[goldengate.GetPipelineSchemaTablesFilter]

id String: The provider-assigned unique ID for this managed resource.
pipelineId String
pipelineSchemaTableCollections List<Property Map>: The list of pipeline_schema_table_collection.
sourceSchemaName String: The schema name from the database connection.
targetSchemaName String: The schema name from the database connection.
displayName String
filters List<Property Map>

Supporting Types

GetPipelineSchemaTablesFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetPipelineSchemaTablesPipelineSchemaTableCollection

Items List<GetPipelineSchemaTablesPipelineSchemaTableCollectionItem>: Array of source or target schema tables of a pipeline's assigned connection.
SourceSchemaName string: Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName string: Name of the target schema obtained from get schema endpoint of the created pipeline.

Items []GetPipelineSchemaTablesPipelineSchemaTableCollectionItem: Array of source or target schema tables of a pipeline's assigned connection.
SourceSchemaName string: Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName string: Name of the target schema obtained from get schema endpoint of the created pipeline.

items List<GetPipelineSchemaTablesPipelineSchemaTableCollectionItem>: Array of source or target schema tables of a pipeline's assigned connection.
sourceSchemaName String: Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName String: Name of the target schema obtained from get schema endpoint of the created pipeline.

items GetPipelineSchemaTablesPipelineSchemaTableCollectionItem[]: Array of source or target schema tables of a pipeline's assigned connection.
sourceSchemaName string: Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName string: Name of the target schema obtained from get schema endpoint of the created pipeline.

items Sequence[goldengate.GetPipelineSchemaTablesPipelineSchemaTableCollectionItem]: Array of source or target schema tables of a pipeline's assigned connection.
source_schema_name str: Name of the source schema obtained from get schema endpoint of the created pipeline.
target_schema_name str: Name of the target schema obtained from get schema endpoint of the created pipeline.

items List<Property Map>: Array of source or target schema tables of a pipeline's assigned connection.
sourceSchemaName String: Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName String: Name of the target schema obtained from get schema endpoint of the created pipeline.

GetPipelineSchemaTablesPipelineSchemaTableCollectionItem

SourceTableName string: The table name from the schema of database connection.
TargetTableName string: The table name from the schema of database connection.

SourceTableName string: The table name from the schema of database connection.
TargetTableName string: The table name from the schema of database connection.

sourceTableName String: The table name from the schema of database connection.
targetTableName String: The table name from the schema of database connection.

sourceTableName string: The table name from the schema of database connection.
targetTableName string: The table name from the schema of database connection.

source_table_name str: The table name from the schema of database connection.
target_table_name str: The table name from the schema of database connection.

sourceTableName String: The table name from the schema of database connection.
targetTableName String: The table name from the schema of database connection.

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi

pulumi/pulumi-oci

oci.GoldenGate.getPipelineSchemaTables

On this page

On this page

Example Usage

Using getPipelineSchemaTables

getPipelineSchemaTables Result

Supporting Types

GetPipelineSchemaTablesFilter

GetPipelineSchemaTablesPipelineSchemaTableCollection

GetPipelineSchemaTablesPipelineSchemaTableCollectionItem

Package Details

On this page

On this page