# OneDrive The Microsoft OneDrive cloud storage service lets you store, share, and synchronize files and folders across multiple devices. OvalEdge uses an API to connect to the data source, that allows you to crawl Files and Folder data objects.
#### Connector Capabilities | Functionality | Description | | ------------- | --------------------------------------------------------------------------------------------------------------------------------- | | Crawler | While crawling, root Folders or Files will be cataloged by default. The cataloging is performed only for the 1st level of Folders | ## Prerequisites The following are the prerequisites required for establishing a connection between the connector and the OvalEdge application. 1. API details 2. Service Account permissions. 3. Configure environment variables (Optional). ### API Details | APIs | Version | Details | | ------------------ | ------- | ----------------------------------------------------------------------------------------------------------------------------------------------- | | OneDrive Graph API | V1 | | ### Service Account with minimum read Permission By default, the service account provided for the connector will be used for any user operations. If the service account has write privileges, then Insert / Update / Delete operations can be executed. | Operations | Description | | --------------------- | ------------------------------------------------------------------- | | Connection Validation | Read Permissions on the Folders or Files that need to be cataloged. | | Crawler | Read Permissions on the Folders or Files that need to be cataloged. | ### Establish Environment Variables (Optional) This section describes the settings or instructions that you should be aware of prior to establishing a connection. If your environments have been configured, skip this step. Configure Environment Names The Environment Names allow you to select the environment configured for the specific connector from the dropdown list in the Add Connector pop-up window.\ You might want to consider crawling the same schema in both stage and production environments for consistency. The typical environments for crawling are PROD, STG, or Temporary, and may also include QA or other environments. Additionally, crawling a temporary environment can be useful for schema comparisons, which can later be deleted, especially during application upgrade assistance. Steps to configure the Environment on OvalEdge: 1. Navigate to Administration | Configuration 2. Select the Connector tab 3. Find the Key name “connector.environment”. 4. Enter the desired environment values (PROD, STG) in the value column. 5. Click ✔ to save. ## Establish a connection To establish the connection, complete the following steps: 1. Log into the OvalEdge application. 2. In the left menu, navigate to the Administration module, and click on Connectors. 3. Click on the + icon (New Connector), then the Add Connector pop-up is displayed. 4. Search/Click on the desired connector and the Add Connector pop-up with the connector details is displayed. | Fields | Details | | | -------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------- | | Connection Type\* |

The selected connection type ‘OneDrive’ is displayed by default.

If required, the dropdown menu allows you to change the connector type and based on the selection of the connection type, the fields associated with the selected connection type are displayed.

| | | License Add-Ons\* |

All the connectors will have a Base Connector License by default that allows you to crawl and profile to obtain the metadata and statistical information from a datasource.

OvalEdge supports various License Add-Ons based on the connector’s functionality requirements.

| | | Connector Environment |

The OvalEdge Environment dropdown menu is used to select the operating system on which the OvalEdge application is installed, such as Windows, Linux, and Unix.

For example, OvalEdge is installed on a Windows environment.

| | | Connection Name\* |

Enter a connection name for the OneDrive. You can specify a reference name to identify the OneDrive connector in OvalEdge.

Example: one-drive

| | | Client Secret\* | A secret key is known only to the application authorization server created. It is generated after the app is registered in OneDrive | | | Client ID\* | Identifier ID generated after the app is registered in OneDrive | | | Tenant Id\* | Enter Tenant ID (Tenant ID is a globally unique identifier (GUID) that is different from your organization name or domain.) It is generated after the app is registered in OneDrive. | | | User ID\* | Enter the User ID of the OneDrive workspace. | | | Connection String | Set the Connection string toggle button to auto mode to get the details automatically from the credentials provided. Alternatively, you can manually enter the string. | | | Default Governance Roles\* |

You can select a specific user or a team from the governance roles (Steward, Custodian, Owner) that get assigned for managing the data asset.

Note: The dropdown list displays all the configurable roles (single user or a team) as per the configurations made in the OvalEdge Security | Governance Roles section.

| | Admin Roles |

Select the required admin roles for this connector.

| | | Select Bridge |

To enable OvalEdge to function as a SaaS application behind a customer's firewall, the OvalEdge Bridge is necessary.

For more information, refer to Bridge Overview

| | 5\. Click on the Validate button to validate the connection details. 6\. Click on the Save button to save the connection. Alternatively, you can also directly click on the button that displays the Connection Settings pop-up window to configure the settings for the selected Connector. The Save & Configure button is displayed only for the Connectors for which the settings configuration is required. Note: \* (asterisk) indicates the mandatory field required to establish a connection. Once all the parameters are entered, you can validate the details and save the connection that will get displayed on the Connector Home page. Note: It is up to your wish, you can save the connection details first, or you can validate the connection first and then save it. #### Connection Validation Errors | Sl.No | Error Message(s) | Description | | ----- | --------------------- | --------------------------------------------------------- | | 1 | Permission Denied | If credentials are not valid, you get this error message. | | 2 | Internal Server Error | It will respond with a 500 Internal Server Error. | ➤ If you have any issues creating a connection, please contact your assigned OvalEdge Customer Success Management (CSM) team. ## Connector Settings Once the connection is established successfully, various settings are provided to fetch and analyze the information from the data source. | Connection Settings | Description | | ------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Crawler |

Crawler settings allow you to set the crawling configuration that will collect the metadata and display it in the data catalog.

Crawler Settings include

(i) Crawler Options:

(ii) Crawler Rules: Defining Crawler Rules enables you to filter the crawl through Regular Expression (Regex) that defines schema, table and views, columns, procedures, and functions to include and exclude.

| | Access Instruction | It allows the data owner to instruct others on using the objects in the application. | | Business Glossary | It allows users to manage the data association of terms related to a particular connector associated with it. The business glossary setting works based on the order of options defined for each business glossary’s managed data association. | For more information, refer to the [Connector Settings](https://support.ovaledge.com/connector-settings). #### To Catalog Files/Folders For cataloging Files and Folders of OneDrive connector, click the Crawl/Profile button to submit a job that will display a message of “Catalog Files/Folders Job submitted successfully”. You can navigate to the Job log to view the status of the job. ## Additional Information 1\. Files tab > Nine-Dots option > Open in Native/Remote tab will open OneDrive supported file types. 2\. Displays only the details of files and folders that the user has access to in the FileManager