Integrate SharePoint Server 2007, Excel, and SQL Server Training
Design Your Own Course!
Select a checkbox next to each topic you require.
If you want to register for all topics, click here .
Click Submit at the bottom of the page when you're done.
Once we receive your request, we will contact you to discuss pricing, agenda, and scheduling details. If you have questions, please call us at 800-840-8050. Thank you for your interest in Workflow Ready.
Part 1: Work with Offline SQL Server Data in Excel
1.1 Prepare Excel for SharePoint/ SQL Server Integration
Calculations, data analysis and charting
Prerequisites
Laying out the worksheet
Hook up the event handlers
Add code to import data
Synchronizing changes with the server
Running code before closing the workbook
Part 2: Publish the Excel Sheet to a SharePoint Library
2.1 Benefits of SharePoint Lists
SharePoint list features- library and item-level alerts, workflows, RSS feeds, fine-grained permissions control, version hiustory, more
Multiple list views and personalization
Connections between lists
Concurrent user access governed by checkin/checkout
2.2 Export an Excel Table to a SharePoint List
Use a SharePoint list to share table data
Create a table
Export a table to a SharePoint list
Update table data from a SharePoint list
Unlink an Excel table from a SharePoint list
2.3 Publish and Synchronize Excel Tables to SharePoint Lists
Update SharePoint Lists in Excel 2007
Install the Excel 2007 SharePoint List Synchronizing Add-In
Publish and Synchronize Table Data to a SharePoint Site
Part 3: Publish the Excel Sheet to SharePoint Excel Services
3.1 Differences Between Use a Workbook in Excel and Excel Services
Supported and unsupported features when loading a workbook
Supported and unsupported worksheet functions
Supported and unsupported features when viewing a workbook
Supported and unsupported features when interacting with a workbook
3.2 Trusted locations for Calculation Services
Trusted file locations
Trusted data providers
Trusted data connection libraries
3.3 Work with Excel Services for Collaboration
Use the Excel Web Access Web Part
Excel Services and Information Rights Management
Connect to data in a secure way
Publish a workbook to Excel Services
Define what you want other users to see
Set parameters to allow interactive analysis
3.4 Interact with an Excel Workbook in Excel Services
Recalculate data in the workbook
Refresh live data from an external data source
Navigate to different worksheets, worksheet parts, named items - charts or Excel tables
Sort and filter data
Expand or collapse levels of data in a PivotTable report
Enter parameters to update the results of formulas or do simple what-if analysis
Select data from connected Web Parts – Filters/List View Web Parts, dashboards, other Web Part Pages
Part 4: Synchornizing Data with SQL Server
4.1 Import Excel Data into SQL Server Tables Use SqlBulkCopy
Create Packages Use the SQL Server Import and Export Wizard
4.2 Import Data from Excel SQL Server
Requirements: Import data from Excel & SQL Server
Samples: Import data from Excel & SQL Server
Use DTS or SSIS
Use a Linked Server
Use Distributed Queries
Use ADO and SQLOLEDB
Use ADO and the Jet Provider
Troubleshoot import data from Excel & SQL Server
4.3 Import Data from SQL Server into Excel
Requirements: Import data from SQL Server to Excel
Samples: Import data from SQL Server to Excel
Referencing the ADO object library
Create the connection
Extracting the data
Verifying that the code works
Troubleshoot import data SQL Server to Excel
Part 5: Integrate Excel with SQL Server Integration Services (SSIS)
5.1 Connect to Excel in SQL Server Integration Services (SSIS)
Excel Connection Manager
Excel Source and Destination
5.2 SQL Server 2005/2008 Reporting Services Integration with SharePoint 2007
SharePoint 2007 Integration Features and Benefits
Integration with Report Center
Select the right mode
SharePoint Integration Mode
Installation components and setup
Report Server configuration
SharePoint Server configuration
Create reports
Developers
End-Users
View reports
Manage reports
Part 6: Additional Topics
Please list any additional SharePoint topics you would like to cover.
Please fill out this form to register for the class. Click Submit when you're done. Once we receive your request, we will contact you to discuss agenda and scheduling details. If you have questions, please call us at 800-840-8050.
Full Name:
Email:
Address:
Phone:
City:
Organization:
Choose either State or Province.
State:
Zip/Postal Code:
Province:
Job Title:
No. Students:
Month:
Date:
To learn more about the Workflow Ready difference, please contact
a Workflow Ready representative at 800-840-8050. You may also request information online.
