engage / belsoft collaboration - using ibm domino data in ibm connections – a real life story
TRANSCRIPT
UsingIBMDominoDatainIBMConnections–areallifestoryAndreas PonteBelsoftCollaborationAG
1#engageug
2#engageug
• System Integrators• IBM Domino/Notes• IBM Notes Traveler• IBM Sametime• IBM Connections
• Custom Development• Domino• XPages• Interfaces and Systemintegration
• Education for Administrators, Developers and Users• Member of Penumbra Group
Winnerof the IBMBusinessPartnerExcellenceAwardEurope2015
4#engageug
Aboutthespeaker
• Andreas Ponte about.me
• ~20 years in the Lotus/ICS world • Worked for a Reinsurance Company until 2007, amongst other
things responsible for the global communication infrastructure• Joined Belsoft AG, an IBM Premier Business Partner located
Switzerland, with focus on consulting in the IBM Domino and mobile solutions area
• Since 2014 CEO of Belsoft Collaboration AG and IBM Champion for 2015 and 2016
• Regularly speaking at own events and various user groups around the world
5#engageug
Aboutthe“doers”
Urs Meli• Development
(IBM Notes / XPages)• Infrastructure &
Administration(IBM Domino / IBM Connections)
Frédéric Dehédin• Development
(IBM Notes / XPages)• Business Processes• Data migration• Project lead
6#engageug
UsingIBMDominoDatainIBMConnections–areallifestory• We faced a challenge of bringing 50GB of data from
an IBM Notes database into IBM Connections andfrom a local usage to a large audience in and outsideof the company.
• I will talk about the starting point, the steps needed forthe file migration, the integration of an existing IBMNotes application in IBM Connections and how thesolution helps users from different companies to findand share information.
7#engageug
UsingIBMDominoDatainIBMConnections–areallifestoryThe challenge:
• Move 50GB of data from IBM Notes into IBM Connections
• From a local usage to a large audience in and outside of the company.
• Goal: replace the Extranet
8#engageug
Agenda
• The starting point• The steps needed for the file migration• The integration of existing IBM Notes
applications in IBM Connections• The result
9#engageug
Thestartingpoint
• Leed database• Library for Eurapco Electronic Documents• 50 GB / 15’000 documents (attachments) to be
moved to IBM Connections
10#engageug
Thechallengefortheupload
• „read“ information from current documentsand attachments in the database to:
• Add tags to the document• Sort by original creation date• Change the owner (Created by..)• Share with different communities
11#engageug
Migrationofdata
• Problems• Challenges• Solutions
12#engageug
Migrationofdata
• Problems• Missing functions in SBT
• Changing the owner• Setting a creation date
• Files• Duplicate file names• Mime Type not updated, i.e. no .doc
13#engageug
Migrationofdata
• Challenges• Migration of data
• 15’000 documents, 50 GB of data
• Network Bandwidth• Migration only during off-peak hours
• No freeze• Data changes during migration
14#engageug
Migrationofdata
• Solutions• Notes Agent
• Upload documents to IBM Connections• Based on information from Notes document
• Set tags• Copy document to according community
and folder• Based on information from attachment
• Set tags
15#engageug
Migrationofdata
• Solutions• Migration database to manage attachments
• Which attachments have been uploaded• Which attachments have been changed
• TDI/SDI • Change owner (created by..)
16#engageug
Migrationofdata
• Challenges afterwards• Offline functionality
• Users create events, agenda documents etc. on local/offline in Notes
• Once online, folders and files will be created or updated in Connections
17#engageug
TheResult
31.1.2015 1.11.2015 20.03.2016
Sizeof allfiles (including older versions) 38.5GB 47.8GB 50.2GB
Totalnumber of files 15‘785 17‘454 18‘095
Totalnumber of folders 2‘042 2‘163 2‘210
Number of tags 186 488 630
Number of times alltagshave beenapplied to files
92‘865 95’805 96’493
18#engageug
Total Events by ApplicationVisits by Applications
Analytics(today)
19#engageug
Events
Before:
After:
20#engageug
Events
• Attachments linked from originating database (LEED)• Integration of IBM Connections into XPages and vice
versa• XPages Application with the same look and feel as
IBM Connections • Embedded in IBM Connections• Attachments from a Notes database are displayed
in IBM Connections Files (from a corresponding community folder)
• Widget for IBM Connections displaying events of the logged in user and relevant community
21#engageug
Events
XPages App
Connections Files
22#engageug
EventsWidget
23#engageug
UserManagement
• We enhanced the login screen with a possibility to• Register as a user• Reset the login password
24#engageug
UserManagement– RegistrationPage
25#engageug
UserManagement– PasswordRecovery
26#engageug
Automatisation
• We used a combination of TDI/SDI and Jythonscripts to meet the customer’s requirements to:
• Automatically join a predefined community• Automatically follow a community once
joined (and keep it that way..)
27#engageug
Lessonslearnedfornewprojects
Although the Social Business Toolkit (SBT) is a great piece of software, we ended up connecting to the Connections API directly using the Apache Abdera Library
28#engageug
CRMintegrationtoIBMConnections
• Goals:• keep the Notes applications simple while not
adding 3rd party libraries• keep the main logic in 1 place (XPages Proxy)• keep the logic in the XPages scope in order to
make a future migration of the Notes applications to XPages painless
29#engageug
CRMintegrationtoIBMConnections
30#engageug
CRMintegrationtoIBMConnections
• Use Case:• Connect Domino data to Connections data• Using Connections features with existing Domino
Data• Handing over the collaboration aspects to
Connections (-> where they belong)
31#engageug
CRMintegrationtoIBMConnections
32#engageug
Getintouchwithus
Want to know more about data migration to IBM Connections? We can help with your customised data migration but also with your needs for standard or repeating data migration together with hs.Crawler by hedersoft
Questions?
Thankyouforyouattention