Extensive Customization

Tune migrations to your project requirements.
Apply the rules on a project level and affect all table at once, then override on specific tables. Minimize time spent tweaking things.

Request a Demo
right pointing arrow
Contact Us
Omniloader  feature

Project Options

Project Options let you configure settings that apply to all tables in your project. They’re organized into six categories: Conversion, Performance, Mapping, Databases, Logging, and Troubleshooting.

Conversion
Would you like us to create the schema, or use the existing target tables? Should we copy all of the data? Should we create indexes and foreign keys?
Performance
Tweak the slicing if you know your source data is compressed. Fetch metadata on demand if your source server is super-slow. Throttle the network if you need to leave some breathing room for other systems.
Database
Tweak the timeout setting, disable certain functionality, or have us fetch and remap your procedures for the SQL Server family of databases.
Mapping
Set up easy automatic rename rules, or do a project-wide override of data type mapping rules. You can also change data placement for multiple source databases (data integration).
Logging
Omni Loader has six different logs, not counting the low-level debug log. All of the logs are saved in a timestamped folder structure, so you'll never lose history.
Table Options

Easily override project options for specific tables.
You have complete control where it matters.

Automatic mode
MANUAL MODE
PARTITIONING
Database icon representing more than 20 databases
Propagate project options

All your rules are applied to all tables automatically.

Learn more
Right pointing arrow
Massive Parallelism icon
Filter your data

Specify your own custom filter SQL expressions.

Learn more
Right pointing arrow
Renaming tables and fields icon representing the extensive mapping rules for customization
Preview target DDL

See the exact create table statement for the target database.

Learn more
Right pointing arrow
Database icon representing more than 20 databases
Full control

Use any names, data types or attributes.

Learn more
Right pointing arrow
Massive Parallelism icon
Start with project options

Benefit from rules affecting all tables. Start fine-tuning from there.

Learn more
Right pointing arrow
Renaming tables and fields icon representing the extensive mapping rules for customization
Link to existing tables

Create new tables or load data into existing ones.

Learn more
Right pointing arrow
Repartition data on the fly

Copy the source partitioning, automatically fold partitions, or specify your own. For data warehouses, you can override the distribution level.

Read more about Options
Right pointing arrow
graphic icon
Sisyphus

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris imperdiet egestas blandit. Suspendisse rhoncus congue lorem ut malesuada.

Avatar image
Candice Doe
Product Manager, Sisyphus
FAQ

Frequently asked questions

Which databases do you support?
How are you different from your competitors?
How can we get Omni Loader?
Can we get a demo before purchasing?
How to contact you with pre-sales questions?
Do you offer phone support?
How do we deploy Omni Loader on premises?
Is this appropriate for lift and shift migrations?
Do you support change data capture (CDC)?

Save time.
Get the job done.

Allow us to help you get your data migration job done as quickly as possible.

Learn more
Request a Demo
right pointing arrow
TECHNOLOGY
High Performance
Right pointing arrow
Customization
Right pointing arrow
Data Lakes and Warehouses
Right pointing arrow
Supported Databases
Right pointing arrow
Self-Tuning
Right pointing arrow
Console
Right pointing arrow
Deployment
Right pointing arrow
RESOURCES
About Us
Right pointing arrow
Contact
Right pointing arrow
Partners
Right pointing arrow
Product Documentation
Right pointing arrow
Video Tutorials
Right pointing arrow
Blog
Right pointing arrow
Help Center
Right pointing arrow
Case Studies
Right pointing arrow
LEGAL
Terms
Right pointing arrow
Privacy
Right pointing arrow
Contact
Right pointing arrow
© 2025 Spectral Core. All rights reserved.
By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.
PreferencesDenyAccept