Transcript Fusion in Omahax

Steen Jakobsen
Fusion Principal Architect
[email protected]
Ontolica Fusion 4.0
The easy Automation Tool for SharePoint
This Session
What is Ontolica Fusion?
Easy Automation Tool for SharePoint
• Conditionally Replicate/Migrate Files at high speed!
•
Document Library metadata update.
•
Data integration: Create/Update/Delete List items or rows in db table.
•
Use data from Excel, CSV, Databases or other SharePoint Lists
•
Site Provisioning: Office Dev. PnP Provisioning Engine. (streamline sites)
1.
100% client-side. Installs in 5 min. No SharePoint Admin needed.
2.
No coding required, optional SQL and PowerShell. Simple Excel style calculations.
3.
Highly visual with action preview and test runs. Full audit and monitoring.
4.
Jobs are saved as reusable parameterized Automation Components.
5.
Run jobs interactively or on Built-in Batch Server. (Windows Application/Service)
Conditionally Replicate/Migrate Files at high speed!
The difference is - easy Automation
•
Copy FileShares TO SharePoint (with folders or flattened)
•
Copy files BETWEEN different SharePoint sites. (07,10,13,16,365)
•
Copy files FROM SharePoint to FileShare. (use metadata as folder)
•
Use dynamically calculated target Sites or FileShares. (for each file/folder)
•
Visually step-by-step or as Batch Job with real time monitoring.
•
Keep multiple locations in sync.
•
“Test run” with reporting/impact analysis.
•
Incremental based on timestamp or custom condition.
•
Client side filters & Server side encapsulated CAML filters.
•
Delete operations. (older than 3 months; if exist on other site; …)
Document Library metadata update
• Use Excel-style calculations.
• Lookup and calculate metadata for each file during copy.
• Post update metadata without changing Modified & ModifiedBy.
• Resolve Managed Metadata tags via label.
Use data from CSV, Excel Tables and Sheets, Databases or even
same/other SharePoint Lists.
List Items - Data integration
The difference is - easy Automation
• Create/Update/Delete List items.
• Filters for selecting Items to Delete/Update. (encapsulated CAML)
• Same technique works against rows in database tables.
Use data from CSV, Excel Tables and Sheets, Databases or even
same/other SharePoint Lists.
Office Dev. - PnP Provisioning Engine
Create or Streamline sites - easy Automation
1. Extract artifacts like Homepage, Lists, Security settings, etc. to a xml file.
2. (Optionally edit the template and insert Fusion Parameters.)
3. Apply the template to a selection of target Sites.
No coding required, optional PowerShell support.
Site Provisioning with Fusion.
easy Automation
•
Dynamically create Site when a target site does not exist.
•
Trigger Site creation by monitoring FileShare, SharePoint List or Database table.
•
Use dynamically calculated target URL/UNC. (for each file/folder)
•
Iterate conditionally over site collection and perform Site artifacts provisioning
(PnP Provisioning Engine)
•
Delete sites and subsites. (conditionally)
Connectivity - SQL & PowerShell
• Use SQL to retrieve/update data in almost any data source.
• Invoke “Automation Components” from PowerShell.
• Run PowerShell before/after Component or for each
Item/Document/Row.
Workflow, Repository and Looping
easy Automation
•
Multiple Components can be grouped to form conditional Workflows.
•
Jobs run interactively or scheduled on the built-in Batch Server.
•
For-Each Loop over data set from CSV, Excel, Database or SharePoint List –
and Invoke Automation Component.
•
Use internal repository database for data staging/consolidation from
multiple data sources.
•
Component Definitions and Job Audit is stored in database repository,
hence no text log-files spread around the computer.
easy Automation for SharePoint
When data is on the move.
Interested ? .. Free Workshop tomorrow 9am at the Element Hotel.
or Monday, Tuesday at your premises.
Text/Call: +45 5318 1810 or e-mail: [email protected]
Get your free license to Fusion at workshop or sent to you later.
Thank you Sponsors!
Use #SPSOmaha in your tweets to thank them!