{"id":14300,"date":"2021-01-22T17:40:34","date_gmt":"2021-01-22T22:40:34","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=14300"},"modified":"2021-01-25T10:15:19","modified_gmt":"2021-01-25T15:15:19","slug":"sharepoint-files-iri-workbench","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/","title":{"rendered":"Using SharePoint Files with IRI Workbench Software"},"content":{"rendered":"<p><i><span style=\"font-weight: 400;\">This article explains how to connect with, and use data from, SharePoint sites &#8212; using the file system via OneDrive &#8212; for operations in <\/span><\/i><a href=\"https:\/\/www.iri.com\/products\/workbench\"><i><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/i><\/a><i><span style=\"font-weight: 400;\">-supported data management software. That software includes the IRI Voracity platform and its component <\/span><\/i><a href=\"https:\/\/www.iri.com\/products\"><i><span style=\"font-weight: 400;\">products<\/span><\/i><\/a><i><span style=\"font-weight: 400;\">: CoSort, NextForm, RowGen, FieldShield, DarkShield, and CellShield EE.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">IRI data management and protection software products work with a wide range of <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\/data-sources\"><span style=\"font-weight: 400;\">data sources and formats<\/span><\/a><span style=\"font-weight: 400;\">. However, accessing data in SharePoint directories has heretofore been impossible, as those files are hosted online.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">More specifically, there was no way to access them without downloading them to the file system unless the file data were streamed. That precluded manipulating data in file formats like .XLSX, the now prevalent format of Microsoft Excel, since streams of non-textual file formats are difficult to modify directly in stream format.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">However, there is another method that a user can take to access files in SharePoint directly from the file system, while still syncing immediately with the online SharePoint site files. By logging into SharePoint and selecting the <\/span><b>sync<\/b><span style=\"font-weight: 400;\"> button from the Documents page, a OneDrive hook can be set up between SharePoint.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">What this means is that IRI products can access all SharePoint site files chosen to be synced, and process that data virtually in real-time.<span id='easy-footnote-1-14300' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#easy-footnote-bottom-1-14300' title='&lt;\/span&gt;&lt;span style=&quot;font-weight: 400;&quot;&gt;The only delays are with network speed. For example, maybe a folder of large files has been uploaded. This may take a few seconds to a few minutes to sync, depending on network speed and file sizes. If there is a new file or folder of files uploaded to the SharePoint site that hasn&amp;#8217;t been synced locally yet, OneDrive will be called on to sync the files when the SortCL-compatible job runs. The job will pause until the file has been synced to the local OneDrive folder. Once the job completes, if any files produced were output within the OneDrive folder, they get synced immediately with the SharePoint site, again with the only limitation being the upload speed of the network. Note that limitations can also be intentionally placed on OneDrive upload and download speeds so as not to overload network bandwidth.'><sup>1<\/sup><\/a><\/span>\u00a0<\/span><a href=\"https:\/\/www.iri.com\/products\/voracity\/technical-details#capabilities\"><span style=\"font-weight: 400;\">Supported activities<\/span><\/a><span style=\"font-weight: 400;\"> include data discovery, integration (ETL), migration, governance (clean, mask, test), and analytics.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The details of this connection method are described below.<\/span><\/p>\n<h5><b>Steps<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">1. To begin with, sign into the SharePoint site through your Microsoft account. Likely there will be a request sent for two-factor authentication (handled easiest with the Microsoft Authenticator app).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">I signed in through the Microsoft 365 developer portal, where I have a development SharePoint instance I can access; i.e.,<\/span><\/p>\n<p><a href=\"https:\/\/developer.microsoft.com\/en-us\/microsoft-365\/dev-program\"><span style=\"font-weight: 400;\">https:\/\/developer.microsoft.com\/en-us\/microsoft-365\/dev-program<\/span><\/a><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365developer.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14306 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365developer-1024x555.png\" alt=\"\" width=\"649\" height=\"352\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365developer-1024x555.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365developer-300x163.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365developer-768x416.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365developer.png 1600w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">2. Once into the account, select the SharePoint site to access. In the below image, I am accessing the SharePoint site \u201cTest\u201d:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365home.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14307 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365home-1024x555.png\" alt=\"\" width=\"651\" height=\"353\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365home-1024x555.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365home-300x163.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365home-768x416.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-m365home.png 1600w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">3. Once the SharePoint site has been accessed, a view similar to this should appear. Next, click on \u201cDocuments\u201d from the menu on the left side of the screen.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14305 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite-1024x555.png\" alt=\"\" width=\"649\" height=\"352\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite-1024x555.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite-300x163.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite-768x416.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png 1600w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">4. This allows you to browse the folders and files of the SharePoint site. To set up a sync between the local file system and SharePoint, select \u201cSync\u201d from the middle menu, which will bring up a prompt such as this.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-syncSharepointFiles.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14308 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-syncSharepointFiles-1024x555.png\" alt=\"\" width=\"651\" height=\"353\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-syncSharepointFiles-1024x555.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-syncSharepointFiles-300x163.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-syncSharepointFiles-768x416.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-syncSharepointFiles.png 1600w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">5. A few prompts will walk you through the setup of OneDrive sync with the SharePoint site. You can choose where the root folder of the site is placed into your file system. Also, folders can be selectively synced; in other words, not all the files on the site need to take up space in the file system if they are not selected to be synced.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once the setup is complete, you should be able to view the selected files from SharePoint in File Explorer, and they will be synced whenever changes are made &#8212; either on the site or locally.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-site.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14309 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-site-1024x276.png\" alt=\"\" width=\"649\" height=\"175\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-site-1024x276.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-site-300x81.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-site-768x207.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-site.png 1077w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">For each site, the syncing button needs to be pressed once, but after the setup of the first site it is as simple as clicking the Sync button from the SharePoint site, with no other configuration needed.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Now, the files can be accessed by any IRI product. Let\u2019s start with <\/span><a href=\"https:\/\/www.iri.com\/products\/cellshield\/cellshield-ee\"><span style=\"font-weight: 400;\">CellShield Enterprise Edition<\/span><\/a><span style=\"font-weight: 400;\"> (EE), a product which finds and masks sensitive data in XLS and XLSX files. In CellShield EE, the Dark Data Search\/Masking job wizard in IRI Workbench can be used to find sensitive data to mask in XLS and XLSX files.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The OneDrive folder that syncs with SharePoint is now selectable from the file browser. Select to search for XLS and XLSX files as needed from the Dark Data Search\/Masking job wizard in IRI Workbench.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If this menu is not visible, install the IRI DarkShield feature from \u201cinstall new software\u201d in the IRI Workbench. Its toolbar menu icon is a charcoal-colored shield. Once you installed, run the wizard and select the data source:<\/span><\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-spointfile.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14310 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-spointfile.png\" alt=\"\" width=\"511\" height=\"443\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-spointfile.png 511w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-spointfile-300x260.png 300w\" sizes=\"(max-width: 511px) 100vw, 511px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Next, set up data classes to match data based on search matchers like regular expressions, lookup sets (which list values to match against), or NER models. See <\/span><a href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-classification-in-iri-workbench\"><span style=\"font-weight: 400;\">this article<\/span><\/a><span style=\"font-weight: 400;\"> on data classification for more information about this process.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For DarkShield, rules can be set to mask data in a certain way based on the matcher used. With CellShield EE, the masking method is selected later when importing the \u201cEIF\u201d file, and can be based on either the data class matcher or a manual selection of EIF entries.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Run the resulting<\/span><i><span style=\"font-weight: 400;\"> .search<\/span><\/i><span style=\"font-weight: 400;\"> file from the Dark Data Search\/Masking job wizard as an IRI search job to generate the .EIF file. Import it in CellShield EE to map search results to cells to mask.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here is an example of the EIF file:<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-eif.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14311 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-eif-1024x466.png\" alt=\"\" width=\"650\" height=\"296\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-eif-1024x466.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-eif-300x136.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-eif-768x349.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-eif.png 1385w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">As you can see, the wizard was able to successfully identify sensitive data from these files in my SharePoint-synced OneDrive folder, which has the base name of \u201ciricosort\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here are the dark data search shown in IRI Workbench:<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-collage.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14312 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-collage-1024x333.png\" alt=\"\" width=\"649\" height=\"211\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-collage-1024x333.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-collage-300x98.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-collage-768x250.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepoint-collage.png 1557w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Both DarkShield and CellShield EE can mask data in XLS and XLSX files based on the search results. DarkShield supports many other formats, including Word documents, Powerpoint presentations, PDF and image files, plus unstructured text files.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">DarkShield and CellShield are not the only IRI products that benefit from syncing SharePoint files locally. This also allows access for the <\/span><a href=\"https:\/\/wwww.iri.com\/products\/cosort\/sortcl\"><span style=\"font-weight: 400;\">SortCL<\/span><\/a><span style=\"font-weight: 400;\"> engine and 4GL behind IRI CoSort, RowGen, NextForm, and FieldShield &#8212; and Voracity operations (e.g., ETL) that include or combine them to process data in any structured format in SharePoint. XLS and XLSX file formats are also supported by SortCL and thus the most recent versions of these products.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With this synced setup to SharePoint, many useful scenarios are possible that may not be as easy if the setup was not synced and files had to be manually downloaded and uploaded. For example, batch files can be scheduled to run at certain times to automatically update XLSX files with new live data, which will get directly synced into SharePoint to be shared with other users.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Setting up SharePoint site files to a file system directory via OneDrive is a simple yet robust way to access SharePoint site files with IRI software, and will work along with other sources as part of heterogeneous IRI data integration, cleansing, masking, reporting, and wrangling operations.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Contact <\/span><a href=\"mailto:support@iri.com\"><span style=\"font-weight: 400;\">support@iri.com<\/span><\/a><span style=\"font-weight: 400;\"> if you need help processing files in SharePoint using this access method.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article explains how to connect with, and use data from, SharePoint sites &#8212; using the file system via OneDrive &#8212; for operations in IRI Workbench-supported data management software. That software includes the IRI Voracity platform and its component products: CoSort, NextForm, RowGen, FieldShield, DarkShield, and CellShield EE. IRI data management and protection software products<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\" title=\"Using SharePoint Files with IRI Workbench Software\">Read More<\/a><\/div>\n","protected":false},"author":119,"featured_media":14305,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,1,34,91,29],"tags":[14,5,982,546,789,850,1500,68],"class_list":["post-14300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-transformation2","category-business","category-iri-workbench","category-test-data","tag-data-masking","tag-data-transformation","tag-iri-cellshield-enterprise-edition","tag-iri-cosort","tag-iri-voracity","tag-iri-workbench","tag-sharepoint","tag-sortcl"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using SharePoint Files with IRI Workbench Software - IRI<\/title>\n<meta name=\"description\" content=\"IRI data management and protection software products work with a wide range of data sources and formats. However, accessing data in SharePoint directories\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using SharePoint Files with IRI Workbench Software - IRI\" \/>\n<meta property=\"og:description\" content=\"IRI data management and protection software products work with a wide range of data sources and formats. However, accessing data in SharePoint directories\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-22T22:40:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-25T15:15:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"867\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Devon Kozenieski\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Devon Kozenieski\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\"},\"author\":{\"name\":\"Devon Kozenieski\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1\"},\"headline\":\"Using SharePoint Files with IRI Workbench Software\",\"datePublished\":\"2021-01-22T22:40:34+00:00\",\"dateModified\":\"2021-01-25T15:15:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\"},\"wordCount\":1205,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png\",\"keywords\":[\"data masking\",\"data transformation\",\"IRI CellShield Enterprise Edition\",\"IRI CoSort\",\"IRI Voracity\",\"IRI Workbench\",\"SharePoint\",\"SortCL\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Transformation\",\"IRI Business\",\"IRI Workbench\",\"Test Data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\",\"name\":\"Using SharePoint Files with IRI Workbench Software - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png\",\"datePublished\":\"2021-01-22T22:40:34+00:00\",\"dateModified\":\"2021-01-25T15:15:19+00:00\",\"description\":\"IRI data management and protection software products work with a wide range of data sources and formats. However, accessing data in SharePoint directories\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png\",\"width\":1600,\"height\":867},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using SharePoint Files with IRI Workbench Software\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1\",\"name\":\"Devon Kozenieski\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g\",\"caption\":\"Devon Kozenieski\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/devonk\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using SharePoint Files with IRI Workbench Software - IRI","description":"IRI data management and protection software products work with a wide range of data sources and formats. However, accessing data in SharePoint directories","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Using SharePoint Files with IRI Workbench Software - IRI","og_description":"IRI data management and protection software products work with a wide range of data sources and formats. However, accessing data in SharePoint directories","og_url":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/","og_site_name":"IRI","article_published_time":"2021-01-22T22:40:34+00:00","article_modified_time":"2021-01-25T15:15:19+00:00","og_image":[{"width":1600,"height":867,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png","type":"image\/png"}],"author":"Devon Kozenieski","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Devon Kozenieski","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/"},"author":{"name":"Devon Kozenieski","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1"},"headline":"Using SharePoint Files with IRI Workbench Software","datePublished":"2021-01-22T22:40:34+00:00","dateModified":"2021-01-25T15:15:19+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/"},"wordCount":1205,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png","keywords":["data masking","data transformation","IRI CellShield Enterprise Edition","IRI CoSort","IRI Voracity","IRI Workbench","SharePoint","SortCL"],"articleSection":["Data Masking\/Protection","Data Transformation","IRI Business","IRI Workbench","Test Data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/","url":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/","name":"Using SharePoint Files with IRI Workbench Software - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png","datePublished":"2021-01-22T22:40:34+00:00","dateModified":"2021-01-25T15:15:19+00:00","description":"IRI data management and protection software products work with a wide range of data sources and formats. However, accessing data in SharePoint directories","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png","width":1600,"height":867},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/sharepoint-files-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using SharePoint Files with IRI Workbench Software"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1","name":"Devon Kozenieski","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19bf36cedac5d586ea168f58f96eb2f1?s=96&d=blank&r=g","caption":"Devon Kozenieski"},"url":"https:\/\/beta.iri.com\/blog\/author\/devonk\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2021\/01\/sharepointsite.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14300"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/119"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=14300"}],"version-history":[{"count":7,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14300\/revisions"}],"predecessor-version":[{"id":14317,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14300\/revisions\/14317"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/14305"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=14300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=14300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=14300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}