{"id":779,"date":"2022-05-17T00:48:14","date_gmt":"2022-05-16T19:18:14","guid":{"rendered":"https:\/\/blogs.infosys.com\/infosys-cobalt\/?p=779"},"modified":"2022-05-17T00:48:14","modified_gmt":"2022-05-16T19:18:14","slug":"anaplan-connector-mulesoft","status":"publish","type":"post","link":"https:\/\/blogs.infosys.com\/infosys-cobalt\/cloud-applications\/oracle\/anaplan\/anaplan-connector-mulesoft.html","title":{"rendered":"Anaplan Connector &#8211; Mulesoft"},"content":{"rendered":"<p>Modelers often tends to confuse Anaplan Connect with Anaplan Connector. While Anaplan Connect is a on-premises Java utility tool, which can be used to integrate Anaplan with other databases (source system), the latter is cloud-based application with more advanced features to handle more complex integration requirements like &#8211;<\/p>\n<ul>\n<li>Data sourcing from multiple source systems<\/li>\n<li>Standardization of data<\/li>\n<\/ul>\n<p>Data transformation plays an important role in any Integration process, especially if you are sourcing data from multiple source systems with different data sets\/formats. Hence, it\u2019s necessary to standardize the data before you import\/upload the same into the tool.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff9900\"><strong>What is MuleSoft?<\/strong><\/span><\/p>\n<p>MuleSoft is software company based out of California, USA. It\u2019s an Integration &amp; API platform, which allows integration between various applications, database &amp; devices. Using MuleSoft Anaplan connector, data can be sourced\/extracted from any applications, databases, or devises into Anaplan.<\/p>\n<p><strong><span style=\"color: #ff9900\">\u00a0How to access MuleSoft?<\/span><\/strong><\/p>\n<p>You can create a free account at MuleSoft , &amp; start building your integration flow. However, the trial period is for 30 days. You will have to purchase licenses if you want to continue beyond 30 days.<\/p>\n<p>There are 2 ways to access MuleSoft application \u2013 A) MuleSoft Online application &amp; B) Download \u201cAnypoint Studio\u201d into your local computer<\/p>\n<p><strong><span style=\"color: #ff9900\">How to Build an Integration Flow?<\/span><\/strong><\/p>\n<p>There are three important steps required to setup an <strong>Integration Flow<\/strong><\/p>\n<ol>\n<li>Create or Configure HTTP connector \u2013 It allows you to connect to web resources through HTTP or HTTP protocol.<\/li>\n<li>Create or Configure Anaplan connector \u2013 It is used to connect Anaplan with MuleSoft. You can use <strong>MuleSoft Exchange<\/strong> to connect &amp; download Anaplan connector<\/li>\n<li>Create or Configure LOGGER &#8211; It is used to store messages. It displays messages relating to Anaplan Integration from Start to End. It also reflects \u201cError\u201d message if integration fails<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff9900\">What is MuleSoft Anaplan Connector?<\/span><\/strong><\/p>\n<p>Anaplan MuleSoft connectors allows you to import data from different databases, Salesforce, CSV files etc.<\/p>\n<p>You can perform model to model import &amp; run various Anaplan functions like &#8211;<\/p>\n<ul>\n<li>Execute import only \u2013 You can create an Integration flow to run any \u201cImport\u201d action in Anaplan directly<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-856 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"246\" height=\"66\" \/><\/p>\n<ul>\n<li>Execute import with files \u2013 This function allows you to upload any file from your local drive into Anaplan &amp; simultaneously run the \u201cImport\u201d action directly<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-857 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"267\" height=\"70\" \/><\/p>\n<ul>\n<li>Execute import streaming \u2013 In this case, instead of uploading files from your local drive, you can extract files from different databases (SAP S4 HANA, Salesforce, Workday etc.) &amp; simultaneously run the \u201cImport\u201d action<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-858 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"334\" height=\"70\" \/><\/p>\n<ul>\n<li>Execute export with files \u2013 This function allows you to run any \u201cExport\u201d action in Anaplan &amp; simultaneously export the data from Anaplan into your local drive<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-859 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"208\" height=\"56\" \/><\/p>\n<ul>\n<li>Execute export streaming \u2013 You can create an integration flow to run any \u201cExport\u201d action &amp; at the same time, export the data from Anaplan into any integrated databases (SAP S4 HANA, Salesforce, Workday etc.)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>Execute file upload with files \u2013 As we have already talked about \u201cExecute import with files\u201d, you must be thinking what is the difference between \u201cExecute import with files\u201d &amp; \u201cExecute file upload with files\u201d? \u00a0Both are used to upload files, however in case of \u201cExecute file upload with files\u201d, files are being loaded into Anaplan server only, which means that the data is not getting imported into any models.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-860 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"269\" height=\"78\" \/><\/p>\n<ul>\n<li>Execute file upload streaming \u2013 Similar to the above functions, files are being loaded into Anaplan server only, the models are not impacted with this upload<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-861 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"435\" height=\"63\" \/><\/p>\n<ul>\n<li>Describe Anaplan file \u2013 You can get a preview of the file which you are going to be uploaded into Anaplan. A maximum 20 lines are shown<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-862 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"236\" height=\"67\" \/><\/p>\n<ul>\n<li>Execute process \u2013 You can use this function whenever you want to execute any \u201cProcess\u201d action directly in Anaplan<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-863 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"245\" height=\"71\" \/><\/p>\n<p><strong><span style=\"color: #ff9900\">How to Build an Extract, Transform, Load (ETL) Process Flow?<\/span><\/strong><\/p>\n<p>MuleSoft provides a unique feature to extract, transform &amp; load the transformed data into Anaplan.<\/p>\n<p>You can create an integration flow by which data can be extracted from a source system, followed by transformation &amp; then finally load the transformed data into the Anaplan<\/p>\n<p><em>For example, the below integration flow showcase how raw unorganized\/unstructured data is being extracted from cloud storage account into MuleSoft \u2013 followed by data transformation \u2013 then re-upload the transformed data into cloud storage account &amp; finally, load the transformed data into Anaplan<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-864 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"522\" height=\"103\" \/><\/p>\n<p>The important thing to consider here is \u201cTransform Message\u201d which allows you to map source with target items.<\/p>\n<p>With the help of DataWeave (functional language used to perform data transformation), you can make various transformation related changes like format, object addition, modification etc.<\/p>\n<p>For more information, visit <span style=\"text-decoration: underline\">https:\/\/docs.mulesoft.com\/dataweave\/2.4\/dataweave-functions<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-865 size-full\" src=\"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-content\/themes\/infosys-blog\/images\/Sample-Image.jpg\" alt=\"\" width=\"502\" height=\"169\" \/><\/p>\n<p><strong><span style=\"color: #0000ff\">Conclusion<\/span><\/strong><\/p>\n<p>MuleSoft can be used extensively for any complex integration &amp; automation requirement. There are many other third-party Anaplan connectors available in the market like Informatica, Dell Bhoomi etc. which performs similar kind of function like MuleSoft, so it\u2019s up to individual businesses to identify &amp; select the best integration tool as per their business requirement.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modelers often tends to confuse Anaplan Connect with Anaplan Connector. While Anaplan Connect is [&hellip;]<\/p>\n","protected":false},"author":127,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[85],"tags":[84,90],"coauthors":[83],"class_list":["post-779","post","type-post","status-publish","format-standard","hentry","category-anaplan","tag-anaplan","tag-data-integration"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/users\/127"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/comments?post=779"}],"version-history":[{"count":2,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/779\/revisions"}],"predecessor-version":[{"id":867,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/779\/revisions\/867"}],"wp:attachment":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/media?parent=779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/categories?post=779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/tags?post=779"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/coauthors?post=779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}