Friday 26 January 2018

Azure Data Factory: Visual Tools enabled in public preview

Our goal with visual tools for ADF v2 is to increase productivity and efficiency for both new and advanced users with intuitive experiences. You can get started by clicking the Author & Monitor tile in your provisioned v2 data factory blade.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Get Started Quickly


1. Create your first ADF v2 pipeline

2. Quickly Copy Data from a bunch of data sources using the copy wizard

3. Configure SSIS IR to lift and shift SSIS packages to Azure

4. Set up code repo (VSTS GIT) for source control, collaboration, versioning etc..

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Visual Authoring


Author Control Flow Pipelines

Create pipelines, drag and drop activities, connect them on-success, on-failure, on-completion.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Create Azure & Self Hosted Integration runtimes

Create a self hosted integration runtime for hybrid data movement or an Azure-SSIS IR for lifting and shifting SSIS packages to Azure. Create linked service connections to your data stores or compute.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Support for all control flow activities running on Azure computes

Control Flow Activities:

◉ HDInsight Hive, HDInsight Pig, HDInsight Map Reduce, HDI Streaming, HDI Spark, U-SQL, Stored Procedure, Web, For Each, Get Metadata, Look up, Execute Pipeline

Support for Azure Computes:

◉ HDI (on-demand, BYOC), ADLA, Azure Batch

Iterative development and debugging

Do Test Runs before attaching a trigger on the pipeline and running on-demand or on a schedule.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Parameterize pipelines and datasets

Parameterize using expressions, system variables.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Rich Validation Support

You can now validate your pipelines to know about missed property configurations or incorrect configurations. Simply click the Validate button in the pipeline canvas. This will generate the validation output in side drawer. You can then click on each entry to go straight to the location of the missing validation.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Trigger pipelines

Trigger on-demand, run pipelines on schedule.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Use VSTS GIT

VSTS GIT for source control, collaboration, versioning, etc.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Copy Data

Data Stores (65)

Support for 65 data stores. 18 stores with first class support that require users to provide just configuration values. The remaining 47 stores can be used with JSON.

18 stores with first class support:

◉ Azure Blob, Azure CosmosDB, Azure Database for MySQL, Azure Data Lake Store, Amazon Redshift, Amazon S3, Azure SQL DW, Azure SQL, Azure Table, File System, HDFS, MySQL, ODBC, Oracle, Salesforce, SAP HANA, SAP BW, SQL Server

47 Stores with JSON support:

◉ Search Index, Cassandra, HTTP file, Mongo DB, OData, Relational table, Dynamics 365, Dynamics CRM, Web table, AWS Marketplace, PostgreSQL, Concur, Couchbase, Drill, Oracle Eloqua, Google Big Query, Greenplum, HBase, Hive, HubSpot, Apache Impala, Jira, Magento, MariaDB, Marketo, PayPal, Phoenix, Presto, QuickBooks, ServiceNow, Shopify, Spark, Square, Xero, Zoho, DB2, FTP, GE Historian, Informix, Microsoft Access, MongoDB, SAP Cloud for customer

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Use copy wizard to quickly copy data from a bunch of data sources

The familiar ADF v1 copy wizard is now available in ADF v2 to do one-time quick import. Copy Wizard generates pipelines with copy activities on authoring canvas. The copy activities can now be extended to run other activities like Spark, USQL, Stored Proc etc. on-success, on-failure etc. and create the entire control flow pipeline.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Guided tour

Click on the Information Icon in the lower left. You can then click Guided tour to get step by step instructions on how to visually monitor your pipeline and activity runs.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Feedback

Click on the Feedback icon to give us feedback on various features or any issues that you may be facing.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Select data factory

Hover on the Data Factory icon on the top left. Click on the Arrow icon to see a list of Azure subscriptions and data factories that you can monitor.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Visual Monitoring


List View Monitoring

Monitor pipeline, activity & trigger runs with a simple list view interface. All the runs are displayed in local browser time zone. You can change the time zone and all the date time fields will snap to the selected time zone.

Monitor Pipeline Runs:

List view showcasing each pipeline run for your data factory v2 pipelines.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Monitor Activity Runs:

List view showcasing activity runs corresponding to each pipeline run. Click Activity Runs icon under the Actions column to view activity runs for each pipeline run.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Important note: You need to click the Refresh icon on top to refresh the list of pipeline and activity runs. Auto-refresh is currently not supported.

Monitor Trigger Runs:

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Rich ordering and filtering

Order pipeline runs in desc/asc by Run Start and filter pipeline runs pipeline name, run start and run status.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Add/Remove columns to list view

Right click the list view header and choose columns that you want to appear in the list view.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Reorder columns widths in list view

Increase and decrease the column widths in list view by simply hovering over the column header.

Monitor Integration Runtimes

Monitor health of your Self Hosted, Azure, Azure-SSIS Integration runtimes.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

Cancel/Re-run your pipeline runs

Cancel a pipeline run or re-run a pipeline run with already defined parameters.

Azure Tutorials and Materials, Azure Guides, Azure Learning, Microsoft Materials

This is the first public release of ADF v2 visual tools We are continuously working to refresh the released bits with new features based on customer feedback. Get more information and detailed steps for using the ADF v2 visual tools.

Related Posts

0 comments:

Post a Comment