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
Contact Us
Omniloader  feature

Project Options

Project Options allow you to set up the project itself, affecting all the tables in the project. Within project options, there are 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 to other systems.
Database
Tweak the timeout setting, disable certain functionality, or have us fetch and remap your procedures for SQL Server family of databases.
Mapping
Set up easy automatic rename rules, or even do a project-wide override of data type mapping rules. For multiple source databases (data integration), change the data placement.
Logging
Omni Loader have six different logs, not counting the low-level debug log. All of the logs are saved in a timestamped folder structure. You will never lose history.
Table Options

Override project options for specific tables.
You have full control.

Automatic mode
MANUAL MODE
PARTITIONING
Propagate project options

All your rules are applied to all of the tables automatically.

Learn more
Filter your data

Specify your own custom filter SQL expressions.

Learn more
Preview target DDL

See the exact create table statement for the target database.

Learn more
Full control

Use any names, data types or attributes.

Learn more
Start with project options

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

Learn more
Link to existing tables

Create new tables or load data into existing ones.

Learn more
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
Sisyphus

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

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 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
TECHNOLOGY
High Performance
Customization
Distributed Migration Cluster
Data Lakes and Warehouses
Supported Databases
Self-Tuning
Console
Deployment
RESOURCES
About Us
Contact
Partners
Product Documentation
Video Tutorials
Blog
Help Center
Case Studies
LEGAL
Terms
Privacy
Contact
© 2023 Spectral Core. All rights reserved.