LEXI_IDP_Common_Schema_Baseline

You can run this pipeline to create common schema objects that are required for any LEXI-IDP pipeline. This pipeline can be used by all clients in an IDP environment, meaning you don't need to create a separate pipeline for each client.

  1. You can find pipeline template file named Lexi_Idp_Common_Schema_Baseline_{{BuildNumber}}.json under /templates/product/LexiTemplates folder in your s3 bucket for your IDP environment. Download this file.

  2. Open the Lexi_Idp_Common_Schema_Baseline_{{BuildNumber}}.json file and replace all instances of the following tags with the appropriate values.

    Parameters

    Pipeline Parameter 

    Tag

    Description

    Example

    staging_schema

    <STAGING_SCHEMA_VALUE>

    Staging schema name along with database name 

    format: {{DatabaseName}}.{{staging schema}}

    IDP_IQVIALEXIDEV_OA_DEV_SANDBOX_ENV_DWH.ODP_CORE_STAGING

    n/a

    <DATABASE_CONNECTION_NAME>

    default database connection name for IDP platform

    database-default

  3. Import the pipeline into your IDP environment, and then open it to ensure that the parameter values have been correctly set.