Muutke küpsiste eelistusi

E-raamat: Data Integration Life Cycle Management with SSIS: A Short Introduction by Example

  • Formaat: EPUB+DRM
  • Ilmumisaeg: 17-Nov-2017
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484232767
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 49,39 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Data Integration Life Cycle Management with SSIS: A Short Introduction by ExampleSuurem pilt
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 17-Nov-2017
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484232767
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history.

Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices.

What You'll Learn
  • Generate dozens of SSIS packages in minutes to speed your integration projects
  • Reduce the execution of related groups of SSIS packages to a single command
  • Successfully handle SSIS catalog deployments and their projects
  • Monitor the execution and history of SSIS catalog projects
  • Manage your enterprise data integration life cycle through automated tools and utilities
Who This Book Is For

Database professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS.
About the Author ix
Acknowledgments xi
Foreword xiii
Chapter 1 Introduction to DILM
1(6)
Some History
2(5)
SSIS Is a Software Development Platform
2(1)
SSIS Is an Enterprise Data Integration Engine
3(1)
SSIS Is Difficult to Learn
4(1)
Lifecycle Management
4(1)
Solutions and Credit Where Credit Is Due
5(2)
Chapter 2 SSIS
7(18)
The Demo
8(1)
Adding Package Parameters
9(1)
Adding Project Parameters
10(2)
A Note About Variables, Parameters, and Scope
12(1)
Adding an Execute SQL Task
12(3)
A Note About SSIS Variable Scope
15(1)
Adding a Script Task
15(7)
Why C#?
16(2)
Why ProjectName and TaskName?
18(2)
Testing .Net Code Compiles Before Closing the VSTA Editor
20(2)
Testing Progress
22(2)
Conclusion
24(1)
Chapter 3 Source Control
25(16)
Source Control Client
26(1)
Creating a Team Project
26(3)
Configuring SSDT to Use TFS Online
29(12)
Chapter 4 Deploy to the SSIS Catalog
41(20)
Deploying from SSDT
41(4)
Deploying from the Command Line
45(5)
Deployment Failures
50(9)
Conclusion
59(2)
Chapter 5 Configure the SSIS Catalog Project
61(22)
Configuring Projects
62(1)
Configuring Connections
63(2)
Overriding the Connection Configuration
65(4)
Externalizing the Connection Configuration
69(9)
Creating an Environment
71(2)
Configuring an Environment
73(1)
Configuring a Reference
74(2)
Configuring a Reference Mapping
76(2)
Testing the Configuration
78(4)
Conclusion
82(1)
Chapter 6 Catalog Browser
83(12)
Why I Built DILM Suite
83(1)
Andy Leonard
Surfacing the SSIS Catalog
84(1)
SSIS Catalog Environment Configuration
85(1)
SSIS Catalog Project Configuration
85(2)
Catalog Browser
87(7)
Conclusion
94(1)
Chapter 7 SSIS Catalog Compare
95(28)
Why I Built SSIS Catalog Compare
95(1)
Andy Leonard
SSIS Catalog Compare
96(27)
Expanding the Differences
97(2)
Catalog Properties
99(2)
SSIS Catalog Compare Scripting
101(22)
Chapter 8 SSIS Framework Community Edition
123(8)
SSIS Framework Community Edition
124(7)
Help for SSIS Catalog Projects Already Deployed
125(1)
Viewing SSIS Catalog Reports
126(2)
Viewing SSIS Framework Community Edition Metadata
128(3)
Chapter 9 Catalog Reports
131(6)
Chapter 10 BimlExpress Metadata Framework
137(40)
Downloading and Installing BimlExpress
138(37)
Downloading BimlExpress Metadata Framework
142(4)
Following the README File Instructions
146(29)
Full Circle
175(2)
Chapter 11 Conclusion
177(2)
Appendix A Links 179
Erratum 1(180)
Index 181
Andy Leonard is Data Philosopher at Enterprise Data & Analytics, and SSIS trainer, consultant, and developer. He also is a Business Intelligence Markup Language (Biml) developer and BimlHero. Andy also is an SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The BIML Book (Apress), and SQL Server Integration Services Design Patterns (Apress).
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842327676e.html
Märksõnad: