Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 194 of 212

182 C H A P T E R 9 | Introducing Azure SQL Data Warehouse Data Factory Coy Wizard," https://azure.microsoft.com/en-us/documentation/articles/data-factory- copy-data-wizard-tutorial/. The Copy Activity is useful for moving data from a data source to a destination. This activity supports a wide variety of data stores. However, when you use the Copy Activity to move data into your SQL Data Warehouse, you are limited to the following data sources: Blob storage SQL Database On-premises SQL Server SQL Server on IaaS Note You can find a complete list of supported data sources and destinations for the Copy Activity at "Data Movement Activities," https://azure.microsoft.com/en- us/documentation/articles/data-factory-data-movement-activities/. As an example, let's say that you want to load data from an on-premises SQL Server instance into SQL Data Warehouse. In the Azure Management Portal, click New, click Data + Analytics, and then click Data Factory. In the New Data Factory blade, provide a name for the data factory; optionally change the subscription, resource group, and region; and then click Create. After you receive notification that the data factory is ready, open the Data Factory blade, and then click the Author And Deploy tile to open the Editor where you perform the remaining steps. Next you must add a data gateway to connect Azure to your on-premises network. To do this, click the More Commands button in the toolbar, and then click New Data Gateway. In the Create blade, provide a name for the data gateway and click OK. You then have the option to perform an express setup by clicking the Install Directly On This Computer link or a manual setup by clicking the Download And Install Data Gateway link. If you choose the manual setup option, you must copy the key that is displayed in the Configure blade and use it when you configure the gateway, whereas the express setup configures the key automatically. An icon displays the gateway status in the notification area on the taskbar. You can proceed when the icon's ScreenTip displays "Data Management Gateway is running." Note For installation considerations and prerequisites for using Data Management Gateway, refer to "Move data between on-premises sources and cloud with Data Management Gateway" at https://azure.microsoft.com/en-us/documentation/articles/data-factory-move-data-between- onprem-and-cloud/. Next, you create a linked service for the source. Start by clicking the New Data Store button in the toolbar and selecting SQL Server. The JSON template for an on-premises SQL Server, as shown in Example 9-1, is displayed in the Drafts blade. Update the template with the server name, database name, and credentials. You must also have a gateway configured to allow ADF to connect to your on- premises server (as described at "Move data between on-premises sources and cloud with Data Management Gateway," https://azure.microsoft.com/en-us/documentation/articles/data-factory- move-data-between-onprem-and-cloud/) and supply the name of the gateway in the JSON template. Click Deploy on the toolbar to create the linked service. Example 9-1: Creating a linked service to an on-premises SQL Server { "name": "SqlServerLinkedService", "properties": {

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016