ETL+ Source Driver for Microsoft SQL Server

Creates and manages Source Objects that connect to Microsoft SQL Server.

v2026.01

Microsoft SQL Server Page

Add Source: New MS SQL Server connection.

Properties: Maintain MS SQL Server connection.

Refresh: Update source database metadata.

Where to Find in ETL+
image-20230803-042705.png
  • Alias: The name for the source object shown on the Source Objects panel. The name will be automatically populated, but you can customize it.

  • Schema: Defines the name of the SQL data warehouse’s schema that will store this source’s target tables. Recommend leaving this setting as-is.

    • This checkbox is dimmed for multi-tenant data warehouses (Essentials Edition), and the SQL schema name is copied from the Entity shown on the lower left corner of the page.

    • When the Schema checkbox is clear (unchecked), the SQL schema name is copied from Entity shown on the lower left corner of the page.

    • When the Schema checkbox is marked (checked), the SQL schema name is copied from Alias.

  • Server name: the MS SQL Server instance name or IP address.

  • Authentication: Select the appropriate Authentication option.

    • Enter credentials if applicable.

    • Authentication options in menu.

      • Windows Authentication

      • SQL Server Authentication: Login and Password required.

      • Azure Active Directory – Universal with MFA

      • Azure Active Directory – Password: Login and Password required.

      • Azure Active Directory – Integrated

image-20230803-043130.png
Authentication options
  • Database name: The name of the SQL source database.

    image-20230803-050634.png
    • Click Refresh to load the list of available databases names.

    • Select the source database from the dropdown list.

  • Device: Be sure to set the Device to a computer with direct access to the MS SQL Db.

  • Back. Leave the page without saving or attempting to connection.

  • Connect. Connect to the source database.

  • Save. Save the configuration without attempting to connect.

image-20230813-001241.png

Help

image-20230813-001426.png

Change DataSource. Only shown when opened by Properties.

Where to Find in ETL+

How to Add Microsoft SQL Server Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select Add Source > MS SQL..

For more on how to configure the connection see the Microsoft SQL Server Page section above.

How to Maintain Microsoft SQL Server Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select a MS SQL Server based Source Object on the Source Objects panel.

  3. Select Properties > MS SQL..

See the Microsoft SQL Server Page section above For more on how to configure the connection.

Position in the ETL+ Interface





Ranking influencer: Microsoft SQL Server, MS SQL Server, MSSQL, Microsoft SQL Server, MS SQL Server,

  • Microsoft SQL Server (MS SQL Server)

  • SQL Server

  • MSSQL

  • MS SQL

  • Microsoft SQL