{"id":114,"date":"2021-08-02T19:53:00","date_gmt":"2021-08-02T19:53:00","guid":{"rendered":"https:\/\/haddingtonsolutions.com\/?p=30"},"modified":"2022-10-10T18:19:07","modified_gmt":"2022-10-10T18:19:07","slug":"blog-series-announcement","status":"publish","type":"post","link":"https:\/\/haddingtonsolutions.com\/index.php\/2021\/08\/02\/blog-series-announcement\/","title":{"rendered":"Blog Series Announcement"},"content":{"rendered":"<p>Over the next few weeks I will be posting about some interesting topics that are core to Haddington Solutions business model.<\/p>\n<p>I will firstly be exploring the new service recently rolled out by Microsoft, called <a href=\"https:\/\/www.microsoft.com\/en-ie\/windows-365\/business\" target=\"_blank\" rel=\"noopener\">Windows365.<\/a><\/p>\n<p>This new service will enable our clients to spin up a fully Windows enabled cloud computer that we can use to run a variety of Data Analysis and Data Integration jobs.<\/p>\n<p>This will enable our customers to be completely in control of their own data while also adhering to company wide Windows security policies.<\/p>\n<p>The next blog will take you through the set up of the statical software package, <a href=\"https:\/\/www.r-project.org\/\" target=\"_blank\" rel=\"noopener\">R<\/a>.<\/p>\n<p>R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS.<\/p>\n<p>We will use R to call an API through a package in the software to gather some data into an output file on our Windows365 machine mentioned above.<\/p>\n<p>The next part of the blog will be to set up a freeware ETL tool called <a href=\"https:\/\/www.talend.com\/\" target=\"_blank\" rel=\"noopener\">Talend<\/a>.<\/p>\n<p>Talend is free tool we will be using to orchestrate the running of our R script created earlier.<\/p>\n<p>There is a considerable amount of set up required to actually get Talend to run on a Windows Machine.<\/p>\n<p>I will walk you through this step by step after which, we will then connect this software to your Salesforce Org.<\/p>\n<p>We will cover some best practices on data migration and data integration with respects to our Enterprise CRM, <a href=\"https:\/\/www.salesforce.com\/eu\/\" target=\"_blank\" rel=\"noopener\">Salesforce<\/a>.<\/p>\n<p>We will use Talend to run and process the R script above and then upload the records into Salesforce.<\/p>\n<p>After that all we have to do is schedule the job to run on our Windows 365 machine, then watch the data update in our Salesforce Org.<\/p>\n<p>This will be a 4 part series in which I will aim to also create a video walkthrough or demonstration of whats being discussed in each part.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Over the next few weeks I will be posting about some interesting topics that are core to Haddington Solutions business model. I will firstly be exploring the new service recently rolled out by Microsoft, called Windows365. This new service will enable our clients to spin up a fully Windows enabled cloud computer that we can [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":192,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_wpcom_ai_launchpad_first_post":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-integration"],"jetpack_featured_media_url":"https:\/\/haddingtonsolutions.com\/wp-content\/uploads\/2021\/08\/53y3.jpg","_links":{"self":[{"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":1,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/114\/revisions"}],"predecessor-version":[{"id":193,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/114\/revisions\/193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/media\/192"}],"wp:attachment":[{"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/media?parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/categories?post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haddingtonsolutions.com\/index.php\/wp-json\/wp\/v2\/tags?post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}