BI Project Deployment

SQL Server 2014    |    Expert
  • 11 Videos | 1h 11m 24s
  • Earns a Badge
Likes 25 Likes 25
The SQL Server 2014 ETL process provides a convenient way to populate your data warehouse database. Discover how to deploy ETL projects and packages, and manage ETL solutions.

WHAT YOU WILL LEARN

  • describe the differences between the package deployment model and the project deployment model, and project deployment model features
    use parameters in packages, including sharing them
    use the Integration Service Deployment Wizard to deploy projects to the SSISDB catalog using the project deployment model
    set up a server environment to specify runtime values for packages within a project
    use package configuration files to modify the properties of package elements at run time
    build the SSIS project to create a package deployment utility with the packages for deployment
  • copy the deployment folder and run the Package Installation Wizard to install packages to the file system or instance
    configure security on packages requiring different security requirements
    manage the SSIS catalog, including the modifying the catalog properties
    use catalog stored procedures and views to manage SSIS objects
    backup and restore the SSIS catalog, including moving it

IN THIS COURSE

  • Playable
    1. 
    The Project Deployment Model
    7m 24s
    UP NEXT
  • Playable
    2. 
    Using Parameters in Packages
    8m 37s
  • Locked
    3. 
    Using the Integration Service Deployment Wizard
    5m 35s
    FREE ACCESS
  • Locked
    4. 
    Setting Up a Server Environment for a Project
    6m 40s
    FREE ACCESS
  • Locked
    5. 
    Creating Package Configuration Files
    8m 40s
    FREE ACCESS
  • Locked
    6. 
    Creating a Package Deployment Utility
    3m 39s
    FREE ACCESS
  • Locked
    7. 
    Installing Packages to the File System or Instance
    8m 58s
    FREE ACCESS
  • Locked
    8. 
    Configuring Package and Project Deployment Security
    5m 33s
    FREE ACCESS
  • Locked
    9. 
    Managing the SSIS Catalog
    6m 21s
    FREE ACCESS
  • Locked
    10. 
    Using Catalog Stored Procedure and Views for Logging
    6m 16s
    FREE ACCESS
  • Locked
    11. 
    Backing Up and Restoring the SSIS Catalog
    3m 40s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory
COURSE Modern Data Warehouses
COURSE Database Fundamentals: Working with SQL Commands

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Designing BI Infrastructure
Likes 121 Likes 121  
COURSE Data Warehouse Essential: Concepts
Likes 144 Likes 144  
COURSE Extract, Transform, & Load
Likes 103 Likes 103