Address solutions to data integration problems that cannot be handled by iSynergy out-of-the-box and learn techniques to enslave SQL to make it work how you need it to.

It empowers the attendees with tools to overcome system integration obstacles by introducing them to the following database manipulation technologies:

Microsoft Access
* Easy linking to ODBC data sources
* Simple programming interface
* Easily join multiple tables using Queries
* Create documents from data using Reports

Database Views
* Combining data from multiple tables
* Re-formatting data to match target layouts
* Simplifying lookups

SQL Server Jobs
* Batch file execution as well as database scripts
* Database backup maintenance plans
* Scheduling run times

SQL Server Integration Services (SSIS)
* Perform complex data transformations
* Execute multiple simultaneous operations
* Perform mass data Import/Export operations
* Generate flat file output

Database Triggers
* Leveraging Insert, Update, or Delete event based execution
* Execute SQL Scripts or stored procedures
* Execute SQL Server Jobs

This session is ideal for iSynergy Installers, Integration Specialists and Systems Administrators.

Presented by Campbell Fisher (Implementation Specialist)