ETL+ Source Driver for Microsoft SQL Server

Open

Source Objects panel toolbar

Add Source: New MS SQL Server connection.

Properties: Maintain MS SQL Server connection.

Refresh: Update source database metadata.

Where to Find in ETL+

Open

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.

How to Add Microsoft SQL Server Connections

1. Open the https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 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 https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 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

• https://dataself.atlassian.net/wiki/spaces/DS/pages/1673560421 – Microsoft SQL Server, Connecting to source data stored on a Microsoft SQL Server database.

• Source Objects panel

• Target Objects panel

• Extract SQL Statement panel

Position in the ETL+ Interface

• 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,

• Microsoft SQL Server (MS SQL Server)

• SQL Server

• MSSQL

• MS SQL

• Microsoft SQL