Layer2 Cloud Connector User Documentation

Layer2 Cloud Connector User Documentation

06 of August 2021 - Version 9.5

Layer 2 GmbH | Eiffestra?e 664b | D-20537 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Managers: Wolfgang Cords, Matthias Hupe Hamburg District Court: HRB 81259

Page 1/190

Contents

Overview.................................................................................................................................................. 7 Getting Started ........................................................................................................................................ 7

System Requirements............................................................................................................... 7 Minimum Requirements..................................................................................................... 7 Supported Operating Systems............................................................................................ 7 Virtual Machines................................................................................................................. 8 Installing on SharePoint or Database Servers .................................................................... 8 Dependencies ..................................................................................................................... 8

Setup ......................................................................................................................................... 9 Configuring and Executing Connections........................................................................... 10 Schedule Synchronization................................................................................................. 19 Logging Basics ................................................................................................................... 22

Advanced User's Guide/Technical Information .................................................................................... 24 How the Layer2 Cloud Connector Works ............................................................................... 24 The Metabase ................................................................................................................... 24 Field-Mappings and Type-Conversions............................................................................. 25 Primary Keys ..................................................................................................................... 26 Data Providers .................................................................................................................. 26 Uni-directional Synchronization ....................................................................................... 27 Bi-directional Synchronization.......................................................................................... 28 Conflict Resolution............................................................................................................ 29 Cloud Connector Components ............................................................................................... 31 The Connection Manager ................................................................................................. 31 The Backend Windows Service ......................................................................................... 31 The Scheduling Windows Service ..................................................................................... 31 The Layer2 Providers ........................................................................................ 31 The Layer2 Cloud Connector as Console Application ....................................................... 32 The Cookie Manager [Deprecated] .................................................................................. 32 The Layer2 Cloud Connector Data Directory .......................................................................... 32

Layer 2 GmbH | Eiffestra?e 664b | D-20537 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Managers: Wolfgang Cords, Matthias Hupe Hamburg District Court: HRB 81259

Page 2/190

Authentication .................................................................................................................. 33 Connections ...................................................................................................................... 33 History .............................................................................................................................. 33 License .............................................................................................................................. 33 Logs ................................................................................................................................... 33 Metabase .......................................................................................................................... 33 Metadata [Deprecated] .................................................................................................... 33 Sample Connections ......................................................................................................... 33 Sample Data...................................................................................................................... 34 Configuration .......................................................................................................................... 34 Connection Manager Global Settings ............................................................................... 34 Connection Definition....................................................................................................... 37 Data Entity ........................................................................................................................ 41 Mapping............................................................................................................................ 48 Logs ................................................................................................................................... 49 Dynamic Columns ................................................................................................................... 51 Code Examples for Dynamic Columns .............................................................................. 55 Licensing ................................................................................................................................. 70 Installing a License ............................................................................................................ 70 Connection Definition Files..................................................................................................... 71 .................................................................................................................... 71 ................................................................................................................... 72 .......................................................................................................... 74 ............................................................................................................... 74 Logging and Alerting ............................................................................................................... 75 Server.log.......................................................................................................................... 76 MMC.log ........................................................................................................................... 76 Scheduler.log .................................................................................................................... 76 System.log ........................................................................................................................ 76 Nlog.config........................................................................................................................ 76

Layer 2 GmbH | Eiffestra?e 664b | D-20537 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Managers: Wolfgang Cords, Matthias Hupe Hamburg District Court: HRB 81259

Page 3/190

Windows Event Log Configuration ................................................................................... 76 Email Alert Configuration ................................................................................................. 77 Service Management .............................................................................................................. 78 Backend Service ................................................................................................................ 79 Scheduling Service ............................................................................................................ 79 REST API .................................................................................................................................. 80 Configuration File ............................................................................................................. 80 PowerShell Samples for API usage ................................................................................... 80 Console Mode......................................................................................................................... 82 Registry Keys........................................................................................................................... 83 AutoBackupInterval .......................................................................................................... 83 ApiUrl ................................................................................................................................ 83 MMCLog_Directory .......................................................................................................... 83 MMCLog_ArchiveAboveSize............................................................................................. 84 MMCLog_MaxArchiveFiles ............................................................................................... 84 MemoryWatchdogThresholdInMb................................................................................... 84 MemoryWatchdogPollingIntervalInMilliseconds ............................................................. 84 ApiCalls_Timeout.............................................................................................................. 84 ApiCalls_MaxRetries ......................................................................................................... 84 ApiCalls_WaitBetweenRetries .......................................................................................... 84 Automatic Fields ..................................................................................................................... 85 Layer2 Data Providers............................................................................................................. 85 Layer2 Data Provider for Exchange .................................................................................. 85 Layer2 Data Providers for File System, FTP and DropBox ................................................ 88 Layer2 Data Provider for GoogleDrive.............................................................................. 93 Layer2 Data Provider for Azure Blob Storage ................................................................... 97 Layer2 Data Provider for Microsoft Flow and Logic Apps ................................................ 98 Layer2 Data Provider for Microsoft Teams Channel Webhook...................................... 110 Layer2 Data Provider for OData ..................................................................................... 114 Layer2 Data Provider for Office 365 Fast File Sync......................................................... 120

Layer 2 GmbH | Eiffestra?e 664b | D-20537 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Managers: Wolfgang Cords, Matthias Hupe Hamburg District Court: HRB 81259

Page 4/190

Layer2 Data Provider for Office 365 Groups .................................................................. 124 Layer2 Data Provider for RSS .......................................................................................... 129 Layer2 Data Provider for SharePoint .............................................................................. 130 Layer2 Data Provider for SOAP Web Services ................................................................ 134 Layer2 Data Provider for XML ........................................................................................ 136 SQL-Like Select Statement .................................................................................................... 139 Synchronization of Binary Content ....................................................................................... 140 Local or Remote File System and Server File Shares ...................................................... 140 SharePoint and Teams Document Libraries ................................................................... 140 Microsoft SQL Binary Data.............................................................................................. 141 Other Provider Binary Data ............................................................................................ 141 Authentication ...................................................................................................................... 141 Authentication Sequence ............................................................................................... 142 Authentication Construction Kit ..................................................................................... 142 Authentication Methods ................................................................................................ 148 AutoRenaming ...................................................................................................................... 172 Escaping of File and Folder Names ................................................................................. 173 Shortening of File Names ............................................................................................... 176 Ensuring a Unique File Name.......................................................................................... 177 Logging............................................................................................................................ 177 Support ................................................................................................................................................ 177 Online FAQs .......................................................................................................................... 177 Common Scenarios ............................................................................................................... 177 Trial ....................................................................................................................................... 178 Ordering................................................................................................................................ 178 Software Assurance .............................................................................................................. 178 Upgrade ................................................................................................................................ 179 Migration .............................................................................................................................. 179 Part 1 - Installation and Configuration ........................................................................... 179 Part 2 - Migrating Connections....................................................................................... 179

Layer 2 GmbH | Eiffestra?e 664b | D-20537 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Managers: Wolfgang Cords, Matthias Hupe Hamburg District Court: HRB 81259

Page 5/190

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download