ETL+ Source Driver for Microsoft SQL Server

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

Source Objects panel toolbar

Add Source: New MS SQL Server connection.

Properties: Maintain MS SQL Server connection.

Refresh: Update source database metadata.

Source driver interface

Microsoft SQL Server Page

Alias: The name for the source object shown on the Source Objects panel. The name will be automatically populated, but you can customize it.

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

Database name: The name of the SQL source database.
- Click Refresh to load the list of available databases names.
- Select the source database from the dropdown list.
Back. Leave the page without saving or attempting to connection.
Connect. Connect to the source database.
Save. Save the configuration without attempting to connect.

	Help
	Change DataSource. Only shown when opened by Properties.

Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select Add Source > MS SQL..

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

Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select a MS SQL Server based Source Object on the Source Objects panel.
Select Properties > MS SQL..

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

Extract, Transform and Load (ETL) page
- Source Objects panel
  - Add Source, Properties or Refresh buttons

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