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
  • Server
  • Port
  • Authentication
  • Database name
  • Include views as tables
  1. Connections

SQL Server

PreviousSybase IQNextTeradata

Last updated 10 months ago

SQL Server, a flagship relational database management system by Microsoft, empowers organizations to efficiently store, manage, and retrieve structured data. With robust transactional support, comprehensive T-SQL capabilities, and seamless integration with Microsoft's suite of tools, SQL Server caters to diverse user profiles, from developers to database administrators, offering a reliable solution for data management and analysis.

Server

Name or IP address of the server.

Port

By default 1433.

Authentication

  • Windows Uses current Windows logged-in user. ā€SQL Server Username/password combination to authenticate the user.

Database name

Click on Select to pick a database from the list of all databases available on the server, or type in by hand.

Include views as tables

If checked, this will list all of the database views as if they were tables in the project and allow for data copying from said views and create the tables on the target.