Extract, Transform, Load

The following example use case demonstrates a broader business logic involving the ETL transformations, that shows how typically in an enterprise environment, an execute functionality is used. This pipeline reads and moves files from the SQL Server Database to the Azure SQL Database and the Azure SQL Execute Snap reads the newly loaded table on the Azure SQL instance.



Download this Pipeline
  1. Extract: The SQL Server Select Snap reads the data from the SQL Server Database.
  2. Load: The Azure SQL Execute Snap inserts the data into an Azure SQL table.
  3. Read: Another Execute Snap is used to read the data from the newly loaded table on the Azure SQL database.
To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.