Layer2 Cloud Connector User Documentation

Layer2 Cloud Connector User Documentation

15th September 2023 - Version 11.3

Layer 2 GmbH | Wendenstra?e 21b | D-20097 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Manager: Matthias Hupe Hamburg District Court: HRB 81259

Page 1/187

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................................................................................................. 20 Logging Basics ................................................................................................................... 23

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

Layer 2 GmbH | Wendenstra?e 21b | D-20097 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Manager: Matthias Hupe Hamburg District Court: HRB 81259

Page 2/187

Authentication .................................................................................................................. 34 Connections ...................................................................................................................... 34 History .............................................................................................................................. 34 License .............................................................................................................................. 34 Logs ................................................................................................................................... 34 Metabase .......................................................................................................................... 34 Metadata [Deprecated] .................................................................................................... 34 Sample Connections ......................................................................................................... 34 Sample Data...................................................................................................................... 35 Configuration .......................................................................................................................... 35 Connection Manager Global Settings ............................................................................... 35 Connection Definition....................................................................................................... 38 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.......................................................................................................................... 75 MMC.log ........................................................................................................................... 75 Scheduler.log .................................................................................................................... 76 System.log ........................................................................................................................ 76 NLog.config ....................................................................................................................... 76

Layer 2 GmbH | Wendenstra?e 21b | D-20097 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Manager: Matthias Hupe Hamburg District Court: HRB 81259

Page 3/187

Windows Event Log Configuration ................................................................................... 76 Email Alert Configuration ................................................................................................. 77 Service Management .............................................................................................................. 78 Backend Service ................................................................................................................ 78 Scheduling Service ............................................................................................................ 79 REST API .................................................................................................................................. 79 Configuration File ............................................................................................................. 79 PowerShell Samples for API usage ................................................................................... 80 Console Mode......................................................................................................................... 82 Registry Keys........................................................................................................................... 83 AutoBackupInterval .......................................................................................................... 83 ApiUrl ................................................................................................................................ 83 MMCLog_Directory .......................................................................................................... 83 MMCLog_ArchiveAboveSize............................................................................................. 83 MMCLog_MaxArchiveFiles ............................................................................................... 84 MemoryWatchdogThresholdInMb................................................................................... 84 MemoryWatchdogPollingIntervalInMilliseconds ............................................................. 84 ApiCalls_Timeout.............................................................................................................. 84 ApiCalls_MaxRetries ......................................................................................................... 84 ApiCalls_WaitBetweenRetries .......................................................................................... 84 Automatic Fields ..................................................................................................................... 84 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 ................................................................... 96 Layer2 Data Provider for Microsoft Flow and Logic Apps ................................................ 97 Layer2 Data Provider for Microsoft Teams Channel Webhook...................................... 109 Layer2 Data Provider for OData ..................................................................................... 113 Layer2 Data Provider for Office 365 Groups .................................................................. 123

Layer 2 GmbH | Wendenstra?e 21b | D-20097 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Manager: Matthias Hupe Hamburg District Court: HRB 81259

Page 4/187

Layer2 Data Provider for RSS .......................................................................................... 127 Layer2 Data Provider for SharePoint .............................................................................. 129 Layer2 Data Provider for SOAP Web Services ................................................................ 133 Layer2 Data Provider for XML ........................................................................................ 134 SQL-Like Select Statement .................................................................................................... 137 Synchronization of Binary Content ....................................................................................... 138 Local or Remote File System and Server File Shares ...................................................... 138 SharePoint and Teams Document Libraries ................................................................... 138 Microsoft SQL Binary Data.............................................................................................. 139 Other Provider Binary Data ............................................................................................ 139 Authentication ...................................................................................................................... 139 Authentication Sequence ............................................................................................... 140 Authentication Construction Kit ..................................................................................... 140 Authentication Methods ................................................................................................ 146 AutoRenaming ...................................................................................................................... 170 Escaping of File and Folder Names ................................................................................. 171 Shortening of File Names ............................................................................................... 175 Ensuring a Unique File Name.......................................................................................... 175 Logging............................................................................................................................ 175 Support ................................................................................................................................................ 175 Online FAQs .......................................................................................................................... 175 Common Scenarios ............................................................................................................... 175 Trial ....................................................................................................................................... 176 Ordering................................................................................................................................ 176 Upgrade ................................................................................................................................ 176 Migration .............................................................................................................................. 177 Part 1 - Installation and Configuration ........................................................................... 177 Part 2 - Migrating Connections....................................................................................... 177 Part 3 ? Validating the Connections ............................................................................... 178 Contact.................................................................................................................................. 178

Layer 2 GmbH | Wendenstra?e 21b | D-20097 Hamburg Tel.: +49 (40) 28 41 12 ? 30 | Fax: +49 (40) 28 41 12 ? 16 E-Mail: sales@ | Web: General Manager: Matthias Hupe Hamburg District Court: HRB 81259

Page 5/187

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

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

Google Online Preview   Download