Customization

Tailor how data is transformed or mapped during migration with customization features

In most instances, Omni Loader's default settings quickly and efficiently merge any dataset. But if you want full control, there are additional settings you can apply.

Select the Options tab within your project. In the left side column you can choose customization for the following:

• Conversion

• Performance

• Database

• Mapping

• Custom scripts

• Logging

• Troubleshooting

Customize Mapping

Select Mapping to change the following:

• Schema names (e.g., dbo=fabric)

• Column names

  • Global renaming (e.g., BusinessEntityID=BizID).

  • Apply rules for name casing (lowercase, snake_case).

• Data type mapping:

  • E.g., convert nvarchar(15..30)=varchar(255)

Customize Database

Select Database to change the following:

• Timeout in seconds (leave at 0 to wait for as long as needed).

• Name casing: choose options from the menu.

• Incrementing columns: preserve or remove auto-incrementing property of columns.

  • Column nullability: force all columns in all tables to be nullable or not nullable.

  • Table indexing

• Default values: preserve or remove all column default values.

  • Use user data types: for large column types.

  • Use compute expressions: for target column types.

  • Fetch extended DDL: includes procedures, functions and rules when fetching metadata.