This article shows how to load the data of an extraction into a Microsoft SQL Server database.

Creating a Microsoft SQL Server destination #

To load data into a Microsoft SQL Server, a Microsoft SQL Server destination must be created and defined.

1. In the main window of the designer, click [Destination] to open destination settings.
2. In the window “Destination Settings” click [+] (1) to manage destinations.
3. Click [Add] (2) to add a new destination.
4. Enter a Name and select SQLServer from the drop down list Type (3).
5. Fill in the fields Server Name and Database Name.
6. Click [Test Connection] (4) to check the connection to the database.
7. Click [OK] (5) to save the destination connection.

Loading data into the Microsoft SQL Server destination #

1. In the main window of the designer, select an extraction.
2. Click [Destination]. The window “Destination Settings” opens.
3. In the “Destination Settings” window, choose the SQLServer destination from the drop down menu. You can change the extraction-specific settings, if needed. This example uses the default settings:
   
4. Click [OK] to get back to the main window of the Designer.
5. Click [Run] > [Run] to start the extraction. A successful extraction procedure ends with the status Extraction finished successfully.

Checking the extraction result

Open your SQL Management Studio and check the existence of the successfully extracted table.