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
  • Connection Details
  • Server
  • Port
  • Username
  • Privilege
  • SID/Service Name
  • Wallet Location
  • Users to Include
  • Encrypted
  • Include views as tables
  1. Connections

Oracle

PreviousODBCNextParquet

Last updated 10 months ago

Connection Details

Server

The hostname or IP address of the Oracle database server.

Port

The TCP port on which the Oracle database listens. The default port for Oracle is typically 1521.

Username

The account username used for authentication. This can be quoted for case sensitivity.

Privilege

  • Normal ‍Standard database access.

  • SysDBA ‍Administrative access for performing high-level administrative functions.

  • SysOPER ‍Administrative access for performing basic operational tasks.

SID/Service Name

The Oracle System Identifier (SID) that uniquely identifies the instance or the service name for the Oracle database.

Wallet Location

Directory path to the client wallet for secure connections.

Users to Include

List specific users to include, separated by commas, if you want to limit the scope of the session.

Encrypted

Toggle to indicate if the connection should be encrypted for security.

Include views as tables

Check this option if you want to treat database views as tables for the migration process. This allows for the inclusion of views in the data migration or transformation steps.