Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Mark Beckner
Using Scribe Insight: Developing Integrations and Migrations using the Scribe Insight Platform
Cover
Title
Copyright
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Foreword
Introduction
Chapter 1: Installation and Configuration
Running the Scribe Installer
Insight Server vs. Insight Workstation
MSMQ
Database Setup
Licensing
Configuring a Site in the Scribe Console
Accessing Scribe Remotely
Conclusion
Chapter 2: Building and Testing Packages with the Workbench
Creating a New DTS
Connections
Configuring Source and Targets
Configure a Source
Basic Mapping
Testing Your DTS File
Running Your DTS File
Conclusion
Chapter 3: Basic Data Mapping Techniques
Variables
Database Lookups
Concatenation
Database Lookups Using Concatenations
Logic with the IF Statement
Configuring Steps
Conclusion
Chapter 4: Advanced Development Techniques
Premapping Data
Approach One: Using Logic Within a Variable
Approach Two: Premapping within SQL
Premapping Non-SQL Server Source Data
Staging Tables and Custom Stored Procedures
Advanced Step Configurations
Using Bulk Mode
Perform Update/Delete Operation
Using a Pre-Operation Step Flow Control
Skip if Blank
Only Update if Changed
Linking Multiple DTS Files
The DTS Report
Conclusion
Deploying and Scheduling Packages
Collaborations
Deploying and Scheduling a DTS Package
Process Management
Pausing and Resuming Processes
Manually Running a Process
Deleting a Process
Sleep Periods
Deploying a DTS That Subscribes to the Queue
Deploying a Set of Linked DTS Files
Conclusion
Adapters, Publishers, and Queues
Adapters
The Adapter for Microsoft Dynamics CRM
Pre-Executing SQL within an Adapter Connection
Publishers
Queues
Conclusion
Performance and Optimization of Solutions
Multithreading
Local Lookups
Considerations with Adapter Operations
Update/Insert Operation vs. Update and Insert Operations
One-Time Loads
Limiting the Number of Records to Process
Conclusion
Troubleshooting and Monitoring
Stand-Alone DTS Packages
Scheduled DTS Packages (Integrations)
Tools for Troubleshooting
The Queue Browser
The Execution Log
The Alert Log
Data Views
Monitors
Alert Recipients
Conclusion
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Next
Next Chapter
Contents at a Glance
To Ciro and Iyer Blue
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset