{"id":3488,"date":"2023-04-12T15:33:27","date_gmt":"2023-04-12T15:33:27","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/"},"modified":"2026-01-16T17:16:55","modified_gmt":"2026-01-16T17:16:55","slug":"using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/","title":{"rendered":"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics?"},"content":{"rendered":"<p>Technology executives and managers are always looking for ways to be more effective while at the same time reducing costs in maintenance hours, physical servers, processes, etc.\u2014 It\u2019s always a balancing act.<\/p>\n<p>One way to accomplish both goals can be by leveraging existing technology investments that are tried and true. Microsoft\u2019s SharePoint and OneDrive is a technology most organizations have in place and, as such it\u2019s tried and true, as is IBM Planning Analytics (also known as TM1). This article describes a way to integrate Microsoft\u2019s SharePoint and OneDrive with IBM Planning Analytics (PA).<\/p>\n<p>In the IBM Planning Analytics world, we often rely on flat files (.txt, .csv, etc.) as sources of data for our models. Often these files are shared with PA via a shared file location (either a dedicated file server or the PA server itself), which usually means we must allocate more storage than the PA system needs or create a dedicated file server.<\/p>\n<p>With the recent releases of SharePoint, Teams, and One Drive we have potentially found an alternative infrastructure location for these flat file sources that can be leveraged, especially now that many organizations are moving to Microsoft\u2019s O365 licensing model.<\/p>\n<p>Pre-requisites:<\/p>\n<p>&#8211; Service Account with Office 365 License with licenses to:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>SharePoint<\/li>\n<li>OneDrive<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&#8211; IBM Planning Analytics Server<\/p>\n<p>&#8211; Remote Desktop Protocol (RDP) access to the IBM Planning Analytics (TM1) Server<\/p>\n<p>In this example, we will set up a SharePoint location for files to be used as a data source for a PA TurboIntegrator process, and then we will set the data source using TM1 Architect.<\/p>\n<p><em>Step 1:<\/em> Open the SharePoint site where users will drop the files. Click on the <strong>Sync <\/strong>option. This must be done on (via RDP) the PA server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2522 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT1-min.jpg\" alt=\"\" width=\"624\" height=\"156\" \/><\/p>\n<p>The <strong>Sync <\/strong>button will create a shortcut in the Windows Explorer area, in our example the SharePoint site is called <strong>Training<\/strong>. The files are located in the <u>Document Library<\/u> called <strong>Internal Training,<\/strong> the folder called <strong>SharePoint Data Source. <\/strong>The resulting shortcut in Windows is called <strong>Training \u2013 SharePoint Data Source<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2523 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT2-min.jpg\" alt=\"\" width=\"460\" height=\"283\" \/><\/strong><\/p>\n<p>The actual Windows location of this folder is <strong>C:UsersWalterHugoAnezQueBIT Consulting, LLCTraining &#8211; SharePoint Data Source. <\/strong>This means it will synchronize with the service account\u2019s profile.<\/p>\n<p><em>Step 2:<\/em> Create the TI process to point to the location<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2524 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT3-min.jpg\" alt=\"\" width=\"624\" height=\"427\" \/><\/p>\n<p>Step 3: To test it, upload a new version of the file with updated numbers. Make sure you pick Replace. The file updates immediately in the local Sync location. Or you can click the Sync button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2525 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT4-min.jpg\" alt=\"\" width=\"624\" height=\"196\" \/><\/p>\n<p>Step 4: Run the Turbo Integrator process!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Technology executives and managers are always looking for ways to be more effective while at the same time reducing costs in maintenance hours, physical servers, processes, etc.\u2014 It\u2019s always a balancing act. One way to accomplish both goals can be by leveraging existing technology investments that are tried and true. Microsoft\u2019s SharePoint and OneDrive is&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[35,36,52],"class_list":["post-3488","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-development","tag-planning-analytics","tag-planning-analytics-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Technology executives and managers are always looking for ways to be more effective while at the same time reducing costs in maintenance hours, physical servers, processes, etc.\u2014 It\u2019s always a balancing act. One way to accomplish both goals can be by leveraging existing technology investments that are tried and true. Microsoft\u2019s SharePoint and OneDrive is&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:33:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T17:16:55+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics?\",\"datePublished\":\"2023-04-12T15:33:27+00:00\",\"dateModified\":\"2026-01-16T17:16:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/\"},\"wordCount\":437,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/FLAT1-min.jpg\",\"keywords\":[\"Development\",\"Planning Analytics\",\"Planning Analytics Development\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/\",\"name\":\"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/FLAT1-min.jpg\",\"datePublished\":\"2023-04-12T15:33:27+00:00\",\"dateModified\":\"2026-01-16T17:16:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/FLAT1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/FLAT1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics? - QueBIT","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:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics? - QueBIT","og_description":"Technology executives and managers are always looking for ways to be more effective while at the same time reducing costs in maintenance hours, physical servers, processes, etc.\u2014 It\u2019s always a balancing act. One way to accomplish both goals can be by leveraging existing technology investments that are tried and true. Microsoft\u2019s SharePoint and OneDrive is&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:33:27+00:00","article_modified_time":"2026-01-16T17:16:55+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics?","datePublished":"2023-04-12T15:33:27+00:00","dateModified":"2026-01-16T17:16:55+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/"},"wordCount":437,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT1-min.jpg","keywords":["Development","Planning Analytics","Planning Analytics Development"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/","url":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/","name":"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT1-min.jpg","datePublished":"2023-04-12T15:33:27+00:00","dateModified":"2026-01-16T17:16:55+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/10\/FLAT1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/using-a-sharepoint-site-for-ibm-planning-analytics-flat-file-data-sources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Use a SharePoint Site as a Source for Flat File Data in IBM Planning Analytics?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3488"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3488\/revisions"}],"predecessor-version":[{"id":5007,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3488\/revisions\/5007"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}