CINXE.COM
CKAN Development
<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8"/><meta name="viewport" content="width=device-width"/><link rel="apple-touch-icon" sizes="180x180" href="/assets/images/favicon/apple-touch-icon.png"/><link rel="icon" type="image/png" sizes="32x32" href="/assets/images/favicon/favicon-32x32.png"/><link rel="icon" type="image/png" sizes="16x16" href="/assets/images/favicon/favicon-16x16.png"/><link rel="manifest" href="/assets/images/favicon/site.webmanifest"/><link rel="mask-icon" href="/assets/images/favicon/safari-pinned-tab.svg" color="#5bbad5"/><meta name="msapplication-TileColor" content="#da532c"/><meta name="theme-color" content="#ffffff"/><meta name="twitter:card" content="summary_large_image"/><meta name="twitter:site" content="https://www.datopian.com"/><meta property="twitter:title" content="CKAN Development"/><meta name="twitter:creator" content="@datopian"/><meta name="twitter:image" content="https://www.datopian.com/assets/images/layout/datopian_logo.webp"/><meta property="twitter:description" content="Don’t change your processes to fit a new technology. Integrate existing workflows for a solution that works around you."/><title>CKAN Development</title><meta name="robots" content="index,follow"/><meta name="description" content="Don’t change your processes to fit a new technology. Integrate existing workflows for a solution that works around you."/><meta property="og:title" content="CKAN Development"/><meta property="og:description" content="Don’t change your processes to fit a new technology. Integrate existing workflows for a solution that works around you."/><meta property="og:url" content="https://www.datopian.com/solutions/ckan/development"/><meta property="og:type" content="website"/><meta property="og:image" content="https://www.datopian.com/assets/images/layout/datopian_logo.webp"/><meta property="og:image:alt" content="CKAN Development"/><meta property="og:image:width" content="1200"/><meta property="og:image:height" content="627"/><link rel="canonical" href="https://www.datopian.com/solutions/ckan/development"/><meta name="next-head-count" content="27"/><link rel="preconnect" href="https://fonts.gstatic.com" crossorigin /><link rel="preload" href="/_next/static/css/444be6258f6ea379.css" as="style"/><link rel="stylesheet" href="/_next/static/css/444be6258f6ea379.css" data-n-g=""/><noscript data-n-css=""></noscript><script defer="" nomodule="" src="/_next/static/chunks/polyfills-c67a75d1b6f99dc8.js"></script><script src="/_next/static/chunks/webpack-e3a1f19d8b5e52ba.js" defer=""></script><script src="/_next/static/chunks/framework-d583295f3144c491.js" defer=""></script><script src="/_next/static/chunks/main-5c819f7883ab7e34.js" defer=""></script><script src="/_next/static/chunks/pages/_app-fc26093f766532ca.js" defer=""></script><script src="/_next/static/chunks/9927-321af95592cb4622.js" defer=""></script><script src="/_next/static/chunks/4785-19005deb806cd91e.js" defer=""></script><script src="/_next/static/chunks/pages/solutions/ckan/development-65c71b95fb098890.js" defer=""></script><script src="/_next/static/OlPi-OoS2ZoHlelYrxI5_/_buildManifest.js" defer=""></script><script src="/_next/static/OlPi-OoS2ZoHlelYrxI5_/_ssgManifest.js" defer=""></script><style data-href="https://fonts.googleapis.com/css2?family=Inter:wght@200;300;400;500;600;700;800&family=Source+Code+Pro:wght@600&display=swap">@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuDyfMZs.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuOKfMZs.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuLyfMZs.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuI6fMZs.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuGKYMZs.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuFuYMZs.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcCO3FwrK3iLTeHuS_nVMrMxCp50SjIw2boKoduKmMEVuDyYMZs.woff) format('woff')}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXhM0.woff) format('woff')}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:200;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:300;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:400;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:500;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:700;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2JL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa0ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2ZL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+1F00-1FFF}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa2pL7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa25L7W0Q5n-wU.woff2) format('woff2');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Inter';font-style:normal;font-weight:800;font-display:swap;src:url(https://fonts.gstatic.com/s/inter/v18/UcC73FwrK3iLTeHuS_nVMrMxCp50SjIa1ZL7W0Q5nw.woff2) format('woff2');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtMRrSlcZZJmOpwVS.woff) format('woff');unicode-range:U+0460-052F,U+1C80-1C8A,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtM1rSlcZZJmOpwVS.woff) format('woff');unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtMVrSlcZZJmOpwVS.woff) format('woff');unicode-range:U+1F00-1FFF}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtMprSlcZZJmOpwVS.woff) format('woff');unicode-range:U+0370-0377,U+037A-037F,U+0384-038A,U+038C,U+038E-03A1,U+03A3-03FF}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtMZrSlcZZJmOpwVS.woff) format('woff');unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtMdrSlcZZJmOpwVS.woff) format('woff');unicode-range:U+0100-02BA,U+02BD-02C5,U+02C7-02CC,U+02CE-02D7,U+02DD-02FF,U+0304,U+0308,U+0329,U+1D00-1DBF,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF}@font-face{font-family:'Source Code Pro';font-style:normal;font-weight:600;font-display:swap;src:url(https://fonts.gstatic.com/s/sourcecodepro/v23/HI_diYsKILxRpg3hIP6sJ7fM7PqPMcMnZFqUwX28DBKXtMlrSlcZZJmOpw.woff) format('woff');unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD}</style></head><body><div id="__next"><script>!function(){var d=document.documentElement,c=d.classList;c.remove('light','dark');d.style.colorScheme = 'light';c.add('light')}()</script><div> <ol vocab="https://schema.org/" typeof="BreadcrumbList" style="display: none"> <li property="itemListElement" typeof="ListItem"> <a property="item" typeof="WebPage" href=https://www.datopian.com/solutions> <span property="name"> Solutions </span> </a> <meta property="position" content="1"/> </li> <li property="itemListElement" typeof="ListItem"> <a property="item" typeof="WebPage" href=https://www.datopian.com/solutions/ckan/development> <span property="name"> Ckan </span> </a> <meta property="position" content="2"/> </li> </ol> </div></div><script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"meta":{"title":"CKAN Development","description":"Don’t change your processes to fit a new technology. Integrate existing workflows for a solution that works around you.","showSidebar":false,"showToc":false,"showComments":false,"showEditLink":false,"urlPath":""},"casestudies":[{"title":"Open Energy Data Initiative: SSEN's Digital Transformation (A technical case study)","created":"2024-04-22T00:00:00.000Z","layout":"article","authors":["Lucas Bispo","Yoana Popova","Sagar Ghimire"],"avatarUrl":["/assets/images/team/Lucas-Bispo.png","/assets/images/team/Yoana-Popova.jpg","/assets/images/team/Sagar-Ghimire.jpg"],"image":"/assets/images/case-studies/2024-04-22-tech-case-study-ssen/ssen.webp","industries":["Energy"],"regions":["Europe"],"services":["PortalJS","CKAN Development","Data Strategy"],"usecases":["Open Data Portal","Data Catalog"],"description":"Discover how SSEN leveraged open energy data to enhance grid management and operational efficiency. Explore the advanced data solutions driving SSEN's digital transformation.","brief":"The Scottish and Southern Electricity Networks (SSEN) Data Portal project is an innovative digital transformation initiative aimed at enhancing power distribution management. Utilizing advanced technologies like [PortalJS](https://www.portaljs.org) and [CKAN](https://www.datopian.com/solutions/ckan), the portal effectively manages and shares large datasets, improving operational efficiency and user engagement.","problem":"SSEN faced challenges in efficiently managing, sharing, and accessing extensive data across its power distribution network, which is crucial for operational excellence and customer satisfaction.","need":"There was a need for a robust platform capable of handling large volumes of data with high interoperability and security standards to improve data accessibility and streamline operations.","solution":"Datopian implemented a robust and comprehensive solution for SSEN by creating a decoupled architecture that utilizes [PortalJS](https://portaljs.org) for the frontend to enhance user interface responsiveness and CKAN v2.10 for the backend to manage data effectively. This setup is augmented with several CKAN extensions such as ckanext-dcat for DCAT support to improve interoperability, ckanext-scheming for customized schema configurations, ckanext-showcase to highlight key datasets, ckanext-googleanalytics for in-depth usage analytics, and ckanext-noanonaccess to enhance security by restricting anonymous access. Additionally, an ETL workflow using Prefect and BigQuery facilitates the efficient handling and querying of large data sets, including smart meter data, ensuring that SSEN can manage data flows from over 3.8 million endpoints effectively. This solution not only improves operational efficiency but also aligns with sustainable energy management practices.","tech":["CKAN","PortalJS","TypeScript","Postgre","Nextjs","Python","DCAT"],"providers":["Datopian"],"client":"Scottish \u0026 Southern Electricity Networks","period":"July 2023 - present","work":"[SSEN Open Data Portal](https://data.ssen.co.uk)","date":"2024-04-22T00:00:00.000Z","slug":"enhancing-energy-efficiency-scottish-southern-electricity-networks","urlPath":"showcase/case-studies/enhancing-energy-efficiency-scottish-southern-electricity-networks","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":6},{"title":"Driving Innovation: AIR’s Data Portal for Fighting Corruption","created":"2025-01-21T00:00:00.000Z","layout":"article","authors":["Joao Demenech"],"avatarUrl":"/assets/images/team/Joao-Demenech.jpg","image":"/assets/images/case-studies/2025-01-21-case-study-air/AIR.webp","industries":["Finance","Government/Public Sector","International Organization","Non-Profit/NGO"],"regions":["Global"],"services":["PortalJS","Custom Data Portal","Data Engineering"],"usecases":["Open Data Portal","ETL Pipelines"],"description":"Discover how Datopian developed a centralized, bilingual data portal for AIR’s TechSprint, enabling seamless access to datasets, problem statements, and metadata tools for impactful anti-corruption solutions.","brief":"The Alliance for Innovative Regulation (AIR) hosted a TechSprint aimed at enhancing government transparency to combat corruption. To support participants, a centralized, bilingual data portal was developed by Datopian, offering seamless access to datasets, integrated problem statements, and advanced metadata management features. This enabled participants to create impactful, data-driven prototypes.","problem":"TechSprint aimed to tackle corruption by improving government transparency through innovative digital tools. However, participants faced challenges accessing and utilizing the necessary datasets and problem statements in a structured and user-friendly way. The lack of a centralized, searchable platform hindered the ability to link data with solutions effectively.","need":"The project required a data portal that could centralize datasets from multiple sources, provide metadata-rich pages with data previews and version history, support bilingual content for English and Spanish speakers, and integrate problem statements into a cohesive and accessible platform.","solution":"Datopian created a robust data portal that centralized all required datasets in a searchable catalog, provided bilingual support across metadata and static content, and seamlessly integrated problem statements using programmatically indexed markdown files. With advanced metadata management powered by GitHub and Frictionless Data Packages, the portal enabled participants to efficiently access and utilize the resources necessary for building high-quality prototypes, advancing TechSprint's mission of promoting transparency and fighting corruption.","tech":["PortalJS","MarkdownDB","GitHub","Python","Frictionless-Data"],"providers":["Datopian"],"client":"[Alliance for Innovative Regulation (AIR)](https://regulationinnovation.org/)","period":"June 2024 - August 2024","work":"Not disclosed","date":"2025-01-21T00:00:00.000Z","slug":"driving-innovation-data-portal-for-fighting-corruption","urlPath":"showcase/case-studies/driving-innovation-data-portal-for-fighting-corruption","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":5},{"title":"Open Government Data: Revamping OpenSpending for Fiscal Transparency","created":"2023-10-02T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2023-10-02-case-study-gift/ibrahim-boran-r0zrjWheW2g-unsplash.jpg","industries":["International Organization","Finance"],"regions":["Global"],"services":["PortalJS","Data Strategy","CKAN Consultancy","CKAN Development","Digital Transformation","UX/UI Design","Custom Data Portal","Data Engineering"],"usecases":["Open Data Portal"],"description":"Explore the OpenSpending revamp enhancing fiscal transparency and open government data. Discover a modern data platform that improves data integrity, accessibility, and citizen engagement.","brief":"In a strategic collaboration, Datopian and the [Global Initiative for Fiscal Transparency (GIFT)](https://fiscaltransparency.net/) successfully revamped the [OpenSpending platform](https://openspending.org/) delivering an end-to-end solution that modernized its capabilities to serve as an effective Open Government Data platform. The partnership elevated global fiscal transparency, accountability, and citizen engagement by enhancing data integrity, accessibility, and usability.","problem":"[The OpenSpending platform](https://openspending.org/) had grown obsolete, lacking the capacity to address the modern demands of fiscal transparency, open governance, and public data access. It lacked modern capabilities for data integrity, schema standardization, and user management, posing a challenge for GIFT and its complex stakeholder environment.","need":"An updated, sustainable platform was urgently needed to serve governments, civil society, and financial institutions globally. The solution had to accommodate historical data, offer flexible user management, support effortless data sharing, and allow dynamic schema modifications, all while ensuring a user-friendly interface.","solution":"Harnessing cutting-edge technologies Datopian engineered [OpenSpending](https://openspending.org/) - a streamlined, user-friendly platform. The portal combines seamless data migration, robust error reporting, easy data schema modification, and automated dataset merging. This new portal sets a new gold standard in how governments and public entities share, manage, and derive value from data, thereby fostering greater transparency and accountability.","tech":["PortalJS","CKAN","Apollo","React","Cypress","GCloud"],"providers":["Datopian"],"client":"[Global Initiative for Fiscal Transparency (GIFT)](https://fiscaltransparency.net/)","period":"October 2020 – June 2022","date":"2023-10-02T00:00:00.000Z","slug":"case-study-gift","urlPath":"showcase/case-studies/case-study-gift","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":7},{"title":"Open Energy Data: SSEN's Innovative CKAN Data Portal","created":"2023-10-09T00:00:00.000Z","layout":"article","authors":["Lucas Bispo","Yoana Popova"],"avatarUrl":"/assets/images/team/Lucas-Bispo.png","image":"/assets/images/case-studies/2023-10-09-empowering-energy-sector-ckan-portaljs-scottish-southern-electricity-networks/Slough_SSEN-3.webp","industries":["Energy"],"regions":["Europe"],"services":["PortalJS","CKAN Development","CKAN Features","Data Strategy"],"usecases":["Open Data Portal","Data Catalog"],"description":"Explore how SSEN leverages CKAN and PortalJS for open energy data management. Learn about their innovative data portal enhancing transparency, accessibility, and stakeholder engagement.","brief":"Datopian partnered with [Scottish Southern Electricity Networks (SSEN)](https://www.ssen.co.uk/), a leading Distribution Network Operator serving over 3.8 million homes and businesses across central southern England and northern Scotland. Our collaborative project centered on building a Data Portal to advance SSEN's strategic goals of innovation, partnership, and a sustainable energy future.","problem":"SSEN faced the challenge of efficiently managing and sharing large volumes of complex data with multiple stakeholders in an increasingly data-driven industry. The lack of a unified data-sharing platform not only complicated efficient data management but also constrained stakeholder engagement, creating a bottleneck for innovation and strategic partnerships.","need":"Recognizing the essential role of data transparency and accessibility, SSEN identified a critical need for a robust Data Portal. This platform would not only democratize access to key energy network datasets but also serve a diverse array of stakeholders, from local governments to energy suppliers and advocates for net-zero carbon emissions. This need coherently aligns with SSEN's overarching objectives, including the promotion of a sustainable energy future.","solution":"We deployed a robust, user-centric Data Portal utilizing CKAN and PortalJS technologies. The platform is equipped with specialized geospatial data capabilities, a customizable and visually engaging user interface, and efficient data management features. It facilitates streamlined data dissemination, allowing both the public and various stakeholders to effortlessly access critical data, thereby elevating SSEN's commitment to transparency and stakeholder engagement.","tech":["PortalJS","CKAN","JavaScript","Postgre","Nextjs","Python","DCAT"],"providers":["Datopian"],"client":"[Scottish \u0026 Southern Electricity Networks](https://ssen.co.uk)","period":"July 2023 - present","work":"[SSEN Data Portal](https://data.ssen.co.uk)","date":"2023-10-09T00:00:00.000Z","slug":"empowering-energy-sector-ckan-portaljs-scottish-southern-electricity-networks","urlPath":"showcase/case-studies/empowering-energy-sector-ckan-portaljs-scottish-southern-electricity-networks","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":7},{"title":"Organization for Economic Co-operation and Development","created":"2020-11-10T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2020-11-10-client-case-study-oecd/community.bc1a7fdb.webp","industries":["International Organization"],"regions":["Global"],"services":["Digital Transformation","CKAN Consultancy","Data Strategy"],"usecases":["Internal Data Management"],"description":"The project offers a compelling case for how Datopian created a custom-built discovery portal and search engine that streamlined processes, enabling a Fortune 500 pharmaceutical company to significantly improve dataset access and collaboration for their global research and development teams.","brief":"The project offers a compelling case for how Datopian created a custom-built discovery portal and search engine that streamlined processes, enabling a Fortune 500 pharmaceutical company to significantly improve dataset access and collaboration for their global research and development teams.","problem":"The OECD faced the challenge of transitioning their data hub for official statistics called .Stat Suite to open-source software to accommodate users' increasing demand for seamless integration with existing systems, while ensuring the software\u0026apos;s technical complexity was effectively addressed. This change marked the most technically complex iteration of the software, and OECD needed expert guidance to ensure a smooth and successful transition.","need":"OECD sought a partner with a strong background in open-source software to help them move towards a fully open-source model. They aimed to learn from similar projects and benefit from expertise in areas such as documentation, continuous integration/delivery, and community engagement.","solution":"We collaborated with the OECD, providing expert guidance on their open-source transition journey. By conducting workshops and generating a detailed report of recommendations, Datopian advised the SIS-CC on various aspects from community engagement to technical codebase management. Consequently, the .Stat Suite was transformed with the implementation of full DevOps operations, leveraging microservices architecture, and adopting technologies such as Docker and Kubernetes for enhanced scalability and deployment efficiency. This strategic approach enabled the OECD to empower a growing open-source community and deliver a more accessible, user-friendly data management solution. As a result, OECD successfully transitioned to a microservices-based, open-source model, lowering the barrier for new developers and enabling rapid deployment of the .Stat Suite in various environments.","tech":["CKAN","Python","JsonLD","SDMX","Docker","Kubernetes"],"providers":["Datopian"],"client":"[Organisation for Economic Co-operation and Development (OECD)](https://www.oecd.org/), [SIS-CC](https://siscc.org/stat-suite/)","period":"2018-2019","work":"","date":"2020-11-10T00:00:00.000Z","slug":"client-case-study-oecd","urlPath":"showcase/case-studies/client-case-study-oecd","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":3},{"title":"Open Data Denmark's Open Data Portal: Multilingual Support \u0026 Security","created":"2023/08/31","layout":"article","tags":["CKAN"],"authors":["Michael Polidori","Yoana Popova"],"avatarUrl":"/assets/images/team/Michael-Polidori.jpg","image":"/assets/images/case-studies/2023-09-07-case-study-open-data-denmark/nick-karvounis-unsplash.jpg","industries":["Government/Public Sector"],"regions":["Europe"],"services":["CKAN Development","UX/UI Design","CKAN Hosting \u0026 Support"],"usecases":["Open Data Portal"],"description":"A CKAN data portal with multilingual support, GDPR compliance, ISO/IEC 27001 standards, and WordPress integration for improved data transparency and public access.","brief":"We collaborated with [Open Data DK](https://opendata.dk), a Danish open data initiative, to modernize and upgrade their existing CKAN classic portal. We focused on enhancing usability, security, and multilingual support while integrating their blog content and streamlining their infrastructure.","problem":"[Open Data DK](https://opendata.dk) was operating on an aging CKAN classic portal that lacked a decoupled front end, making it less user-friendly. While they were satisfied with CKAN's data management, the need for an integrated CMS for blog and news updates and reduced infrastructure overhead was clear.","need":"[Open Data DK](https://opendata.dk) required a solution that would securely store data as per ISO/IEC 27001 and GDPR compliance standards. They also needed Civil Personal Registration (CPR) validation to protect sensitive names and addresses, seamless integration with WordPress blogs, and WCAG 2.1 compliance for accessibility.","solution":"We upgraded [Open Data DK](https://opendata.dk/)'s portal to exceed initial criteria, integrating it with Google Cloud for ISO/IEC 27001 compliance and adding a user-configurable GDPR-friendly popup to manage data collection preferences. A custom CKAN extension ensures Civil Personal Registration data integrity. WordPress posts and WCAG 2.1 standards enrich user experience. Decoupling admin and public UIs enhances security. We automated metadata translations through an [IBM’s Watson](https://www.ibm.com/cloud/watson-language-translator)-driven extension, supporting Danish, English, and French. We modernized the front end by leveraging our [frontend-v2](https://github.com/datopian/frontend-v2). Hosting was migrated to Datopian, and we offer continuous deployment and support. The result is a secure, accessible, and powerful platform that keeps users updated while exploring various open data topics.","tech":["TypeScript","Python","CKAN","Postgre","Redis","Solr","uWSGI","Watson"],"providers":["Datopian"],"client":"[Open Data DK](https://opendata.dk/)","period":"August 2018 - present","work":"[Open Data DK](https://opendata.dk)","date":"2023/08/31","slug":"case-study-open-data-denmark","urlPath":"showcase/case-studies/case-study-open-data-denmark","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":7},{"title":"Internal Data Catalog: A Journey to Better Data Management with CKAN","created":"2024-07-02T00:00:00.000Z","layout":"article","authors":["Michael Polidori"],"avatarUrl":"/assets/images/team/Michael-Polidori.jpg","image":"/assets/images/case-studies/2024-07-02-better-data-management-ckan/image20-unsplash.jpg","industries":["Energy","Environment","Public Health"],"regions":["Europe","North America","South Asia"],"services":["CKAN Consultancy","CKAN Development","CKAN Features","CKAN Hosting \u0026 Support","Custom Data Portal","UX/UI Design"],"usecases":["Data Catalog","Internal Data Management"],"description":"Discover how a global firm improved internal data management with a CKAN-powered data catalog. Explore its seamless integration and enhanced accessibility.","brief":"Datopian collaborated with a global consulting and engineering company to develop a customized data management portal using CKAN, addressing specific requirements to streamline data accessibility and usability for their global team.","problem":"Client's in-house data catalog solution was overly complex and technical, making it unsuitable for their users' needs. They required a simpler, user-friendly solution to manage and share datasets efficiently across their organization.","need":"The Client needed a straightforward data catalog to facilitate easy inter-organizational dataset sharing, with features including data access permissions, usage analytics, Azure SSO login, automated Azure user and organization synchronization, and custom dataset metadata schemas.","solution":"Datopian designed and implemented a CKAN-based data portal with a customized UI, integrated Azure SSO, and synchronized user and organization data from Azure to CKAN. The solution included custom metadata schemas, analytics tracking, and an intuitive interface, enhancing data management and accessibility.","tech":["CKAN","Python","JavaScript","Postgre","Redis","Solr","Azure"],"providers":["Datopian"],"client":"Not disclosed due to contractual obligations","period":"January 2024 - Present","work":"","date":"2024-07-02T00:00:00.000Z","slug":"better-data-management-ckan","urlPath":"showcase/case-studies/better-data-management-ckan","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":6},{"title":"Open Data Northern Ireland","created":"2020-11-10T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2020-11-10-client-case-study-open-data-northern-ireland/photo-1585580554602-ff1820c43788.webp","industries":["Government/Public Sector"],"regions":["Europe"],"services":["CKAN Features"],"usecases":["Open Data Portal"],"description":"The Open Data Northern Ireland (NI) portal was developed as part of the Digital NI initiative. The government of Northern Ireland is committed to open data because they recognise that opening up data increases transparency, accountability and efficiency of the public sector. Moreover, they welcome the opportunity presented by open data to encourage new commercial activities and encourage economic growth.","tech":["PortalJS","CKAN","TypeScript"],"providers":["Datopian"],"client":"[Open Data Northern Ireland (NI)](https://www.opendatani.gov.uk/)","period":"December 2015 - ongoing","date":"2020-11-10T00:00:00.000Z","slug":"client-case-study-open-data-northern-ireland","urlPath":"showcase/case-studies/client-case-study-open-data-northern-ireland","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":4},{"title":"From Socrata to CKAN: A Seamless Data Portal Migration","created":"2024-04-22T00:00:00.000Z","layout":"article","authors":["Luccas Mateus","Yoana Popova"],"avatarUrl":["/assets/images/team/Luccas-Mateus.jpg","/assets/images/team/Yoana-Popova.jpg"],"tags":["CKAN"],"image":"/assets/images/case-studies/2024-04-22-case-study-santa-monica/santa-monica-sign.webp","industries":["Government/Public Sector"],"regions":["Americas"],"offerings":["CKAN"],"services":["CKAN Development","Custom Data Portal","UX/UI Design","Migration from Socrata to CKAN"],"usecases":["Open Data Portal","Data Catalog"],"description":"Explore Santa Monica's successful migration from Socrata to CKAN. Learn how this transition enhanced data control, cost-efficiency, and flexibility within a 30-day deadline.","brief":"The City of Santa Monica collaborated with Datopian to transition their data portal from the proprietary [Socrata platform](https://www.tylertech.com/products/data-insights/open-data-platform) to the open-source [CKAN](https://www.datopian.com/solutions/ckan) platform. The move aimed to gain cost-efficiency, control, and flexibility while adhering to a 30-day deadline.","problem":"Santa Monica faced the issue of high subscription costs and underutilization of the features provided by the [Socrata platform](https://www.tylertech.com/products/data-insights/open-data-platform). Moreover, there was a pressing deadline as their existing Socrata contract was set to be terminated, necessitating a rapid migration of data.","need":"The City urgently required a more cost-effective, flexible, and customizable data portal solution. They required the new CKAN instance to be hosted on their own AWS account, fully migrated, and operational within 30 days. The platform needed to ensure seamless data migration, facilitate easy access to civic data, and allow for future enhancements and integrations.","solution":"Leveraging our specialized know-how in data management, Datopian effectively transitioned Santa Monica's data portal to a more cost-efficient CKAN-based solution hosted on AWS. Navigating tight deadlines and complex data migration tasks, we deployed a fully operational portal tailored to the city's specific needs while aligning with budget constraints. This cost-effective solution empowers Santa Monica with greater control over their data assets, thus reinforcing their commitment to data transparency and accessibility.","tech":["CKAN","Python","GraphQL","Hasura","Postgre","AWS","Actions","Kubernetes"],"providers":["Datopian"],"client":"[City of Santa Monica](https://www.santamonica.gov/)","period":"October 2022 – November 2022","work":"[Data Santa Monica Gov](https://data.santamonica.gov/)","date":"2024-04-22T00:00:00.000Z","slug":"from-socrata-to-ckan-seamless-migration-city-of-santa-monica","urlPath":"showcase/case-studies/from-socrata-to-ckan-seamless-migration-city-of-santa-monica","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":5},{"title":"An Open Data Portal for the NHS Business Services Authority","created":"2022-04-18T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2022-04-18-open-data-portal-for-the-nhsbsa/patty-brito-Y-3Dt0us7e0-unsplash-scaled.webp","industries":["Government/Public Sector","Public Health"],"regions":["Europe"],"services":["CKAN Features","CKAN Development","CKAN Hosting \u0026 Support"],"usecases":["Open Data Portal"],"description":"The NHSBSA faced the challenge of efficiently managing and sharing vast amounts of health-related data across their organization, while ensuring easy access and discoverability for both internal and external stakeholders.","brief":"The project offers a compelling case for how Datopian\u0026apos;s cutting-edge solutions enabled the NHS Business Services Authority (NHSBSA) to create an efficient and user-friendly Open Data Portal, catering to their vision of improving customer experience and delivering real value.","problem":"The NHSBSA faced the challenge of efficiently managing and sharing vast amounts of health-related data across their organization, while ensuring easy access and discoverability for both internal and external stakeholders. To achieve this, they needed a scalable, user-friendly, and secure open data platform that could handle big data and improve overall data transparency in the healthcare sector.","need":"NHSBSA needed a platform with sufficient storage capacity, an SQL queryable API data endpoint, a data explorer extension for effective filtering and previewing, and a solution for handling large data files to support their commitment to making data freely available.","solution":"We implemented a powerful, tailored CKAN-based open data portal to cater to the NHSBSA\u0026apos;s specific requirements. The solution incorporated advanced technologies like BigQuery and Google Cloud Storage for efficient data management and handling of large datasets. Our team developed a user-friendly data explorer extension that enabled effective filtering, previewing, and downloading of resources, even for sizable files. Additionally, a customized data publishing UI allowed for direct uploads to the cloud, streamlining the data publishing process. A zipped upload function was also developed, along with tools for transparent audit trails and output logs of user activities. Our comprehensive solution enhanced the NHSBSA\u0026apos;s data discoverability, accessibility, and operational efficiency while promoting transparency and collaboration within the healthcare sector.","tech":["CKAN","Postgre","BigQuery","GCloud","Datapub","Airflow","Aircan","API"],"providers":["Datopian"],"client":"[NHS Business Services Authority (NHSBSA)](https://opendata.nhsbsa.net/)","period":"January 2020 - present","work":"","date":"2022-04-18T00:00:00.000Z","slug":"open-data-portal-for-the-nhsbsa","urlPath":"showcase/case-studies/open-data-portal-for-the-nhsbsa","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":4},{"title":"Scottish Cities Alliance: Case Study of collaboration","created":"2020-11-10T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2020-11-10-case-study-scottish-cities-alliance/photo-1552197680-0223a9065fa3-1024x683.webp","industries":["Government/Public Sector","Smart Cities"],"regions":["Europe"],"services":["CKAN Hosting \u0026 Support"],"usecases":["Open Data Portal"],"description":"The Alliance required an open-source open data portal that would not only drive innovation and reinforce their commitment to transparency but also enable the accessibility of datasets, enhance service quality, and foster data-driven decision-making in the Smart Cities Scotland project.","brief":"This project showcases how Datopian collaborated with the Scottish Cities Alliance to develop an Open Data platform, fueling the Smart Cities Scotland initiative, which leverages new technologies to transform city services and attract external investments across Scotland\u0026apos;s seven major cities.","problem":"Only two of the seven cities involved in the Smart Cities Scotland project had an open data platform. The need for a unified platform, rather than individual platforms, was essential for a cohesive and efficient approach to sharing and utilizing data.","need":"The Alliance required an open-source open data portal that would not only drive innovation and reinforce their commitment to transparency but also enable the accessibility of datasets, enhance service quality, and foster data-driven decision-making in the Smart Cities Scotland project. It was crucial to utilize open tools that offered flexibility, customization, and a collaborative experience, as this would further emphasize their program's commitment to openness.","solution":"Datopian, as a trusted partner in open-source data solutions, provided the Scottish Cities Alliance with a customized CKAN platform tailored to their unique needs. This innovative open data portal has successfully improved data accessibility and quality, driving smart city initiatives across Scotland. By leveraging the power of CKAN\u0026apos;s flexibility and collaborative features, the alliance has effectively transformed city services, maximizing the impact of data-driven decision-making and enhancing transparency in urban development.","tech":["CKAN","TypeScript","Python"],"providers":["Datopian"],"client":"[Scottish Cities Alliance](https://scottishcities.org.uk/)","period":"2017 - ongoing","date":"2020-11-10T00:00:00.000Z","slug":"case-study-scottish-cities-alliance","urlPath":"showcase/case-studies/case-study-scottish-cities-alliance","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":3},{"title":"Cost-Efficient and GDPR-Compliant: Datopian Migrates Open Data Denmark from Google Cloud to Hetzner","created":"2024-10-03T00:00:00.000Z","layout":"article","authors":["Anuar Ustayev"],"avatarUrl":"/assets/images/team/Anuar-Ustayev.jpg","image":"/assets/images/case-studies/2024-10-03-open-data-denmark-moving-from-GCP-to-hetzner-data-centers/quality-control.webp","industries":["Government/Public Sector"],"regions":["Europe"],"services":["CKAN Consultancy","CKAN Hosting \u0026 Support","Cloud Migration Services","Data Sovereignty Solutions","Infrastructure Provisioning Services"],"usecases":["Open Data Portal","Cloud Hosting"],"description":"Datopian migrated Open Data Denmark from Google Cloud Platform to Hetzner, ensuring data sovereignty, GDPR compliance, and reducing hosting costs by over 30%.","brief":"Open Data Denmark needed a more secure, cost-effective hosting solution for its national data portal. Datopian migrated the platform from [Google Cloud Platform (GCP)](https://cloud.google.com) to [Hetzner](https://www.hetzner.com/)’s German-based data centers, ensuring enhanced data sovereignty, reduced costs, and full compliance with EU regulations.","problem":"The Danish government faced increasing concerns about data privacy and sovereignty, particularly with non-European cloud providers like Google Cloud. Additionally, rising hosting costs with GCP were putting pressure on the budget for Open Data Denmark.","need":"Open Data Denmark required a reliable, European-based hosting solution that prioritized data sovereignty and compliance with GDPR, while also offering a more sustainable financial model for ongoing operations.","solution":"Datopian successfully migrated the portal from GCP to Hetzner, ensuring enhanced performance, reduced costs, and full compliance with GDPR and EU regulations.","tech":["CKAN","Python","ExpressJS","JavaScript","Postgre","Redis","Solr","Kubernetes (K3s)","Hetzner"],"providers":["Datopian"],"client":"Open Data Denmark","period":"July 2024 - Present","work":"[Open Data.dk](https://www.opendata.dk/)","date":"2024-10-03T00:00:00.000Z","slug":"open-data-denmark-moving-from-GCP-to-hetzner-data-centers","urlPath":"showcase/case-studies/open-data-denmark-moving-from-GCP-to-hetzner-data-centers","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":5},{"title":"An Open Data Platform for the U.S. Department of Education","created":"2022-06-13T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2022-06-13-an-open-data-platform-for-the-u-s-department-of-education/brett-jordan-kuEMUoDZepY-unsplash1.webp","description":"Building an Open Data Platform for the massive—and ever-growing—open data collection of Dept of Ed to allow easier organization, searchability, navigation, and usage of their data.","industries":["Government/Public Sector","Education"],"regions":["Americas"],"services":["CKAN Development","CKAN Features","CKAN Consultancy"],"usecases":["Open Data Portal","Data Catalog"],"brief":"Datopian (in partnership with CivicActions) have delivered a government-compliant Open Data Platform that revolutionizes data accessibility, navigation, and user engagement, fulfilling the United States Department of Education's need for a centralized, user-friendly data repository.","problem":"The problem faced by the United States Department of Education was the lack of a centralized location to organize, search, edit, and share their massive and ever-growing open data collection. As a result, it was difficult for inter-organizational Data Stewards, as well as the general public, to easily navigate and utilize the data.","need":"The Department of Education needed a solution that would allow for the easy organization, searchability, navigation, and usage of their data by a wide range of audiences, including researchers, teachers, government employees, and the general public. The project required a solution that would fulfill a broad set of criteria, including centralizing access to public data, providing a modern and intuitive interface for navigating data resources, allowing an easy search of public datasets by metadata, facilitating user engagement, and enabling analytics that allow the Department to answer questions, among others.","solution":"Datopian, in collaboration with CivicActions, developed a centralized Open Data Platform (ODP) that meets government standards and offers a feature-rich, user-friendly location for organizing, searching, editing, and sharing data, which can be accessed by users at any level. The platform collects metadata using web scrapers and ingests data from education-related organizations. Custom solutions were developed for managing users, approving data, and creating and editing dataset relationships. The ODP ensures compliance with the Government mandate on open data and supports standardized Project Open Data Schema, making data exchange simple and flexible.","tech":["CKAN","Python","Scrapy","DCAT","API"],"providers":["Datopian","[CivicActions](https://civicactions.com/)"],"client":"[U.S. Department of Education](https://www.ed.gov/)","period":"September 2018 - present","work":"[Department of Education ODP (Open Data Platform)](https://data.ed.gov/)","date":"2022-06-13T00:00:00.000Z","slug":"an-open-data-platform-for-the-u-s-department-of-education","urlPath":"showcase/case-studies/an-open-data-platform-for-the-u-s-department-of-education","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":6},{"title":"UAE's Open Data Portal: New CKAN Platform with Bilingual Features","created":"2023/08/31","layout":"article","categories":["Open Data Portal"],"tags":["CKAN"],"authors":["João Demenech","Yoana Popova"],"avatarUrl":"/assets/images/team/Joao-Demenech.jpg","image":"/assets/images/case-studies/2023-08-31-case-study-open-data-uae/UAE.webp","industries":["Government/Public Sector"],"regions":["Middle East"],"offerings":["CKAN","PortalJS"],"services":["PortalJS","UI/UX design","CKAN Features","CKAN Development","CKAN Hosting \u0026 Support","CKAN upgrade and database migration","DevOps"],"usecases":["Open Data Portal"],"description":"Best practices in open data and government data transparency: the CKAN portal, part of the UAE Open Data Initiative, features bilingual support and a CKAN upgrade, enhancing data transparency, user experience, and.","brief":"The [Federal Competitiveness and Statistics Centre](https://fcsc.gov.ae/) (FCSC) of the UAE partnered with Datopian to upgrade and enhance their existing [Open Data portal](https://bayanat.ae/). Rather than merely upgrading it, we opted for a ground-up redevelopment, retaining only the datasets from the original portal. The new platform, now accessible at https://opendata.fcsc.gov.ae, is designed to set new benchmarks in data quality, user engagement, and multifunctionality, positioning the UAE as a leader in the open data field. Experience the transformation by comparing the [old portal](https://bayanat.ae) and the new one at https://opendata.fcsc.gov.ae.","problem":"The existing open data portal, built on CKAN 2.6 and SiteCore, had limitations in usability, functionality, and user engagement. The platform lacked modern features like a compelling UI/UX design, dynamic charts, and content management integration. This made it less appealing and usable for the public, hindering the FCSC's goal to be among the top 10 countries in the open data field. Here, you can see the [old portal](https://bayanat.ae).","need":"There was a need for a comprehensive upgrade that would overcome the existing platform's limitations. The new system needed to be bilingual, have a more user-friendly interface and support dynamic features like charts, easy sharing, and user feedback. Moreover, the content management system needed integration to improve SEO capabilities and user engagement.","solution":"We rebuild the portal with cutting-edge UX/UI design, seamlessly integrating storytelling to immerse users in a journey through various UAE-focused topics. Utilizing our [PortalJS](https://www.portaljs.com/) framework for the front end enabled high customizability and simplified administrative tasks. We implemented bilingual support for English and Arabic, including right-to-left content flow for Arabic. On the backend, we modernized the platform by upgrading to CKAN 2.9.5 and migrated the database to a secure Azure Kubernetes Cluster. We also seamlessly integrated a custom GhostCMS instance, empowering administrators with the ability to create and update content such as pages, news articles, navigation links, and homepage visuals. We added resource citation, sharing, rating, and dynamic visualization features to elevate user experience. Further, we designed a CKAN dataset approval workflow aligned with FCSC's data quality standards, ensuring only vetted and approved datasets are publicly accessible.","tech":["CKAN","Python","TypeScript","React","Nextjs","PortalJS","GraphQL","Ghost","Figma"],"providers":["Datopian"],"client":"[UAE's Federal Competitiveness and Statistics Centre](https://u.ae/en) (FCSC)","period":"November 2021 - present","work":"[UAE Open Data portal](https://opendata.fcsc.gov.ae/)","date":"2023/08/31","slug":"revolutionizing-open-data-fcsc","urlPath":"showcase/case-studies/revolutionizing-open-data-fcsc","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":5},{"title":"A novel tool developed for a Fortune 500 Pharma and Biotechnology Corporation","created":"2022-05-03T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","description":"Building an Open Data Portal with the right tools to help users easily access and visualize public health data.","image":"/assets/images/case-studies/2022-05-03-a-novel-tool-developed-for-a-fortune-500-pharma-and-biotechnology-corporation/national-cancer-institute-s9WLlvDlbx4-unsplash-scaled.webp","industries":["Pharma/Biotechnology"],"regions":["Americas"],"services":["Data Engineering","CKAN Development"],"usecases":["Internal Data Management"],"brief":"The project offers a compelling case for how Datopian created a custom-built discovery portal and search engine that streamlined processes, enabling a Fortune 500 pharmaceutical company to significantly improve dataset access and collaboration for their global research and development teams.","problem":"The client struggled with managing big amounts of clinical trial data from various sources, stored across their organization\u0026apos;s numerous departments and geographical locations. The pharmaceutical company required a unified solution for data aggregation, a discovery portal, and a search engine that could incorporate their complex, organization-specific metadata language system.","need":"The client needed a comprehensive solution to aggregate, search, and manage datasets across the organization, regardless of origin, storage, or geographical boundaries. They needed a solution that was both immediately useful and extremely customizable, allowing for seamless integration across their organization. The chosen solution had to be future-proof, supporting distributed deployment, interoperability with existing industry tools, and automation. Additionally, the solution needed to accommodate their unique dataset publishing domain model, sophisticated tagging system, and automated dataset uploading.","solution":"We developed a highly customized CKAN-based data portal and API serving system, tailored to the client\u0026apos;s specific domain model and metadata language. The solution provided an intuitive user interface for data management, and a sophisticated API for automation and headless manipulation of datasets. By incorporating agile development practices and continuous delivery, Datopian helped the client optimize their data cataloging, discovery, and dataset quality initiatives, ultimately driving efficiency and innovation within their research and development teams. This solution facilitated the client\u0026apos;s reproducible science and dataset quality initiatives while empowering global research and development staff with efficient data access and discovery.","tech":["CKAN","Python","JsonLD","Jenkins","EKS","AWS"],"providers":["Datopian"],"client":"A fortune 500 company, one of the largest pharmaceutical corporations in the world, with a highly specialized Gene Research and Therapy division in Silicon Valley, California","period":"2019 – 2021","date":"2022-05-03T00:00:00.000Z","slug":"a-novel-tool-developed-for-a-fortune-500-pharma-and-biotechnology-corporation","urlPath":"showcase/case-studies/a-novel-tool-developed-for-a-fortune-500-pharma-and-biotechnology-corporation","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":9},{"title":"Birmingham's Open Data Portal: Enhancing Civic Transparency ","created":"2023-09-26T00:00:00.000Z","layout":"article","authors":["Joao Demenech"],"avatarUrl":"/assets/images/team/Joao-Demenech.jpg","tags":["CKAN"],"image":"/assets/images/case-studies/2023-09-26-birmingham-data-revamp-civic-transparency-through-ckan/bull-statue-birmingham-ian-procter-pixabay.jpg","industries":["Government/Public Sector","International Organization"],"regions":["Global"],"services":["PortalJS","CKAN Consultancy","CKAN Development","CKAN Hosting"],"usecases":["Open Data Portal"],"description":"Discover how data visualization and public data access enhance data transparency and civic engagement through digital transformation.","brief":"In collaboration with Datopian, [Birmingham City Council](https://www.birmingham.gov.uk/), which manages the [Birmingham City Observatory](https://www.cityobservatory.birmingham.gov.uk/), undertook a comprehensive revamp of their open data portal. The updated platform aims to serve as the city's authoritative 'single source of truth' for public data, facilitating enhanced civic transparency, and collaboration.","problem":"The council's previous open data platform, Data Factory, launched in 2014, had become outdated and static, failing to meet the evolving demands of stakeholders and the general populace for reliable and accessible data.","need":"Given Birmingham's complex ecosystem of public, private, and academic stakeholders, and its role as a burgeoning service-based economy, there was a compelling need for a modern, reliable open data platform. The platform needed to catalyze innovation, support transparent governance, and engage the community effectively.","solution":"Datopian implemented a comprehensive solution that included upgrading the CKAN instance from version 2.6 to 2.9 and migrating it to Datopian’s secure cloud infrastructure. A sleek, user-centric front-end was developed using the PortalJS framework. The project also featured the integration of custom data charts on the homepage, SEO automation covering dynamic and static pages, and web analytics capabilities through the open-source Umami tool. These enhancements have revitalized the open data portal, turning it into a state-of-the-art resource for both the public and various institutional stakeholders.","tech":["PortalJS","CKAN","Python","TypeScript","React","Nextjs","GraphQL","Umami"],"providers":["Datopian"],"client":"[Birmingham City Observatory](https://www.cityobservatory.birmingham.gov.uk/) (managed by [Birmingham City Council](https://www.birmingham.gov.uk/))","period":"August 2022 - October 2022","work":"[Birmingham City Observatory Open Data Portal](https://www.cityobservatory.birmingham.gov.uk/)","date":"2023-09-26T00:00:00.000Z","slug":"birmingham-data-revamp-civic-transparency-through-ckan","urlPath":"showcase/case-studies/birmingham-data-revamp-civic-transparency-through-ckan","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":5},{"title":"Advanced Data Engineering for Big Data Challenges","created":"2023-09-11T00:00:00.000Z","layout":"article","authors":["Michael Polidori"],"avatarUrl":"/assets/images/team/Michael-Polidori.jpg","image":"/assets/images/case-studies/2023-09-11-a-transformation-journey-to-elevated-data-analytics/stephen-dawson-qwtCeJ5cLYs-unsplash.jpg","industries":["Pharma/Biotechnology"],"regions":["Americas"],"services":["Data Engineering","Data Strategy"],"usecases":["ETL Pipelines"],"description":"ETL automation: scalable ETL solutions tailored for big data processing, enhancing data transparency and operational efficiency in complex environments, and supporting real-time decision-making.","brief":"Datopian successfully engineered an advanced ETL pipeline, tackling the Client's complex big data challenges and enabling data-driven decision-making.","problem":"The Client engaged Datopian's data engineering expertise to tackle the big data hurdles inherent in a large-scale ETL process—the heart of their data-centric product. With thousands of JSON files, each averaging around 100GB, even minor inefficiencies could cascade into severe operational setbacks.","need":"The Client needed an ultra-efficient, automated ETL infrastructure capable of flawlessly managing hundreds of terabytes of data each month. The framework had to meet rigorous standards for operational efficiency, data quality, and integrity, and be primed for rapid querying.","solution":"Datopian architected an advanced ETL solution leveraging Airflow's Directed Acyclic Graphs (DAGs), designed meticulously for each critical phase—from seamless data retrieval to automated workflow. Implementing data streaming and chunking technologies to combat memory constraints, the result was an ETL pipeline that set a new industry benchmark in speed, data hygiene, and structural integrity.","tech":["Airflow","Python","Postgre","AWS","Redshift"],"providers":["Datopian"],"client":"Not disclosed","period":"March 2023 - July 2023","date":"2023-09-11T00:00:00.000Z","slug":"a-transformation-journey-to-elevated-data-analytics","urlPath":"showcase/case-studies/a-transformation-journey-to-elevated-data-analytics","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":6},{"title":"Delivering a Worldwide Postal Code Dataset for Global Logistics Fortune 500 Logistics Company","created":"2024-11-05T00:00:00.000Z","layout":"article","authors":["Anuar Ustayev"],"avatarUrl":"/assets/images/team/Anuar-Ustayev.jpg","image":"/assets/images/case-studies/2024-11-05-postal-code-dataset-solution-for-logistics-enterprise/chuttersnap-9cCeS9Sg6nU-unsplash.jpg","industries":["Logistics"],"regions":["Americas"],"services":["Data Engineering","ETL","Data Delivery","Data-as-a-Service","Data Aggregation","Data Integration","Data Standardization","Schema Design","Data Validation","Metadata Management","API Development","Agile Delivery","Data Consultancy"],"usecases":["Data Standardization","Data Harmonization"],"description":"Datopian delivered a fully standardized global postal code dataset to a Fortune 500 logistics company, addressing complex data challenges to improve routing, delivery accuracy, and strategic planning.","brief":"To streamline global operations, a Fortune 500 logistics company partnered with Datopian for a comprehensive postal code solution. By sourcing and standardizing data from hundreds of countries, Datopian enabled seamless integration with the company's systems, optimizing route planning and enhancing logistics accuracy.","problem":"Fragmented and inconsistent postal code data across regions limited the logistics company’s ability to efficiently route deliveries and make accurate strategic decisions. The lack of standardized formats, diverse data sources, and changing place names created a significant barrier to efficient operations","need":"The company required a scalable, globally standardized postal code solution that would integrate seamlessly with their logistics workflows, support regular updates, and ensure high data quality across diverse regions.","solution":"Datopian developed a scalable postal code data solution, including multi-source aggregation, tailored data pipelines, advanced geolocation management, and a W3C-compliant metadata schema. The solution delivered a unified dataset, empowering the logistics company with precise, reliable data for enhanced operational efficiency.","tech":["GitHub","GitHub-Actions","ETL","CSV","Cloudflare-R2","Python","Frictionless-Data","FTP"],"providers":["Datopian"],"client":"Fortune 500 logistics company","period":"June 2024 - Present","work":"https://datahub.io/collections/postal-codes-datasets","date":"2024-11-05T00:00:00.000Z","slug":"postal-code-dataset-solution-for-logistics-enterprise","urlPath":"showcase/case-studies/postal-code-dataset-solution-for-logistics-enterprise","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":10},{"title":"UBDC Data Portal Revamp: CKAN-Powered, Secure \u0026 GDPR-Compliant","created":"2025-02-03T00:00:00.000Z","layout":"article","authors":["Ismail Shahzad","Sagar Ghimire"],"avatarUrl":["/assets/images/team/Ismail-Shahzad.jpg","/assets/images/team/Saghar-Ghimire.jpg"],"image":"/assets/images/case-studies/2025-02-03-ubdc-data-portal-revamp-ckan-powered-secure-gdpr-compliant/image10.webp","industries":["Government/Public Sector"],"regions":["Europe"],"services":["CKAN Development","CKAN Hosting \u0026 Support","Data Consulting","Training"],"usecases":["Open Data Portal","ETL Pipelines"],"description":"Datopian modernized UBDC’s data portal with CKAN, enhancing security, scalability, and GDPR compliance on Google Cloud. Improved data access \u0026 management.","brief":"Datopian partnered with the University of Glasgow’s Urban Big Data Centre (UBDC) to modernize their data portal. Leveraging CKAN, we delivered a visually engaging, secure, and scalable solution hosted on Google Cloud Platform that enhances data discoverability, management, and user engagement.","problem":"UBDC’s existing data portal was outdated, lacking critical functionalities such as efficient metadata management, secure access controls, and seamless integration with third-party datasets. This limited user interaction and obstructed data-driven insights.","need":"UBDC required a modern, fit-for-purpose data portal to serve as a central hub for comprehensive data access. Essential requirements included advanced search and filtering capabilities, customizable metadata schemas, robust data governance, GDPR compliance, and DOI integration via DataCite to improve dataset visibility and citation.","solution":"Datopian implemented a complete overhaul by deploying the latest CKAN version with custom enhancements. The solution features a streamlined login process, manual publishing, custom metadata and categorization, advanced search functionality, and strict access controls. The portal is built with robust security measures and GDPR compliance, ensuring data protection and adherence to UK data standards.","tech":["CKAN","Postgre","Solr","Redis","Python","JavaScript","DataCite","Google-Analytics","Google-Tag-Manager","GCloud"],"providers":["Datopian"],"client":"[University of Glasgow - Urban Big Data Centre (UBDC)](https://ubdc.ac.uk/ )","period":"November 2022 - Present","work":"[https://data.ubdc.ac.uk/](https://data.ubdc.ac.uk/)","date":"2025-02-03T00:00:00.000Z","slug":"ubdc-data-portal-revamp-ckan-powered-secure-gdpr-compliant","urlPath":"showcase/case-studies/ubdc-data-portal-revamp-ckan-powered-secure-gdpr-compliant","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":9},{"title":"Energinet: towards a new future of renewable energy","created":"2020-11-10T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2020-11-10-client-case-study-energinet/energinet-1536x1025-1.webp","industries":["Energy"],"regions":["Europe"],"services":["CKAN Hosting \u0026 Support"],"usecases":["Open Data Portal"],"description":"Energinet required an open-source, scalable solution with expertise in data portal software to upgrade their existing infrastructure and support the creation of a new data gateway product, catering to the needs of diverse user groups while fostering transparency and innovation in renewable energy.","brief":"The project offers a compelling case for how Datopian upgraded Energine\u0026apos;s data infrastructure, facilitating an advanced, user-friendly gateway to their renewable energy data.","problem":"Energinet was using CKAN 2.6 platform and wanted to upgrade to CKAN 2.8 while also seeking guidance on best data practices for their upcoming energy data projects. They aimed to create two frontends: one for users to search and download data, and another for visualization and exploration through a dashboard.","need":"Energinet required an open-source, scalable solution with expertise in data portal software to upgrade their existing infrastructure and support the creation of a new data gateway product, catering to the needs of diverse user groups while fostering transparency and innovation in renewable energy. They also sought more advanced solutions for integrating content in CKAN, as the existing CKAN pages no longer fit their requirements, necessitating a more versatile and user-friendly approach.","solution":"We upgraded Energinet\u0026apos;s platform to CKAN 2.8, deprecated unnecessary extensions, and developed two products: Energi Data Service (EDS) for searching raw datasets, and Energi Data Portal (EDP) (gateway to various data products at Energinet) for visualizations and app creation. We also released a new app called \u0026apos;Green Energy\u0026apos; as part of the EDP project, built interactive dashboards (e.g., Green Energy, CO2 Emissions Level), redesigned the architecture to enable large data downloads in various formats, and provided responsive design for desktop, mobile, and tablet devices. Our team also offered support services, including bug fixes and feature enhancements. This collaboration facilitated seamless data access, enhanced transparency, and provided valuable insights for users such as schools and energy consumers. By providing innovative open-source solutions and sharing best practices, Datopian enabled Energinet to unlock the potential of their data for various user groups, advancing their mission to promote a sustainable energy future.","tech":["CKAN","Python"],"providers":["Datopian"],"client":"[Energinet](https://energinet.dk/)","period":"November 2018 - present","date":"2020-11-10T00:00:00.000Z","slug":"client-case-study-energinet","urlPath":"showcase/case-studies/client-case-study-energinet","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":3},{"title":"New Mexico Water Data Initiative","created":"2022-03-03T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2022-03-03-client-case-study-new-mexico-water-data-initiative/stephanie-klepacki-KV7Mtt-br2o-unsplash-1-scaled.webp","industries":["Non-profit/NGO"],"regions":["Americas"],"services":["UX/UI Design","CKAN Hosting \u0026 Support"],"usecases":["Open Data Portal"],"description":"Before approaching Datopian, the client had an existing CKAN site. However, they realized they were not utilizing its full potential and maintaining the portal on their own was not feasible.","brief":"The project offers a compelling case for how Datopian\u0026apos;s expertise transformed New Mexico\u0026apos;s Water Data Initiative by upgrading their CKAN portal, providing improved functionality, accessibility, and design to efficiently manage and share water data for better water management and planning.","problem":"New Mexico\u0026apos;s existing CKAN portal was underutilized and challenging to maintain in-house, with outdated security measures and limited interoperability, making it difficult for users to access and navigate the vast water data resources.","need":"The client required a robust, secure, and user-friendly CKAN portal, with seamless data catalog interoperability, improved layout, and design to ensure water data accessibility for effective water management and planning.","solution":"Datopian migrated the client\u0026apos;s CKAN instance to their cloud, upgraded security patches, implemented Data Catalog Vocabulary (DCAT) for enhanced interoperability, and redesigned the portal\u0026apos;s homepage for improved usability. The upgraded portal now facilitates easy access to datasets on Google Datasets Search, ensuring efficient water data management for New Mexico\u0026apos;s Water Data Initiative.","tech":["CKAN","Python","DCAT","GDS"],"providers":["Datopian"],"client":"[New Mexico Water Data Initiative](https://newmexicowaterdata.org) ","period":"September 2021 - Present","work":"[New Mexico Water Data](https://catalog.newmexicowaterdata.org) ","date":"2022-03-03T00:00:00.000Z","slug":"client-case-study-new-mexico-water-data-initiative","urlPath":"showcase/case-studies/client-case-study-new-mexico-water-data-initiative","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":2},{"title":"Making Public Health Data Accessible: CKAN-based Data Access Platform","created":"2022-07-28T00:00:00.000Z","authors":["Yoana Popova","Michael Polidori"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","layout":"article","image":"/assets/images/case-studies/2022-07-28-an-open-data-platform-for-vital-strategies-a-global-public-health-organization/campaign-creators-pypeCEaJeZY-unsplash-cut.webp","description":"Building an Open Data Portal with the right tools to help users easily access and visualize public health data.","industries":["Government/Public Sector","Non-profit/NGO","Public Health"],"regions":["Global"],"services":["Data Engineering","CKAN Development","CKAN Features","CKAN Consultancy","CKAN Hosting \u0026 Support"],"usecases":["Open Data Portal"],"brief":"Vital Strategies, in collaboration with Datopian, developed [VIA Data](https://vital-stepsdata.org/) - a data access platform based on CKAN. VIA Data makes public health data more accessible by converting complex datasets into interactive, visual, and easy-to-understand formats. The platform helps public health practitioners, researchers, and the general public use data effectively.","problem":"Public health and epidemiology data, although extensively collected, often remain underutilized. Many countries gather vast amounts of data that end up languishing on servers or in Excel spreadsheets, rarely seeing the light of day. This data, which could be invaluable for researchers, journalists, and the general public, remains inaccessible due to the lack of user-friendly tools to share it effectively. VIA Data was conceived to address this gap.","need":"Vital Strategies needed a tool that can make public health data more accessible, interactive, and understandable. Such a tool would enable public health practitioners, researchers, and the general public to leverage data effectively for informed decision-making and improved health outcomes.","solution":"VIA Data, standing for Visual, Interactive, and Accessible Data, addresses this need by providing a public, open-source CKAN extension that simplifies data access and visualization. It features a data access portal and interactive report platform, allowing users to easily find, analyze, and share public health data. By transforming raw data into compelling stories and interactive visualizations, VIA Data enhances data usability and impact, ultimately contributing to better public health systems worldwide. By customizing the default CKAN UI, we created visually-rich dashboards and easy-to-use Query Tools with multiple forms of visualizations. Popular libraries like Plotly, Leaflet, and DataTables were used to create interactive and customizable data visualizations. With a clean and organized interface, the portal makes sharing public health data visually easy and enjoyable for both admins and public users.","tech":["CKAN","Datatables","JavaScript","Python","Postgre","Redis","Solr","Plotly","Leaflet"],"providers":["Datopian"],"client":"[Vital Strategies](https://www.vitalstrategies.org/)","period":"November 2017 - present","work":"[Vital Strategies Platform](https://vital-stepsdata.org/)","date":"2022-07-28T00:00:00.000Z","slug":"an-open-data-platform-for-vital-strategies-a-global-public-health-organization","urlPath":"showcase/case-studies/an-open-data-platform-for-vital-strategies-a-global-public-health-organization","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":5},{"title":"Helping a sustainable data-driven business derive meaning from information","created":"2022-05-12T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2022-05-12-helping-sustainable-data-driven-business-derive-meaning-from-information/nasa-Q1p7bh3SHj8-unsplash-scaled.webp","description":"Solving big data management issues for Birch Infrastructure – a company that brings together renewable energy and data centers.","industries":["Energy"],"regions":["Americas"],"services":["Data Engineering","Data Strategy"],"usecases":["Data Catalog","Internal Data Management"],"brief":"The project offers a compelling case for how Datopian\u0026apos;s cutting-edge solutions tackled the intricate big data management challenges faced by Birch Infrastructure, a pioneering US-based company focused on integrating renewable energy and data centers.","problem":"The project offers a compelling case for how Datopian\u0026apos;s cutting-edge solutions tackled the intricate big data management challenges faced by Birch Infrastructure, a pioneering US-based company focused on integrating renewable energy and data centers.","need":"Birch required a comprehensive solution that would automate and streamline their data management processes while implementing best practices of data engineering, enabling them to focus on producing business insights instead of struggling with raw data complexities.","solution":"We stepped in with a tailored, comprehensive solution that streamlined Birch Infrastructure\u0026apos;s data management processes. By leveraging cutting-edge technologies such as Elasticsearch, BigQuery, and Jina.ai, we implemented a user-friendly platform that simplifies data access, storage, and analytics. Our approach included an innovative data pipeline to automate data ingestion, management, transformation, and display. We implemented efficient search capabilities, and interactive visualizations, empowering Birch Infrastructure to rapidly uncover valuable insights. By implementing data exploration, metadata indexing, smart entity mapping, and semantic search, we facilitated streamlined access to relevant data. We also implemented data exploration, metadata indexing, smart entity mapping, and semantic search to facilitate access to relevant data. The solution led to significant time savings, better data cross-referencing, and enabled Birch to excel in agile, data-driven decision-making.","tech":["CKAN","Python","ElasticSearch","MSSQL","Nodejs","BigQuery","Jupyter","FastAPI","Prefect","DBT","Docker","Jina","Kibana","DNNS","MachineLearning","NLP","Firebase","Apollo","Nextjs","React","Tailwind","Mapbox","Plotly","PyVis","D3","Mocha","Chai"],"providers":["Datopian"],"client":"[Birch Infrastructure](https://www.birch.coop/)","period":"March 2021 - present","date":"2022-05-12T00:00:00.000Z","slug":"helping-sustainable-data-driven-business-derive-meaning-from-information","urlPath":"showcase/case-studies/helping-sustainable-data-driven-business-derive-meaning-from-information","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":8},{"title":"Strategic Synergy in Open-Source Technology: Datopian and OKF Elevate Global Open Data Standards Through CKAN","created":"2020-11-10T00:00:00.000Z","layout":"article","authors":["Yoana Popova"],"avatarUrl":"/assets/images/team/Yoana-Popova.jpg","image":"/assets/images/case-studies/2020-11-10-strategic-synergy-okf-elevate-global-data-standards-through-ckan/OKF-Datopian.webp","industries":["International Organization","Non-profit/NGO"],"regions":["Global"],"services":["CKAN Development","CKAN Features","Data Engineering","Digital Transformation"],"usecases":["Data Catalog","Internal Data Management","Open Data Portal"],"description":"Datopian and OKF share many of the same values. We are both committed to fostering transparency and innovation through open data and open-source technical infrastructure.","providers":["Datopian","[OKF](https://okfn.org/en/)"],"client":"[OKF](https://okfn.org/en/)","period":"2014 - present","date":"2020-11-10T00:00:00.000Z","slug":"strategic-synergy-okf-elevate-global-data-standards-through-ckan","urlPath":"showcase/case-studies/strategic-synergy-okf-elevate-global-data-standards-through-ckan","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":2},{"title":"Enhancing Data Operations: Datopian’s DaaS Solution for a Fortune 500 Logistics Leader","created":"2024-12-06T00:00:00.000Z","layout":"article","authors":["Anuar Ustayev"],"avatarUrl":"/assets/images/team/Anuar-Ustayev.jpg","image":"/assets/images/case-studies/2024-12-06-datopian-daas-solution-for-fortune-500-logistics-leader/global-connection.jpg","industries":["Logistics"],"regions":["Americas"],"services":["Data Engineering","ETL","Data Delivery","Data-as-a-Service","Data Aggregation","Data Integration","Data Standardization","Schema Design","Data Validation","Metadata Management","API Development","Agile Delivery","Data Consultancy"],"usecases":["Data Standardization","Data Harmonization"],"description":"Learn how Datopian saved a Fortune 500 company $250K annually with tailored data solutions, automated pipelines, and dedicated support.","brief":"To streamline global operations, a Fortune 500 logistics company partnered with Datopian for a comprehensive postal code solution. By sourcing and standardizing data from hundreds of countries, Datopian enabled seamless integration with the company's systems, optimizing route planning and enhancing logistics accuracy.","problem":"The client struggled to manage a vast array of open datasets due to challenges in resource allocation, data quality, customization, and licensing complexities. Building an in-house data team was costly and posed operational risks.","need":"They required a scalable, cost-effective solution for sourcing, processing, and customizing open data, along with ongoing support to ensure reliability and minimize operational disruptions.","solution":"Datopian provided a tailored DaaS service, including automated ETL pipelines, bespoke data customization, and dedicated support. By managing compliance and delivering high-quality datasets seamlessly integrated into their workflows, we enabled the client to focus on their core operations with confidence.","tech":["GitHub","GitHub-Actions","ETL","CSV","Cloudflare-R2","Python","Frictionless-Data","FTP"],"providers":["Datopian"],"client":"Fortune 500 logistics company","period":"June 2020 - Present","date":"2024-12-06T00:00:00.000Z","slug":"datopian-daas-solution-for-fortune-500-logistics-leader","urlPath":"showcase/case-studies/datopian-daas-solution-for-fortune-500-logistics-leader","isDraft":false,"editUrl":null,"showComments":false,"showEditLink":false,"showLinkPreviews":true,"showToc":false,"showSidebar":false,"readingTime":11}]},"__N_SSG":true},"page":"/solutions/ckan/development","query":{},"buildId":"OlPi-OoS2ZoHlelYrxI5_","isFallback":false,"gsp":true,"scriptLoader":[]}</script></body></html>