---
title: "Configure table mappings for a mainframe pipeline"
method: POST
path: "/v1/integration/mainframe/projects/{projectId}/pipelines/{pipelineId}/mappings"
tags: ["Build and Configure Mainframe Integration Projects"]
---

# Configure table mappings for a mainframe pipeline

`POST /v1/integration/mainframe/projects/{projectId}/pipelines/{pipelineId}/mappings`

## Request

- Base URL: `https://integration-adapter.connect.cloud.precisely.com`
- URL: `https://integration-adapter.connect.cloud.precisely.com/v1/integration/mainframe/projects/{projectId}/pipelines/{pipelineId}/mappings`
- Auth: HTTP bearer

Configures source-to-target table mappings for a specified pipeline within a mainframe integration project.

**Process Overview:**
1. **Resource Validation** - Validates project and pipeline existence
2. **Mapping Configuration** - Applies source-to-target table mappings, supporting RDBMS source to RDBMS target type mappings)
3. **Customization** - Allows per-source customization (schema casing, table casing and column casing)
5. **Validation & Persistence** - Validates and saves the mapping configuration

**Use Cases:**
- Define or update table mappings for a pipeline
- Support advanced mapping scenarios (schema casing, table casing and column casing)
- Integrate with RDBMS source to RDBMS target type mapping for a reverse-sync mainframe pipeline

**Required Permissions:** Either `replication-pipeline::create` or `replication-pipeline::update` when permission harmonization is enabled; otherwise, `replication-pipeline::manage`.

## Path parameters

- `projectId` string, required
- `pipelineId` string, required

## Request body

- MainframeTableMappingRequest: Request model for automatic source-to-target table mapping for a mainframe replication pipeline
  - `mappings` MainframeMappingConfiguration[], required: List of mapping objects, each defining a 1-to-1 source-to-target mapping
    - `source` MainframeSourceMapping: Source mapping configuration for mainframe table mapping request
      - `database` string: Database name of the source
      - `schema` string: Schema name of the source
      - `table` string: Table name of the source
      - `schemaCase` 'NONE' | 'MATCH_ORIGINAL_CASE' | 'SENTENCE_CASE' | 'LOWER_CASE' | 'UPPER_CASE' | 'TOGGLE_CASE' | 'CAPITALIZE_EACH_WORD': Case transformation to apply to source schema names. Default is NONE.
      - `tableCase` 'NONE' | 'MATCH_ORIGINAL_CASE' | 'SENTENCE_CASE' | 'LOWER_CASE' | 'UPPER_CASE' | 'TOGGLE_CASE' | 'CAPITALIZE_EACH_WORD': Case transformation to apply to source table names. Default is NONE.
      - `columnCase` 'NONE' | 'MATCH_ORIGINAL_CASE' | 'SENTENCE_CASE' | 'LOWER_CASE' | 'UPPER_CASE' | 'TOGGLE_CASE' | 'CAPITALIZE_EACH_WORD': Case transformation to apply to source column names. Default is NONE.
    - `target` MainframeTargetMapping, required: Target mapping configuration for mainframe table mapping request
      - `database` string: Database name of the target
      - `schema` string, required: Schema name of the target
      - `table` string, required: Table name of the target

## Response `201`

Table mappings configured successfully

- MainframeTableMappingResponse: Response model containing table mapping information for mainframe replication pipelines
  - `id` string: Unique identifier of the table mapping
  - `sourceDatabase` string: Name of the source database
  - `sourceSchema` string: Name of the source schema
  - `sourceTable` string: Name of the source table
  - `targetDatabase` string: Name of the target database
  - `targetSchema` string: Name of the target schema
  - `targetTable` string: Name of the target table
  - `targetTopic` string: Name of the target topic
  - `targetSubject` string: Name of the target subject for schema registry
  - `sourceSchemaCase` 'NONE' | 'MATCH_ORIGINAL_CASE' | 'SENTENCE_CASE' | 'LOWER_CASE' | 'UPPER_CASE' | 'TOGGLE_CASE' | 'CAPITALIZE_EACH_WORD': Case transformation to apply to source schema names. Default is NONE.
  - `sourceTableCase` 'NONE' | 'MATCH_ORIGINAL_CASE' | 'SENTENCE_CASE' | 'LOWER_CASE' | 'UPPER_CASE' | 'TOGGLE_CASE' | 'CAPITALIZE_EACH_WORD': Case transformation to apply to source table names. Default is NONE.
  - `sourceColumnCase` 'NONE' | 'MATCH_ORIGINAL_CASE' | 'SENTENCE_CASE' | 'LOWER_CASE' | 'UPPER_CASE' | 'TOGGLE_CASE' | 'CAPITALIZE_EACH_WORD': Case transformation to apply to source column names. Default is NONE.

## Other responses

- `400`: Bad Request - Invalid mapping configuration
- `403`: Forbidden - User lacks 'replication-pipeline::create' or 'replication-pipeline::update' when permission harmonization is enabled, or legacy 'replication-pipeline::manage' otherwise
- `404`: Not Found - Project or pipeline does not exist
- `500`: Internal Server Error - Processing failures

---

[API](https://skmtc.dev/precisely/apis/precisely-integration-adapter-service.md) · [All operations](https://skmtc.dev/precisely/apis/precisely-integration-adapter-service/llms.txt) · [OpenAPI document](https://skmtc.dev/precisely/apis/precisely-integration-adapter-service/revisions/2d2629f4987d?raw)