Fine-tuning individual tables

What to do if you need more control

There may be times when you want more granular controls, such as choosing a specific location where Omni Loader can filter the data for you. Or changing specific data names, target types, values, etc.

Where is Where?

To customize a specific location for filtering records, select the Where tab in the Project display. Here you can enter your own SQL WHERE condition for the source table (e.g., column1 = 1 AND column2 <> 2).

This feature is particularly useful for partial data migrations, testing, or when only a specific segment of data needs to be transferred to the target system.

Switching to Manual mode

For full control of any table, switch from Automatic to Manual mode.

Omni Loader will reveal a detailed display of the column names, target names, types, values, etc.

By toggling between Automatic and Manual mode, you can continue to refine your settings for more nuanced control.