{"id":3486,"date":"2023-04-12T15:33:22","date_gmt":"2023-04-12T15:33:22","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/"},"modified":"2026-01-16T17:18:12","modified_gmt":"2026-01-16T17:18:12","slug":"uploading-data-files-to-ibm-planning-analytics-cloud","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/","title":{"rendered":"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports?"},"content":{"rendered":"<p>Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file to Planning Analytics (Could), a user can use the Planning Analytics Workspace interface, Remote Desktop Connection, or File Transfer Protocol (FTP) tool. In this article, we will review how to upload a file through an FTP tool and the possibility to eliminate the manual steps when uploading files from another system to Planning Analytics (Cloud).<\/p>\n<p>The FTP tool that we will use in our example is FileZilla, but other FTP tools will work as well. Before configuring the FTP tool, we should collect the PA server information from its welcome kit. We need the username and password of the shared drive and the server URL. Please find the sample information below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2501 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/CL1-min.jpg\" alt=\"\" width=\"689\" height=\"423\" \/><\/p>\n<p style=\"margin: 0in 45.0pt 15.0pt 45.0pt;\"><a href=\"http:\/\/servername.planning-analytics.cloud.ibm.com\"><span style=\"font-size: 12.0pt; font-family: Roboto;\"><strong>servername.planning-analytics.cloud.ibm.com<\/strong><\/span><\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2502 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/CL2-min.jpg\" alt=\"\" width=\"573\" height=\"211\" \/><\/p>\n<p>The first step is to set up the connection to the PA shared folder which is on the cloud. After open FileZilla, click \u201cFile\u201d at the top left and then select \u201cSite Manager\u201d to create a new site or the new connection to the shared folder. Click \u201cNew site\u201d and named it \u201cSample PA Connection\u201d, for example.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2497 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/cloud2-min.jpg\" alt=\"\" width=\"400\" height=\"326\" \/><\/p>\n<p>The next step is to configure the connection, which is called \u201cSample PA Connection\u201d in our example. By default, the protocol for the shared folder is FTP but IBM can reconfigure the protocol upon request. The host name and port of the shared folder are found in the welcome kit in the Planning Analytics Shred Folder section. We will select \u201cUser explicit FTP over TLS if available\u201d for the encryption.<\/p>\n<p>There are many types of logon settings, and we use \u201cAsk for password\u201d in our example. This logon type will prompt the user to enter the shared folder password for every connection. The username and password of the shared folder are found in the PA welcome kit under the \u201cUser names and password\u201d section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2498 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/cloud3-min.jpg\" alt=\"\" width=\"723\" height=\"445\" \/><\/p>\n<p>Based on the previous steps, we have entered all parameters required to connect to the PA shared folder. We can click \u201cOK\u201d to save the connection or \u201cConnect\u201d to start the connection. If we start the connection, FileZilla will connect to the PA share folder. If the connection is established, we will see the list of PA folders in the shared folder in the bottom right window. The default folders are \u201cinstall\u201d and \u201cprod\u201d, but a PA developer may add more folders to the shared drive.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2499 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/cloud4-min.jpg\" alt=\"\" width=\"598\" height=\"211\" \/><\/p>\n<p>The last step is to upload a file to the PA shared folder. We will want to navigate to the target folder first before we upload the file. For example, if we want to upload a file to the folder called \u201cmodel_upload\u201d, we will open the \u201cprod\u201d folder, the \u201cData\u201d folder, and then the \u201cmodel_upload\u201d folder (\u2026\/prod\/Data\/model_upload\/) before we drop a file to the folder. Uploading a file is as simple as dragging a file from the user\u2019s laptop to FileZilla and then dropping the file into the \u201cmodel_upload\u201d folder in PA (Cloud).<\/p>\n<p>Although uploading a file to PA (Cloud) requires many manual steps, we can potentially eliminate the manual steps by using the knowledge from the FTP setup combined with the automation or scheduler in another system. The best way to remove the manual steps is to export a file directly from the source system to the PA shared folder. Instead of populating the FTP parameters to FileZilla, a developer will configure the source system\/application to export the data file to the PA shared folder. If this method is not possible, a developer can also export a file from a source system to another FTP server and then schedule a job to upload the file from the FTP server to the PA shared folder. These are sample solutions which will eliminate the manual steps, but the technical details of these methods are beyond the scope of this article.<\/p>\n<p>In conclusion, the information in the PA (Cloud) welcome kit allows us to upload a file to the PA shared folder. A model in PA may require data from another system so the file upload becomes a regular task for a user or an administrator. A tool like FileZilla helps us to easily perform the upload with a few simple steps after the initial setup. If we want to eliminate the manual steps, we can configure the source system to directly export a file to the PA shared folder through FTP. Using another FTP as a middleman to schedule the upload to the PA shared folder is also possible.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file&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-3486","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 Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports? - 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\/uploading-data-files-to-ibm-planning-analytics-cloud\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:33:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T17:18:12+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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports?\",\"datePublished\":\"2023-04-12T15:33:22+00:00\",\"dateModified\":\"2026-01-16T17:18:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/\"},\"wordCount\":812,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CL1-min.jpg\",\"keywords\":[\"Development\",\"Planning Analytics\",\"Planning Analytics Development\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/\",\"name\":\"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CL1-min.jpg\",\"datePublished\":\"2023-04-12T15:33:22+00:00\",\"dateModified\":\"2026-01-16T17:18:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CL1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CL1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/uploading-data-files-to-ibm-planning-analytics-cloud\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports?\"}]},{\"@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 Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports? - 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\/uploading-data-files-to-ibm-planning-analytics-cloud\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports? - QueBIT","og_description":"Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:33:22+00:00","article_modified_time":"2026-01-16T17:18:12+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports?","datePublished":"2023-04-12T15:33:22+00:00","dateModified":"2026-01-16T17:18:12+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/"},"wordCount":812,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/CL1-min.jpg","keywords":["Development","Planning Analytics","Planning Analytics Development"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/","url":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/","name":"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/CL1-min.jpg","datePublished":"2023-04-12T15:33:22+00:00","dateModified":"2026-01-16T17:18:12+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/CL1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/09\/CL1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/uploading-data-files-to-ibm-planning-analytics-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports?"}]},{"@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\/3486","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=3486"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3486\/revisions"}],"predecessor-version":[{"id":5009,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3486\/revisions\/5009"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}