function loadProviders(connectionType) {
  var source_categories = [
    {"id":"accounting", "label": "Accounting", "items": []},
    {"id":"collaboration", "label": "Collaboration", "items": []},
    {"id":"crmerp", "label": "CRM & ERP", "items": []},
    {"id":"database", "label": "Database", "items": []},
    {"id":"ecommerce", "label": "E-Commerce", "items": []},
    {"id":"file", "label": "File & API Integration", "items": []},
    {"id":"marketing", "label": "Marketing", "items": []},
    {"id":"social", "label": "Social", "items": []},
    {"id":"other", "label": "Other", "items": []}
  ];

  var destination_categories = [
    {"id":"relational", "label": "Relational Databases", 
        "items": [
            { 
                "name":"Access",
                "id": "access",
                "helpurl": "Access-Destination.html"
            },
            { 
                "name":"Azure SQL Database",
                "id": "azuresqldatabase",
                "helpurl": "Azure-SQL-Destination.html"
            },
            { 
                "name":"DB2",
                "id": "db2",
                "helpurl": "DB2-Destination.html"
            },
            { 
                "name":"Google Cloud SQL",
                "id": "googlecloudsql",
                "helpurl": "Google-Cloud-SQL-Destination.html"
            },
            { 
                "name":"Oracle",
                "id": "oracle",
                "helpurl": "Oracle-Destination.html"
            },
            { 
                "name":"SQL Server",
                "id": "sqlserver",
                "helpurl": "SQL-Server-Destination.html"
            }
        ]},
    {"id":"datawarehouse", "label": "Data Warhouses", "items": []},
    {"id":"nosql", "label": "NoSQL Databases", "items": []}
  ];

  var loadView = function(items, categories) {
    for(var i = 0; i < items.length; i++) {
      categories.forEach(category => {
        if(items[i].keywords.indexOf(category.id) >= 0) {
          if(category.id == "relational") {
            var pos = -1;
            for(var j = 0; j < category.items.length; j++) {
              if(items[i].id < category.items[j].id) {
                pos = j;
              }
            }
            if(pos > 0) {
              category.items.splice(pos, 0, items[i]);
            } else {
              category.items.push(items[i]);
            }
          } else {
            category.items.push(items[i])
          }
        }
      });
    }

    var view = $("#page-content");
    for(var i = 0; i < categories.length; i++) {
      var categoryHtml = $($("#providerlist_template").html());
      categoryHtml.find(".keyword-title").text(categories[i].label);
      for(var j = 0; j < categories[i].items.length; j++) {
        var itemHtml = $($("#driver_template").html());
        itemHtml.find("a").attr("href",categories[i].items[j].helpurl);
        itemHtml.find(".thumbnail").append("<span class='app-icon app-icon-" + categories[i].items[j].id.toLowerCase() +"'></span>").append("<div class='driver-title'>"+ categories[i].items[j].name + "</div>");
        categoryHtml.append(itemHtml);
      }
      view.append(categoryHtml);    
    }    
  };

  $.ajax({
    dataType:"json",
    type: "GET",
    data: {"@json":"true", "ConnectionType": connectionType },
    url:"../../src/listProviders.rsb" 
  }).done(function(data,textstatus,jqXHR) {
    var results = data["items"];
    if(connectionType == "source") {
      loadView(results, source_categories);
    } else if (connectionType == "destination") {
      loadView(results, destination_categories);
    }
  });
}