Customize tables and columns

Customize a source data by adding and removing tables and columns, respectively.

You can preview the result of your customization.

Add a table

NULL values aren’t supported in key columns for SAP source data. To use NULL values in key columns for SAP source data, use the advanced extraction mode. Read more in section Advanced extraction by script.

To add tables and columns, follow these steps:

  1. Open your source data and click Add Table.

    The table selection dialog opens.

  2. Select the table you want and click Next.

    The extract configuration type dialog opens.

  3. Select Standard and click Next.

    The column selection dialog opens.

  4. Select the columns you want to add and click Next.

    The key column selection dialog opens.

  5. Select the columns you want to define as key columns. Key columns are used to identify unique rows in a table and to remove duplicate rows.

  6. Click Next.

    The table is added to the source data.

  7. Pseudonymize the personally identifiable data to replace the confidential information with pseudonyms.

    Follow these steps:

    1. Choose the table whose columns you want pseudonymize and click .

    2. Open a column side menu and click .

    3. Enable Pseudonymize column.

    4. Click .

      Changes are saved immediately.

Create a table name alias

If you want to link multiple source data to your process data pipeline, table names must be unique across all source data. For this reason, you can create aliases for tables with the same name.

Aliases are only used as a reference and aren't included in the data extraction.

When creating, changing or removing aliases for table names, you must update the table names accordingly in the transformation rules. Read more in section Customizing Transformation Rules.

To create an alias for a table name, follow these steps:

  1. To open the table , click then Configure.

    The table page opens.

  2. Under Table Alias, enter the alias name.

  3. Click Save.

    The alias is displayed in the table as follows: "original-table-name" AS "alias"

When removing the alias, the original table name is used again.

Delete a table

To delete a table, click then .

When deleting tables from the source data, extracted table data is also permanently deleted.

Add a column

Follow these steps:

  1. To open the table , click then Configure.

  2. Click then Manage Table.

    The table editing dialog opens.

  3. Select the columns you want to add and click Next.

  4. Select the columns you want to define as key columns. Key columns are used to identify unique rows in a table and to remove duplicate rows.

  5. Click Update.

    The column is added to the source data.

Supported characters in names and aliases

Column names and aliases can contain only alpha-numeric and the following special characters:

  • a-z

  • A-Z

  • 0-9

  • §±!@#$%^*()_-+=[]{}'`~\|/.>? äöüÄÖÜß

Data pipelines fail if any name or alias contains other characters. Read more in section Troubleshooting.

Column alias

A column alias is created for each column automatically. The alias can be used when defining the transformation rules for extracted data.

For alias creation, any special character in the column name is replaced by an underscore.

Add descriptions to columns

To keep track of table data and simplify maintenance, you can add column descriptions. The descriptions are only displayed in SAP Signavio Process Intelligence. Descriptions aren't extracted.

Follow these steps:

  1. To expand a table, click .

  2. To open a column side menu, click .

  3. Under Description, add a description.

    Changes are saved immediately.

The description is displayed in the table.

To remove a description, delete the description text in the column side menu.

Delete a column

To delete a column, expand a table and click .

Preview data

To preview table extraction data, click then . A preview is only available if you have run the initial extraction already. Read more in section Run the initial extraction.

Next steps

Set delta criteria

Initial partition strategy