{"id":14451,"date":"2021-09-03T20:14:39","date_gmt":"2021-09-03T14:44:39","guid":{"rendered":"http:\/\/ismiletechnologies.com\/?p=14451"},"modified":"2021-11-12T21:28:15","modified_gmt":"2021-11-12T15:58:15","slug":"quick-guide-for-migrating-alteryx-to-the-cloud","status":"publish","type":"post","link":"https:\/\/ismiletechnologies.com\/en_us\/cloud\/quick-guide-for-migrating-alteryx-to-the-cloud\/","title":{"rendered":"Quick Guide for Migrating Alteryx to the cloud"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>What is Alteryx?&nbsp;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Alteryx is&nbsp;mainly a data science visualization tool. It has tools that allow for the manipulation of data and has a \u201cworkflow\u201d that allows the user to take those tools and visualize them in a flow chart where each process is represented by a picture and the data taken from the output can flow into the input of another process.&nbsp;Basically&nbsp;allowing the user to automate and visualize multi-step data manipulation processes.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"846\" height=\"476\" src=\"http:\/\/ismiletechnologies.com\/wp-content\/uploads\/2021\/09\/image.jpeg\" alt=\"\" class=\"wp-image-14453\" srcset=\"https:\/\/ismiletechnologies.com\/wp-content\/uploads\/2021\/09\/image.jpeg 846w, https:\/\/ismiletechnologies.com\/wp-content\/uploads\/2021\/09\/image-300x169.jpeg 300w, https:\/\/ismiletechnologies.com\/wp-content\/uploads\/2021\/09\/image-768x432.jpeg 768w\" sizes=\"(max-width: 846px) 100vw, 846px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">But before we get into anything complex, if&nbsp;you only want to move one dataset&nbsp;to a cloud server, that can be done easily. To transfer a single dataset, first&nbsp;we must&nbsp;right click on any other the&nbsp;icons in the workflow&nbsp;that represents data&nbsp;we want to move to the cloud.&nbsp;From that&nbsp;list, click \u201cconvert to output\u201d. Once that\u2019s done, you should be able to see from the left-hand side a drop-down box titled \u201cwrite to file or database\u201d. Click on the drop-down arrow and there should appear a large box that gives you the options on where you want to output your data. From there you can click on \u201cdata sources\u201d and pick the type of database you\u2019d like to connect to, including cloud databases such as Microsoft Azure and Amazon Athena.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re having trouble with this, a helpful video for this portion can be found here:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"OUTPUT DATA | ALTERYX 2-MINUTE TOOLS\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/sjrHRw-X8F8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re still here,&nbsp;than&nbsp;to migrate&nbsp;workflows, we have to use a Gallery API.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">APIs are application programming interfaces.&nbsp;It basically allows you to interact with applications through programs.&nbsp;Explaining what APIs are&nbsp;in more detail&nbsp;would be very long and couldn\u2019t fit in this blog, so if you&nbsp;are unfamiliar with them, here are a couple helpful links to help describe what they are. The first link gives a brief overview of APIs, and the second goes into detail about gallery APIs, which is what we need for the next steps.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/help.alteryx.com\/developer-help\/get-started-apis\">https:\/\/help.alteryx.com\/developer-help\/get-started-apis<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/help.alteryx.com\/developer-help\/gallery-api-overview\">https:\/\/help.alteryx.com\/developer-help\/gallery-api-overview<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before we do anything, we must&nbsp;ensure that,&nbsp;we&nbsp;set&nbsp;our workflows&nbsp;to be&nbsp;available to migrate. If you find the Workflows page of the&nbsp;Gallery&nbsp;Admin interface, you should select your workflow and see a bullet list of options.&nbsp;In the bullet list there will be one that says&nbsp;\u201cThis workflow is ready to be migrated\u201d. Make sure this is checked to \u201cyes\u201d.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re having trouble, the official Alteryx page for this instruction can be found here:&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/help.alteryx.com\/20211\/server\/enable-workflows-migration\">https:\/\/help.alteryx.com\/20211\/server\/enable-workflows-migration<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once that is done, we can begin:&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The first thing to do is make a list of the workflows you\u2019d like to migrate. To do that, we must construct a&nbsp;Gallery&nbsp;API endpoint.&nbsp;The environment must be \u201cSource\u201d, the method must be \u201cGet\u201d, and the Endpoint must be:&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Api\/admin\/v1\/workflows\/migratable\/?subscriptionIds={subscriptionIds}\/&nbsp;<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Where you put a comma-separated list of subscription ids&nbsp;in place of {subscriptionIds}.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The second thing we&nbsp;must&nbsp;do is to download the workflows&nbsp;as a YXZP file. To do that, we must construct another endpoint.&nbsp;The environment and the method again must be \u201cSource\u201d and \u201cGet\u201d.&nbsp;The endpoint this time is:&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Api\/admin\/v1\/{appID}\/package\/&nbsp;<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Where you put the&nbsp;appID&nbsp;in place of {appID}&nbsp;<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And finally, the last thing we must do is publish the workflow to the&nbsp;target environment. We must create one final endpoint. The environment is \u201ctarget\u201d, the method is \u201cpost\u201d, and the endpoint is:&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Api\/admin\/v1\/workflows\/&nbsp;<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you are having trouble with this part, the official Alteryx page for these&nbsp;instructions&nbsp;can be found here:&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/help.alteryx.com\/developer-help\/gallery-api-migratable-endpoint\">https:\/\/help.alteryx.com\/developer-help\/gallery-api-migratable-endpoint<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you for reading.&nbsp;I hope this was helpful for you.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is Alteryx?&nbsp; Alteryx is&nbsp;mainly a data science visualization tool. It has tools that allow for the manipulation of data and has a \u201cworkflow\u201d that allows the user to take those tools and visualize them in a flow chart where each process is represented by a picture and the data taken from the output can [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":15185,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97],"tags":[202],"class_list":["post-14451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","tag-alteryx"],"_links":{"self":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/14451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/comments?post=14451"}],"version-history":[{"count":3,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/14451\/revisions"}],"predecessor-version":[{"id":20834,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/14451\/revisions\/20834"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media\/15185"}],"wp:attachment":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media?parent=14451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/categories?post=14451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/tags?post=14451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}