HackMD
  • Prime
    Prime  Full-text search on all paid plans
    Search anywhere and reach everything in a Workspace with Prime plan.
    Got it
      • Create new note
      • Create a note from template
    • Prime  Full-text search on all paid plans
      Prime  Full-text search on all paid plans
      Search anywhere and reach everything in a Workspace with Prime plan.
      Got it
      • Sharing Link copied
      • /edit
      • View mode
        • Edit mode
        • View mode
        • Book mode
        • Slide mode
        Edit mode View mode Book mode Slide mode
      • Note Permission
      • Read
        • Only me
        • Signed-in users
        • Everyone
        Only me Signed-in users Everyone
      • Write
        • Only me
        • Signed-in users
        • Everyone
        Only me Signed-in users Everyone
      • More (Comment, Invitee)
      • Publishing
        Everyone on the web can find and read all notes of this public team.
        After the note is published, everyone on the web can find and read this note.
        See all published notes on profile page.
      • Commenting Enable
        Disabled Forbidden Owners Signed-in users Everyone
      • Permission
        • Forbidden
        • Owners
        • Signed-in users
        • Everyone
      • Invitee
      • No invitee
      • Options
      • Versions and GitHub Sync
      • Transfer ownership
      • Delete this note
      • Template
      • Save as template
      • Insert from template
      • Export
      • Dropbox
      • Google Drive
      • Gist
      • Import
      • Dropbox
      • Google Drive
      • Gist
      • Clipboard
      • Download
      • Markdown
      • HTML
      • Raw HTML
    Menu Sharing Create Help
    Create Create new note Create a note from template
    Menu
    Options
    Versions and GitHub Sync Transfer ownership Delete this note
    Export
    Dropbox Google Drive Gist
    Import
    Dropbox Google Drive Gist Clipboard
    Download
    Markdown HTML Raw HTML
    Back
    Sharing
    Sharing Link copied
    /edit
    View mode
    • Edit mode
    • View mode
    • Book mode
    • Slide mode
    Edit mode View mode Book mode Slide mode
    Note Permission
    Read
    Only me
    • Only me
    • Signed-in users
    • Everyone
    Only me Signed-in users Everyone
    Write
    Only me
    • Only me
    • Signed-in users
    • Everyone
    Only me Signed-in users Everyone
    More (Comment, Invitee)
    Publishing
    Everyone on the web can find and read all notes of this public team.
    After the note is published, everyone on the web can find and read this note.
    See all published notes on profile page.
    More (Comment, Invitee)
    Commenting Enable
    Disabled Forbidden Owners Signed-in users Everyone
    Permission
    Owners
    • Forbidden
    • Owners
    • Signed-in users
    • Everyone
    Invitee
    No invitee
       owned this note    owned this note      
    Published Linked with GitHub
    Like BookmarkBookmarked
    Subscribed
    • Any changes
      Be notified of any changes
    • Mention me
      Be notified of mention me
    • Unsubscribe
    Subscribe
    ## Introduction The world is rapidly progressing in digital transformation. Information sharing between systems has become essential for operational efficiency and productivity improvement. Delay in data availability slows down business processes and decision-making. Integrating Salesforce with OneDrive allows you to easily monitor these aspects while making document sharing, updating, and management much more straightforward. Users can view, edit, or share documents using a single platform, securely enabling direct and swift collaboration. In this article, you can learn about OneDrive Salesforce Integration and how to achieve it using simple steps. Ways to integrate include: * Native Salesforce Files Connect framework. * Third-party tools for integration. > Integrating Microsoft OneDrive and Salesforce requires one to have the OneDrive for Business version. Using Skyvia, OneDrive for Business is unnecessary, as Skyvia supports all the versions. OneDrive for Business Salesforce Integration is quite popular among organizations. The Integration allows you to quickly arrange your files, folders, and content in Microsoft OneDrive with automated workflows. You can sync contact data, manage deal flow and automate your sales pipeline in Salesforce, making them easy to find and improving your productivity. OneDrive Salesforce Integration uses the recently released Salesforce Files Connect technology to connect OneDrive Cloud Storage to Salesforce CRM, which lets you access files from your CRM dashboard. ## Key features of Salesforce: What is Salesforce? Salesforce can display the visual of an entire sales pipeline into a single intuitive and insightful Dashboard. You can track various aspects of your sales pipeline, from customer activity to conversion rates. Besides that, your teams can also build customized reports and data visualizations to view drill-down data or snapshot views. Multiple departments can work with a single view of the customer worldwide and on any device. Here are some of the excellent plus points about Salesforce. * **Lead Management:** Salesforce helps you track all relevant information about your leads. The most recent contact information is visible and accessible via the detailed activity chronology. Using Sales Path helps to comprehend best practices. * **Account and contact management:** With customer contact management, you can quickly and easily access vital customer data such as key contacts, communication history, and more. * **Process Automation:** Process Builder automates business procedures with a simple point-and-click interface. You may set up automated email notifications for transactions of a specific size and auto-assign responsibilities as a deal progresses through the phases. * **Files Sync:** Salesforce manages and publishes the most accurate product specs, eliminating mistakes in the sales cycle. With Salesforce sync, you can put your files, content, and customer information in one place. ## Key features of OneDrive for Business: What is OneDrive? OneDrive is a private cloud storage service where you can save your files safely and access them from any device. With OneDrive personal, you can share your files with friends and family and sync and store them in one place. OneDrive for business, on the other hand, is a part of Office 365. It lets an organization give staff members their storage space, which you can use to manage, store and share your work files from one place. Some of the best things about OneDrive for business are listed below. * **Anywhere access:** With Microsoft 365, including Microsoft Teams, you can quickly save, access, and find private and shared business files from any device. * **Seamless collaboration: Work** faster and wiser with people inside and outside your company using Word, Excel, and PowerPoint. * **Controls for security:** Use OneDrive to save and protect your files. Administrators can change security settings to help keep your information safe, and getting your data back is easy after some attack or deletion by accident. ## How to connect Salesforce to OneDrive using Native tools? OneDrive integration with Salesforce can happen using native tools. Below are the steps to sync OneDrive and Salesforce with the Salesforce Files Connect function. ### Enable Files Connect in Salesforce: Click **Gear Icon** and navigate to the setup page. ![](https://i.imgur.com/43wtACu.png) In the **Quick Find Box** of your Salesforce CRM Setup page, type "Files Connect." Select **Files Connect**. Here in the “Edit” section, you will find specific options. * **Enable Files Connect:** To access remote content repositories from within Chatter. * **File Sharing:** Specifies how files get stored in external repositories, such as SharePoint. * **Use External object search layout:** Provides a search interface similar to the one used for custom objects. * **Enable Links conversion:** Allows external document URLs to get converted to file references posted in the feed. Click **Edit**, and select **Enable Files Connect** for File Sharing. ![](https://i.imgur.com/B7BtquT.png) ### Creating an Authentication Provider: To use Microsofts Cloud-based External Data Sources, like OneDrive for Business, you must first build an Authentication Provider in Salesforce and then register that provider in an Office 365 Application. Under the **Identity category** of your Salesforce **Setup**, you can find the Auth. Providers section. To add Microsoft Service, click the **New** button under this tab. ![](https://i.imgur.com/OLBFASa.png) Select **Microsoft Access Control Service** under the tab for the provider. Here, youll see the following fields: **Name:** You can put your name as you want it to appear in Salesforce. **URL Suffix**: This is where you can add a word or phrase to the end of the URL path. By default, the suffix is the same as the entry for the Name. **Consumer Key:** This is where you can enter a placeholder value. **Consumer Secret:** Where you can put a placeholder value. **Authorize Endpoint URL:** This is where you can put a blank that starts with HTTPS. **Token Endpoint URL:** This is where you can put a blank that starts with HTTPS. **Default Scopes:** Optional or leave blank. ![](https://i.imgur.com/ZqjbT19.png) Save your Call-back URL Entry by copying it. Click the **Save** button thats available at the bottom of the Auth. Provider Page when done. ### How to register an Office 365 app: **Sign in as an Administrator** to your Office 365 account and go to the following URL: [https://*xyzenterprise*-my.sharepoint.com/layouts/15/appregnew.aspx](https://*xyzenterprise*-my.sharepoint.com/layouts/15/appregnew.aspx) where _xyzenterprise_ is the name of your company. Here, youll have to choose from the following options. **Client Id:** Click "Generate" and copy the result to a text file. **Client Secret:** Click "Generate," then copy the value into a text file. **Title:** Here is where you can give the App a name. **App Domain:** Type in the name of your Salesforce Orgs domain here. **Redirect URL:** Paste the Callback URL you copied when setting up the Authentication Provider in Salesforce. After completing setting the options, click "Create." Now go to the following URL [https://my.sharepoint.com/*xyzenterprise*/layouts/15/appinv.aspx ](https://my.sharepoint.com/*xyzenterprise*/layouts/15/appinv.aspx) Set the following options once more: **App Id:** Enter the Client Id you got in the last step, and click Lookup. **Title:** Keep the default value. **App Domain:** Use the default value. **Redirect URL:** Use the default value. **Permission Request XML:** Here, enter a string that looks like this: <AppPermissionRequests> <AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="[PLACEHOLDER]"/> <AppPermissionRequest Scope="http://sharepoint/social/tenant" Right="Read"/> </AppPermissionRequests> Replace the [PLACEHOLDER] with one of these values: * Read * Write * Manage * FullControl How to add an authentication provider in Salesforce: Under the same Salesforce Auth. Providers tab, click on Edit next to the Authentication Provider you already made and change the following fields: ![](https://i.imgur.com/OhkWaLk.png) **Consumer Key:** Type in the Client ID you got in the last step. **Client Secret:** Type in the Client Secret you got from the steps before. **Authorize Endpoint URL:** Type in the URL of the Office 365 OAuthAuthorize.aspx page. Heres how the URL looks: [https://*xyzenterprise*-my.sharepoint.com/_layouts/15/OauthAuthorize.aspx](https://*xyzenterprise*-my.sharepoint.com/_layouts/15/OauthAuthorize.aspx) **Token Endpoint URL:** Here, input the URL in the following format: [https://accounts.accesscontrol.windows.net/*xyzenterprice*.onmicrosoft.com/tokens/OAuth/2?resource=00000003-0000-0ff1-ce00-000000000000/*xyzeterprise*-my.sharepoint.com@*xyzenterprise*.onmicrosoft.com](https://accounts.accesscontrol.windows.net/*xyzenterprice*.onmicrosoft.com/tokens/OAuth/2?resource=00000003-0000-0ff1-ce00-000000000000/*xyzeterprise*-my.sharepoint.com@*xyzenterprise*.onmicrosoft.com) Click **Save** when finished. The Authentication Provider is now ready for use. Now that your Salesforce CRM is set up, you can use the power of OneDrive Salesforce Integration by using the Salesforce CRM to access all the information on OneDrive. ### Pros and Cons of Integration using Native tools for Salesforce Onedrive integration The native ‘Salesforce Files Connect extension’ integration with OneDrive for Business is a popular option. **Pros include:** * Being a native tool, the Salesforce Filesconect is free with most Salesforce versions. * Your technical team can set up the integration quickly and saves time. * There is extensive documentation available on Salesforce Filesconnect. **Cons** * Challenges with the native approach can be overcome if you have tech-savvy resources to use the interface of Salesforce and OneDrive. * You can have limitations with using third-party data and specific data types too. # Code-Free Data Integration Salesforce to OneDrive with Skyvia Unlike Salesforce files connect, [Skyvia](https://skyvia.com/) reads CSV files and performs ETL (Extract, Transform, Load) operations with data stored in these files. Skyvia can also process Salesforce data and export this data to generated CSV files and place these files to OneDrive and other supported storages. Skyvia supports both OneDrive personal and OneDrive for business Salesforce integration. With Skyvia you can regularly exchange files between Salesforce and OneDrive and you can include other services into this process to load files from these services to Salesforce using OneDrive. Skyvia allows to enrich Salesforce data with CSV files data. We will describe how to sync OneDrive and Salesforce in both directions using [Skyvia Salesforce dataloader](https://skyvia.com/solutions/salesforce-solutions). To integrate OneDrive with Salesforce you need to have Skyvia account [registered](https://app.skyvia.com/register) and connections to [OneDrive](https://docs.skyvia.com/connectors/file-storages/onedrive_connections.html) and [Salesforce](https://docs.skyvia.com/connectors/cloud-sources/salesforce_connections.html) created. Use the above links to obtain information on how to connect to Salesforce and OneDrive. To import CSV file from OneDrive using Salesforce data loader, perform the following actions: 1. **Sign in with Skyvia** and create a new **Import package**. 2. Click the **CSV from storage device**. 3. Select OneDrive as a **Source** connection and Salesforce as a **Target** connection. ![](https://i.imgur.com/hi8ZnVF.png) 4. Optionally select the package options. You can specify the **Batch Size** if needed and make the package perform tasks by specific order in case of more than one package tasks are created. 5. Create the package task: * Click **Add new** on the top right of Skyvia page. * Select the source file on the **Source Definition** tab and adjust the [CSV options](https://docs.skyvia.com/working-with-csv.html) if needed. * Select the target table on the **Target definition** table. * Map the fields and save the task. You can transform source data with any available [**mapping**](https://docs.skyvia.com/data-integration/common-package-features/mapping/) type. ![](https://i.imgur.com/tA3nIzJ.gif) 6. When the mapping is completed, save the package and run it. 7. You can check the package results on the Monitor and Log tabs of the package. ![](https://i.imgur.com/GnTFLDU.png) To connect Salesforce with OneDrive in the opposite direction Skyvia offers the [Export](https://docs.skyvia.com/data-integration/export/) solution. Skyvia queries the content of the needed Salesforce table, generates the CSV file and places it to the OneDrive folder. To integrate Salesforce with Onedrive, perform the following actions: 1. **Sign in with Skyvia** and create a new **Export package**. 2. Select your Salesforce connection as a Source. 3. Click on the **CSV to storage service** Target type. 4. Select your OneDrive connection as a Target. 5. Choose the folder where the future CSV file has to be placed. 6. Enable the other available package and file options. ![](https://i.imgur.com/M52497A.png) 7. Create the export task. Click **Add new**, same as was described above, and do the following: * On the source definition tab select the **task mode**. Advanced is more relevant for complex custom commands or salesforce reports export. We will just export the record from the table without complicated transformations, thus we select the **Simple** task mode. * Select the source Salesforce table and needed fields. Add filtering conditions if necessary. * You can change the result file column order and rename the columns on the **Output Columns** tab. * Save the task, Save the package and run it. ![](https://i.imgur.com/yqKocaD.gif) Skyvia allows running the integration packages automatically using the package schedule. You can adjust the frequency according to your business needs. Explore all available Salesforce OneDrive integration opportunities [here](https://skyvia.com/data-integration/integrate-salesforce-onedrive), [register](https://app.skyvia.com/register) in Skyvia for free and start your data integration journey right now. **Pros** * Using tools like Skyvia empowers companies to avoid deployment and upgrades as it’s a cloud-based platform. * You dont need to know to code or be a technical person. A help wizard guides all users with ease, saving time and resources. * Skyvia supports multiple integrations with third-party data and specific data types. * Attractive and flexible pricing plans. **Cons** * Most third-party tools are paid ones, but you need to evaluate them well and check if it meets your requirements for supported data sources. ### Conclusion You can use whatever integration method you prefer and suits your organization. Integrating OneDrive to Salesforce CRM with Skyvia enables flexibility in your business operations with seamless connectivity on a unified platform. Discover Supported Connectors from Skyvia. We make your life easier. [Sign up for a free demo](https://app.skyvia.com/register).

    Import from clipboard

    Advanced permission required

    Your current role can only read. Ask the system administrator to acquire write and comment permission.

    This team is disabled

    Sorry, this team is disabled. You can't edit this note.

    This note is locked

    Sorry, only owner can edit this note.

    Reach the limit

    Sorry, you've reached the max length this note can be.
    Please reduce the content or divide it to more notes, thank you!

    Import from Gist

    Import from Snippet

    or

    Export to Snippet

    Are you sure?

    Do you really want to delete this note?
    All users will lost their connection.

    Create a note from template

    Create a note from template

    Oops...
    This template is not available.


    Upgrade

    All
    • All
    • Team
    No template found.

    Create custom template


    Upgrade

    Delete template

    Do you really want to delete this template?

    This page need refresh

    You have an incompatible client version.
    Refresh to update.
    New version available!
    See releases notes here
    Refresh to enjoy new features.
    Your user state has changed.
    Refresh to load new user state.

    Sign in

    Forgot password

    or

    By clicking below, you agree to our terms of service.

    Sign in via Facebook Sign in via Twitter Sign in via GitHub Sign in via Dropbox

    New to HackMD? Sign up

    Help

    • English
    • 中文
    • Français
    • Deutsch
    • 日本語
    • Español
    • Català
    • Ελληνικά
    • Português
    • italiano
    • Türkçe
    • Русский
    • Nederlands
    • hrvatski jezik
    • język polski
    • Українська
    • हिन्दी
    • svenska
    • Esperanto
    • dansk

    Documents

    Tutorials

    Book Mode Tutorial

    Slide Mode Tutorial

    YAML Metadata

    Contacts

    Facebook

    Twitter

    Feedback

    Send us email

    Resources

    Releases

    Pricing

    Blog

    Policy

    Terms

    Privacy

    Cheatsheet

    Syntax Example Reference
    # Header Header 基本排版
    - Unordered List
    • Unordered List
    1. Ordered List
    1. Ordered List
    - [ ] Todo List
    • Todo List
    > Blockquote
    Blockquote
    **Bold font** Bold font
    *Italics font* Italics font
    ~~Strikethrough~~ Strikethrough
    19^th^ 19th
    H~2~O H2O
    ++Inserted text++ Inserted text
    ==Marked text== Marked text
    [link text](https:// "title") Link
    ![image alt](https:// "title") Image
    `Code` Code 在筆記中貼入程式碼
    ```javascript
    var i = 0;
    ```
    var i = 0;
    :smile: :smile: Emoji list
    {%youtube youtube_id %} Externals
    $L^aT_eX$ LaTeX
    :::info
    This is a alert area.
    :::

    This is a alert area.

    Versions

    Versions and GitHub Sync

    Sign in to link this note to GitHub Learn more
    This note is not linked with GitHub Learn more
     
    Add badge Pull Push GitHub Link Settings
    Upgrade now

    Version named by    

    More Less
    • Edit
    • Delete

    Note content is identical to the latest version.
    Compare with
      Choose a version
      No search result
      Version not found

    Feedback

    Submission failed, please try again

    Thanks for your support.

    On a scale of 0-10, how likely is it that you would recommend HackMD to your friends, family or business associates?

    Please give us some advice and help us improve HackMD.

     

    Thanks for your feedback

    Remove version name

    Do you want to remove this version name and description?

    Transfer ownership

    Transfer to
      Warning: is a public team. If you transfer note to this team, everyone on the web can find and read this note.

        Link with GitHub

        Please authorize HackMD on GitHub

        Please sign in to GitHub and install the HackMD app on your GitHub repo. Learn more

         Sign in to GitHub

        HackMD links with GitHub through a GitHub App. You can choose which repo to install our App.

        Push the note to GitHub Push to GitHub Pull a file from GitHub

          Authorize again
         

        Choose which file to push to

        Select repo
        Refresh Authorize more repos
        Select branch
        Select file
        Select branch
        Choose version(s) to push
        • Save a new version and push
        • Choose from existing versions
        Available push count

        Upgrade

        Pull from GitHub

         
        File from GitHub
        File from HackMD

        GitHub Link Settings

        File linked

        Linked by
        File path
        Last synced branch
        Available push count

        Upgrade

        Danger Zone

        Unlink
        You will no longer receive notification when GitHub file changes after unlink.

        Syncing

        Push failed

        Push successfully