Omni Loader Docs
  • OVERVIEW
    • About
    • Getting Started
    • Databases
    • Performance considerations
    • Prerequisites
  • Project Wizard
    • General
    • Database List
    • Favorites
    • Review
  • Project types
    • Full Table Copy
    • Data Compare & Sync
    • Change Data Capture
    • Overview
  • Project Options
    • General
    • Performance
    • Databases
    • Mapping
    • Logging
    • Troubleshooting
  • Table Options
    • Columns
    • WHERE clause
    • Partitioning
    • Cut-off
    • Options Override
  • Global Settings
    • Overview
  • Automations
    • Overview
    • JSON job specification
  • Connections
    • Amazon RedShift
    • Analytics Platform System
    • Synapse Dedicated Pool
    • CockroachDB
    • CSV
    • Databricks
    • DB2 iSeries
    • DB2 LUW
    • DB2 zOS
    • Greenplum
    • Google AlloyDB
    • Google BigQuery
    • MariaDB
    • MySQL
    • Netezza
    • NuoDB
    • ODBC
    • Oracle
    • Parquet
    • PostgreSQL
    • Snowflake
    • Sybase ASE
    • Sybase IQ
    • SQL Server
    • Teradata
    • Vertica ODBC
    • Fabric Lakehouse
    • Fabric Warehouse
    • Azure SQL Database
    • V-ORDER Fabric Lakehouse Optimization
Powered by GitBook
On this page
  • Summary log
  • Error log
  • Warning log
  • SQL Log
  • Error SQL Log
  • JSON log
  1. Project Options

Logging

PreviousMappingNextTroubleshooting

Last updated 8 months ago

Summary log

Contains the high-level overview data of the migration. Summary lists connections, migration stages, number of tables, and the outcome.

Error log

All errors occuring during the migration will be listed here.

Warning log

Warnings are notices that are still not exactly errors. For example, if we note several indexes covering exactly the same table columns, we will only create one of them and output a warning so you know about it.

SQL Log

All the SQL statements sent to the target database are in this log. Please note that bulk copy bypasses SQL engine for performance reasons and will be show here just as a comment.

Error SQL Log

Of all SQL statements sent to the target, this separate log file contains statements causing the target database to report an error.

JSON log

For automation purposes, all of the important information is available in a structured JSON log.