{"id":726,"date":"2014-11-11T09:43:40","date_gmt":"2014-11-11T14:43:40","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=726"},"modified":"2014-11-11T17:03:59","modified_gmt":"2014-11-11T22:03:59","slug":"data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/","title":{"rendered":"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund"},"content":{"rendered":"<p>Today, we have a piece of contributed content on the hot topic of data integration from Jay Mishra, Vice President of Product Development at Astera Software (<a href=\"https:\/\/www.astera.com\">www.astera.com<\/a>). Below, Mr. Mishra discusses how Astera overcame the challenge of integrating data between multiple sources with no standard format for Vanderbilt University.<\/p>\n<hr \/>\n<p><a href=\"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-728\" src=\"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund-175x150.jpg\" alt=\"Data Integration Provides Key Step Enabling University to Analyze Endowment Fund\" width=\"175\" height=\"150\" \/><\/a>By Jay Mishra &#8211; Managing a $3.2 billion endowment trust to maximize return and minimize risk is a challenge. But when performance and risk data come from multiple sources with no standard format, that challenge is dramatically harder.<\/p>\n<p>That was the situation facing Vanderbilt University in Nashville, Tenn. Vanderbilt is a private research university enrolling approximately 12,000 students from all 50 U.S. states and over 90 foreign countries. The university\u2019s Office of Investments manages its $3.2 billion endowment, which provides the university with funding for teaching, research, public services and more.<\/p>\n<p>The office typically invests these funds through multiple external money managers who have little or no communication with each other. The Office of Investments wanted to be able to determine consolidated risk exposures of the endowment to better understand the impact of different macroeconomic and market shocks, but this proved to be a very difficult and, at times, manual task because the investment data was scattered across multiple systems.<\/p>\n<p>To bring this data into a common platform, the university made the decision to acquire a data integration platform. Its requirements were simple, the university needed accurate and timely reporting of endowment investments and the ability to gather and map data from a variety of sources. The solution needed to be web-based, with an easy-to-use front end for business users, as well as a sophisticated engine to deliver the analytics necessary for the university\u2019s stakeholders.<\/p>\n<p>After a build-or-buy analysis, the decision was made to acquire a data integration platform and a team was formed to evaluate various integration tools.<\/p>\n<p>The university already had in place SQL server integration services (SSIS), a data integration tool for Microsoft SQL server, but determined it was too difficult for users outside of the IT department and therefore entailed a significantly high total cost of ownership.<\/p>\n<p>What the team needed was a solution with an easy-to-use front end for business users, as well as a sophisticated engine to deliver the analytics necessary for the university\u2019s stakeholders.<\/p>\n<p>Vanderbilt ultimately selected an extract, transform and load (<a href=\"https:\/\/en.wikipedia.org\/wiki\/ETL\">ETL<\/a>) software solution that provided dataflow, workflow, and scheduling capabilities, so that the university\u2019s finance team could quickly develop integration jobs to automatically retrieve and map data from external money managers and internal systems into the endowment tracking software. The software interface that met the needs of both the university\u2019s technical and non-technical users featured a drag-and-drop user interface that allowed the users to map data from a source file to a destination file without writing code.<\/p>\n<p>With the new data integration software, the team&#8217;s business users can now develop complex dataflows in hours instead of weeks. The project has been so successful that Vanderbilt is now deploying the data integrator in other areas to enhance existing processes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, we have a piece of contributed content on the hot topic of data integration from Jay Mishra, Vice President of Product Development at Astera Software (www.astera.com). Below, Mr. Mishra discusses how Astera overcame the challenge of integrating data between multiple sources with no standard format for Vanderbilt University. By Jay Mishra &#8211; Managing a [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":728,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund &#187; Best Data Integration Vendors, News &amp; Reviews for Big Data, Applications, ETL and Hadoop<\/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:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\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:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/\"},\"author\":{\"name\":\"Tim King\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"headline\":\"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund\",\"datePublished\":\"2014-11-11T14:43:40+00:00\",\"dateModified\":\"2014-11-11T22:03:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/\"},\"wordCount\":522,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg\",\"articleSection\":[\"Data Integration News\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/\",\"name\":\"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund &#187; Best Data Integration Vendors, News &amp; Reviews for Big Data, Applications, ETL and Hadoop\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg\",\"datePublished\":\"2014-11-11T14:43:40+00:00\",\"dateModified\":\"2014-11-11T22:03:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg\",\"width\":600,\"height\":270,\"caption\":\"Data Integration Provides Key Step Enabling University to Analyze Endowment Fund\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Best Data Integration Vendors, News &amp; Reviews for Big Data, Applications, ETL and Hadoop\",\"description\":\"Data Integration Buyers Guide and Best Practices\",\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\",\"name\":\"Solutions Review\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"width\":225,\"height\":90,\"caption\":\"Solutions Review\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund &#187; Best Data Integration Vendors, News &amp; Reviews for Big Data, Applications, ETL and Hadoop","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:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/","twitter_misc":{"Written by":"Tim King","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/"},"author":{"name":"Tim King","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"headline":"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund","datePublished":"2014-11-11T14:43:40+00:00","dateModified":"2014-11-11T22:03:59+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/"},"wordCount":522,"commentCount":0,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg","articleSection":["Data Integration News"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/","url":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/","name":"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund &#187; Best Data Integration Vendors, News &amp; Reviews for Big Data, Applications, ETL and Hadoop","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg","datePublished":"2014-11-11T14:43:40+00:00","dateModified":"2014-11-11T22:03:59+00:00","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2014\/11\/Data-Integration-Provides-Key-Step-Enabling-University-to-Analyze-Endowment-Fund.jpg","width":600,"height":270,"caption":"Data Integration Provides Key Step Enabling University to Analyze Endowment Fund"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/data-integration-provides-key-step-enabling-university-to-analyze-3-2-billion-endowment-fund\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"Data Integration Provides Key Step Enabling University to Analyze $3.2 Billion Endowment Fund"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Best Data Integration Vendors, News &amp; Reviews for Big Data, Applications, ETL and Hadoop","description":"Data Integration Buyers Guide and Best Practices","publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/solutionsreview.com\/data-integration\/#organization","name":"Solutions Review","url":"https:\/\/solutionsreview.com\/data-integration\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","width":225,"height":90,"caption":"Solutions Review"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/726"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/comments?post=726"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/726\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/728"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}