Page Comparison

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.

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.

Related Pages

• ETL+ for MS SQL Server – Microsoft SQL Server, Connecting to source data stored on a Microsoft SQL Server database.

  • Microsoft SQL Server Technical Details

• Source Objects panel

  • ETL+ Source Drivers

• Target Objects panel

• Extract SQL Statement panel

Anchor
UIPosition UIPosition

Position in the ETL+ Interface

• Extract, Transform and Load (ETL) page

  • Source Objects panel

    • Add Source, Properties or Refresh buttons

Excerpt
hidden true name Internal Note
INTERNAL NOTES: Do not delete Source Objects panel button toolbar

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