2023:OneDrive (CMIS Binding)

This article is about an older version of Grooper. Information may be out of date and UI elements may have changed.
2025	2023	2.72

OneDrive is a connection option for cloud CMIS Connections. It connects Grooper to Microsoft OneDrive cloud services for import and export operations.

It provides access to OneDrive Personal or OneDrive for Business drives and SharePoint Online or SharePoint Server 2016 document libraries. More or less, all you have to do is sync Grooper and OneDrive by logging in using your OneDrive credentials and you can import from and export to your OneDrive folders. OneDrive drives and SharePoint libraries can be individually imported as a CMIS Repository. Each will expose themselves as hierarchical file system (HFS), where folders and files are represented by simple object types. As such, this binding is suitable for Unmapped rather than Mapped Export. You can still export metadata as a "buddy file" adjusting the Metadata Export property in the Unmapped Export Settings.

Glossary

CMIS Connection Type:

CMIS Connection: cloud CMIS Connections provide a standardized way of connecting to various content management systems (CMS). CMIS Connections allow Grooper to communicate with multiple external storage platforms, enabling access to documents and document metadata that reside outside of Grooper's immediate environment.

• For those that support the CMIS standard, the CMIS Connection connects to the CMS using the CMIS standard.
• For those that do not, the CMIS Connection normalizes connection and transfer protocol as if they were a CMIS platform.

CMIS Export: CMIS Export is an Export Definition available when configuring an Export Behavior. It exports content over a cloud CMIS Connection, allowing users to export documents and their metadata to various on-premise and cloud-based storage platforms.

CMIS Import: CMIS Import refers to two Import Providers used to import content from settings_system_daydream CMIS Repositories: Import Descendants and Import Query Results. CMIS Imports allow users to import from various on-premise and cloud based storage platforms (including Windows folders, Outlook inboxes, Box accounts, AppEnhancer applications and more).

CMIS Query: A CMISQL Query (aka CMIS Query) is Grooper's way of searching for documents in CMIS Repositories. Commonly, CMISQL Queries are used by Import Query Results to import documents from a CMIS Repository. CMISQL Queries are also used by CMIS Lookup to lookup data from a CMIS Repository. CMISQL Queries are based on a subset of the SQL-92 syntax for querying databases, with some specialized extensions added to support querying CMIS sources.

• CMISQL Queries are configured using the "CMIS Query" property found in "Import Query Results" and "CMIS Lookup".

CMIS: CMIS (Content Management Interoperability Services) is open standard allowing different content management systems to "interoperate", sharing files, folders and their metadata as well as programmatic control of the platform over the internet.

Export: output Export is an Activity that transfers documents and extracted information to external file systems and content management systems, completing the data processing workflow.

OneDrive: OneDrive is a connection option for cloud CMIS Connections. It connects Grooper to Microsoft OneDrive cloud services for import and export operations.

Repository: A "repository" is a general term in computer science referring to where files and/or data is stored and managed. In Grooper, the term "repository" may refer to:

• PRIMARILY a Grooper Repository. This is most commonly what people are referring to when they simply say "repository".
• Less commonly a CMIS Repository

Service: Grooper Services are various executable programs that run as a Windows Service to facilitate Grooper processing. Service instances are installed, configured, started and stopped using Grooper Command Console (or in older Grooper versions, Grooper Config).

SharePoint: SharePoint is a connection option for cloud CMIS Connections. It Grooper to Microsoft SharePoint, providing access to content stored in "document libraries" and "picture libraries" for import and export operations.

Version Differences

When the OneDrive binding was added in version 2.72, it did not support full text querying. Full text searching is now possible as of Grooper version 2023.

• Use the CONTAINS() predicate in a CMIS Query to search document content in a One Drive repository based on a search string.

How To: Create a New Microsoft OneDrive Connection

Step 1Step 2Step 3Step 4

Expand the "Infrastructure" node.  Right click the "CMIS Connections" folder.  Mouse over "Add" and select "CMIS Connection...".

In the "Connection Properties" panel, select "OneDrive" from the "Connection Type" drop down list. Expand the "Connection Settings" heading and the "Login" heading under that.  Select "Authentication" and press the ellipsis button at the end of the line.

Log in using credentials with a Microsoft account.

After you "Save", press the "List Repositories" button to show the folder paths you just added as repositories.

See Also

For more information to use your CMIS Connection once its created, see the following articles:

• CMIS Export
• CMIS Import