{"id":5630,"date":"2020-05-11T12:46:48","date_gmt":"2020-05-11T10:46:48","guid":{"rendered":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/?p=5630"},"modified":"2020-05-11T12:46:48","modified_gmt":"2020-05-11T10:46:48","slug":"tms-6","status":"publish","type":"post","link":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/2020\/05\/11\/tms-6\/","title":{"rendered":"Integrating Multiple Data Sources in a TMS"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\"><strong><em>Q: What are some of the data management challenges to expect in a transportation management system (TMS)?<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\"><strong>A:<\/strong>The most important thing is to decide what data you want\/need, which trading partner has it, and how you will obtain it in a format that will be required for standardization of reporting and data mining.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">Typically, for a TMS to obtain pertinent data elements, it requires integrating with numerous trading partners including carriers, PO management systems, customers&#8217; ERP systems, WMS, visibility platforms, loadboards, accounting systems, insurance providers, other TMS\/brokers, and more. Data from these sources can be delivered in a variety of methods and formats.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">The development of a database schema and an entity relationship model to define and enumerate logical relationships between the data entities is needed. Normalizing the data to the lowest common denominator and working your way up will allow you to effectively integrate disparate data sources.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\"><strong><em>Q: How do you address the issue of dealing with different data sources?<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\"><strong>A:<\/strong> Data integration in the purest sense is about carefully and methodically blending data from different sources, making it more comprehensive and therefore more useful and valuable than it was before.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">To be successful, you need to be flexible in the method and formats of the delivery and receipt of data. Exchanging information from only one method or format limits your trading partners and can limit the amount of data available in the data warehouse.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">Your data sharing technology needs to consider:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #0000ff;\">The types of data and the size of the data sets that are shared<\/span><\/li>\n<li><span style=\"color: #0000ff;\">The data processing services and tools that are required to maintain or use the data<\/span><\/li>\n<li><span style=\"color: #0000ff;\">The technical capabilities and skills of data users and data providers<\/span><\/li>\n<li><span style=\"color: #0000ff;\">The types and levels of data and access security that are required<\/span><\/li>\n<li><span style=\"color: #0000ff;\">The software and hardware required by network users<\/span><\/li>\n<li><span style=\"color: #0000ff;\">The level of effort and cost to develop and operate the exchange network<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">The answers to questions such as these address the overall feasibility of the data exchange network from a cost-effectiveness and likelihood of success perspective.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\"><strong><em>Q: What advice do you have for managing the integration?<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\"><strong>A:<\/strong> Be flexible. Don&#8217;t be too rigid with your methods of communication or formats. Play to your trading partners&#8217; strengths by utilizing the method they use that best meets your requirements.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">For instance, the current trend in sharing carrier data is using APIs; however it is still important to be able to utilize other traditional methods such as EDI and flat file exchanges for quoting, tendering, tracking, and invoice data since some carriers still utilize EDI vs API. Without EDI or some other form of data exchange, you would be excluding data from those carriers, leaving an unacceptable void of data. As methods and formats of data exchange continue to evolve, a strategy that can accommodate a variety of means to manage the multitude of sources is prudent.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"mailto:ken@saastransportation.com?subject=Your Article on InboundLogistics.com\"><img class=\"author-image alignleft\" src=\"https:\/\/resources.inboundlogistics.com\/userfiles\/ThoughtLeaders_KenPehanick_0419.jpg\" \/>Ken Pehanick<\/a>, President and CEO, <a href=\"http:\/\/www.saastransportation.com\">SaaS Transportation<\/a>, 844-722-7763<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Source: <a href=\"https:\/\/www.inboundlogistics.com\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.inboundlogistics.com<\/a><\/p>\n<h3 style=\"text-align: center;\"><a href=\"https:\/\/advancedfleetmanagementconsulting.com\/eng\/consultancy\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>CUT COTS OF THE FLEET WITH OUR AUDIT PROGRAM<\/strong><\/a><\/h3>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/advancedfleetmanagementconsulting.com\/eng\/consultancy\/\"><img loading=\"lazy\" class=\"aligncenter wp-image-5377\" src=\"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-content\/uploads\/sites\/3\/2020\/04\/nueva-ley-auditoria.jpg\" sizes=\"(max-width: 858px) 100vw, 858px\" srcset=\"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-content\/uploads\/sites\/3\/2020\/04\/nueva-ley-auditoria.jpg 2000w, https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-content\/uploads\/sites\/3\/2020\/04\/nueva-ley-auditoria-300x200.jpg 300w, https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-content\/uploads\/sites\/3\/2020\/04\/nueva-ley-auditoria-1024x682.jpg 1024w\" alt=\"\" width=\"858\" height=\"572\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">The audit is a key tool to know the overall status and provide the analysis, the assessment, the advice, the suggestions and the actions to take in order to cut costs and increase the efficiency and efficacy of the fleet. We propose the following fleet management audit.<\/p>\n<h3 style=\"text-align: center;\"><a href=\"https:\/\/advancedfleetmanagementconsulting.com\/eng\/consultancy\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>FLEET MANAGEMENT AUDIT<\/strong><\/a><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>Q: What are some of the data management challenges to expect in a transportation management system (TMS)? A:The most important thing is to decide what data you want\/need, which trading partner has it, and how you will obtain it in a format that will be required for standardization of reporting and data mining. Typically, for&#8230;<\/p>\n","protected":false},"author":3,"featured_media":5631,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"tags":[121],"_links":{"self":[{"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/posts\/5630"}],"collection":[{"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/comments?post=5630"}],"version-history":[{"count":1,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/posts\/5630\/revisions"}],"predecessor-version":[{"id":5632,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/posts\/5630\/revisions\/5632"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/media\/5631"}],"wp:attachment":[{"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/media?parent=5630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/categories?post=5630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/advancedfleetmanagementconsulting.com\/eng\/wp-json\/wp\/v2\/tags?post=5630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}