Time-series data from PostgreSQL can be linked to Planhat's Companies, End Users, Assets or Projects as either Custom Metrics or User Activities in real-time. The connection supports auto-creation of End Users in Planhat, historical data syncing, and End User mapping with both Email and External ID.
![](data:image/svg+xml,<svg display="block" role="presentation" viewBox="0 0 33 34" xmlns="http://www.w3.org/2000/svg"><g d="M 0 33.241 L 0 0 L 33 0 L 33 33.241 Z M 14.789 2.808 C 14.789 5.264 14.795 7.668 14.787 10.072 C 14.78 11.87 13.172 12.788 11.603 11.893 C 9.352 10.61 7.103 9.32 4.857 8.027 C 3.698 7.36 3.344 6.174 3.961 5.074 C 4.55 4.025 5.779 3.738 6.931 4.401 C 8.142 5.097 9.342 5.813 10.619 6.562 C 10.633 6.343 10.653 6.184 10.653 6.025 C 10.656 4.745 10.642 3.464 10.659 2.185 C 10.674 1.076 11.377 0.227 12.397 0.031 C 13.298 -0.141 14.327 0.412 14.632 1.328 C 14.78 1.773 14.743 2.279 14.789 2.808 Z M 11 15.868 C 11.244 17.246 10.881 18.02 9.7 18.703 C 7.485 19.982 5.274 21.267 3.054 22.535 C 2.165 23.043 1.138 22.853 0.523 22.109 C -0.151 21.294 -0.182 20.154 0.48 19.395 C 0.669 19.179 0.92 19.005 1.17 18.859 C 2.243 18.23 3.327 17.619 4.406 16.999 C 4.551 16.916 4.687 16.818 4.886 16.689 C 3.791 16.045 2.753 15.435 1.715 14.824 C 1.507 14.701 1.297 14.581 1.091 14.454 C 0.043 13.803 -0.272 12.618 0.327 11.583 C 0.902 10.591 2.095 10.286 3.169 10.885 C 4.406 11.575 5.631 12.287 6.861 12.992 C 7.925 13.601 9.007 14.184 10.042 14.84 C 10.415 15.077 10.673 15.495 11 15.868 Z M 25.323 9.61 C 23.941 10.403 22.592 11.178 21.238 11.945 C 19.772 12.776 18.203 11.857 18.201 10.164 C 18.196 7.517 18.197 4.869 18.2 2.221 C 18.202 0.955 19.076 0.014 20.248 0.006 C 21.377 -0.001 22.303 0.928 22.329 2.152 C 22.356 3.415 22.336 4.678 22.336 5.942 C 22.336 6.13 22.336 6.319 22.336 6.607 C 22.548 6.495 22.695 6.425 22.835 6.344 C 23.939 5.698 25.039 5.044 26.147 4.404 C 27.229 3.779 28.399 4.052 28.984 5.05 C 29.58 6.067 29.269 7.309 28.231 7.932 C 27.283 8.502 26.315 9.038 25.323 9.61 Z M 14.789 29.92 C 14.788 30.37 14.794 30.768 14.787 31.166 C 14.764 32.272 13.924 33.171 12.856 33.236 C 11.811 33.299 10.84 32.544 10.715 31.462 C 10.622 30.658 10.664 29.839 10.656 29.026 C 10.648 28.271 10.654 27.515 10.654 26.663 C 9.429 27.382 8.283 28.049 7.143 28.725 C 6.648 29.019 6.156 29.304 5.547 29.234 C 4.615 29.127 3.919 28.478 3.71 27.514 C 3.529 26.683 3.91 25.822 4.71 25.358 C 6.64 24.239 8.58 23.137 10.516 22.028 C 10.921 21.796 11.324 21.56 11.731 21.331 C 13.116 20.552 14.763 21.472 14.78 23.064 C 14.805 25.332 14.788 27.6 14.789 29.92 Z M 30.841 15.024 C 29.92 15.567 29.031 16.089 28.077 16.649 C 29.43 17.427 30.707 18.147 31.97 18.892 C 32.765 19.361 33.1 20.083 32.975 20.996 C 32.855 21.87 32.354 22.444 31.509 22.692 C 30.989 22.845 30.483 22.769 30.009 22.497 C 27.685 21.165 25.354 19.846 23.039 18.499 C 21.445 17.571 21.467 15.672 23.068 14.75 C 25.284 13.474 27.502 12.202 29.723 10.933 C 30.857 10.285 32.051 10.553 32.659 11.58 C 33.285 12.637 32.933 13.781 31.766 14.477 C 31.469 14.654 31.17 14.828 30.841 15.024 Z M 22.336 28.88 C 22.336 29.658 22.355 30.386 22.33 31.111 C 22.291 32.247 21.487 33.131 20.438 33.232 C 19.441 33.328 18.523 32.682 18.264 31.686 C 18.213 31.489 18.202 31.277 18.202 31.071 C 18.198 28.459 18.195 25.848 18.201 23.236 C 18.205 21.443 19.822 20.512 21.38 21.406 C 23.673 22.722 25.965 24.04 28.247 25.374 C 29.023 25.827 29.36 26.541 29.251 27.432 C 29.141 28.335 28.616 28.911 27.743 29.143 C 27.144 29.302 26.584 29.161 26.055 28.847 C 24.853 28.134 23.646 27.43 22.336 26.662 C 22.336 27.44 22.336 28.134 22.336 28.88 Z M 14.357 14.227 C 14.689 13.895 15.016 13.608 15.294 13.279 C 15.626 12.886 16.017 12.76 16.525 12.769 C 16.958 12.776 17.268 12.898 17.567 13.212 C 18.366 14.05 19.201 14.853 20.016 15.676 C 20.621 16.288 20.617 17.074 20.014 17.68 C 19.184 18.512 18.356 19.346 17.522 20.174 C 17.028 20.664 16.004 20.659 15.511 20.169 C 14.641 19.304 13.773 18.436 12.908 17.566 C 12.469 17.124 12.465 16.134 12.903 15.684 C 13.373 15.201 13.855 14.729 14.357 14.227 Z M 17.093 17.642 C 18.083 16.652 18.083 16.652 17.099 15.672 C 17.075 15.648 17.05 15.624 17.026 15.599 C 16.555 15.138 16.384 15.139 15.909 15.605 C 14.792 16.7 14.808 16.623 15.882 17.677 C 16.373 18.16 16.505 18.165 17.093 17.642 Z" fill="transparent" height="33.2413px" id="beTeccNIb" transform="translate(0 0)" width="33.000400212688405px"><path d="M 0 33.241 L 0 0 L 33 0 L 33 33.241 Z" fill="transparent" height="33.2413px" id="lO8vOL1vu" transform="translate(0 0)" width="33.0004px"/><path d="M 11.128 2.808 C 11.128 5.264 11.134 7.668 11.125 10.072 C 11.119 11.87 9.511 12.788 7.942 11.893 C 5.69 10.61 3.442 9.32 1.195 8.027 C 0.036 7.36 -0.317 6.174 0.3 5.074 C 0.888 4.025 2.118 3.738 3.269 4.401 C 4.48 5.097 5.681 5.813 6.957 6.562 C 6.972 6.343 6.991 6.184 6.992 6.025 C 6.994 4.745 6.98 3.464 6.998 2.185 C 7.013 1.076 7.715 0.227 8.736 0.031 C 9.636 -0.141 10.666 0.412 10.971 1.328 C 11.118 1.773 11.081 2.279 11.128 2.808 Z" fill="rgb(35, 180, 230)" height="12.23985639889031px" id="OD2mRPnNK" transform="translate(3.661 0)" width="11.129736425218567px"/><path d="M 11 5.289 C 11.244 6.667 10.881 7.441 9.7 8.124 C 7.485 9.403 5.274 10.688 3.054 11.956 C 2.165 12.464 1.138 12.274 0.523 11.53 C -0.151 10.715 -0.182 9.575 0.48 8.816 C 0.669 8.6 0.92 8.426 1.17 8.28 C 2.243 7.651 3.327 7.04 4.406 6.42 C 4.551 6.337 4.687 6.239 4.886 6.11 C 3.791 5.466 2.753 4.856 1.715 4.245 C 1.507 4.122 1.297 4.002 1.091 3.875 C 0.043 3.224 -0.272 2.038 0.327 1.004 C 0.902 0.012 2.095 -0.293 3.169 0.306 C 4.406 0.996 5.631 1.708 6.861 2.412 C 7.925 3.022 9.007 3.605 10.042 4.261 C 10.415 4.498 10.673 4.916 11 5.289 Z" fill="rgb(35, 180, 230)" height="12.240511660351835px" id="zUDQAVsR0" transform="translate(0 10.579)" width="11.071896269255083px"/><path d="M 7.126 9.603 C 5.743 10.396 4.394 11.172 3.04 11.939 C 1.575 12.77 0.006 11.851 0.003 10.158 C -0.002 7.51 0 4.863 0.003 2.215 C 0.004 0.949 0.878 0.008 2.05 0 C 3.179 -0.008 4.105 0.921 4.131 2.146 C 4.159 3.408 4.138 4.672 4.138 5.935 C 4.139 6.124 4.138 6.313 4.138 6.601 C 4.351 6.489 4.497 6.419 4.637 6.337 C 5.741 5.691 6.841 5.037 7.949 4.398 C 9.032 3.773 10.201 4.045 10.787 5.044 C 11.382 6.061 11.071 7.302 10.034 7.926 C 9.086 8.496 8.117 9.031 7.126 9.603 Z" fill="rgb(35, 180, 230)" height="12.249314681982261px" id="iE2Yen9ZW" transform="translate(18.198 0.006)" width="11.086958632563718px"/><path d="M 11.123 8.87 C 11.123 9.32 11.129 9.719 11.121 10.117 C 11.099 11.223 10.258 12.122 9.191 12.187 C 8.145 12.25 7.174 11.495 7.049 10.412 C 6.956 9.609 6.998 8.789 6.99 7.977 C 6.982 7.221 6.988 6.466 6.988 5.614 C 5.763 6.333 4.618 7 3.477 7.676 C 2.982 7.969 2.491 8.254 1.881 8.185 C 0.949 8.078 0.254 7.428 0.044 6.465 C -0.136 5.634 0.244 4.773 1.045 4.309 C 2.974 3.189 4.914 2.088 6.85 0.979 C 7.255 0.747 7.658 0.51 8.065 0.282 C 9.45 -0.497 11.097 0.423 11.114 2.015 C 11.139 4.283 11.122 6.551 11.123 8.87 Z" fill="rgb(35, 180, 230)" height="12.190417151251605px" id="Te2nD0CSg" transform="translate(3.666 21.049)" width="11.127940035027978px"/><path d="M 8.985 4.442 C 8.064 4.985 7.176 5.507 6.221 6.067 C 7.574 6.845 8.851 7.565 10.114 8.31 C 10.91 8.779 11.245 9.501 11.119 10.414 C 11 11.288 10.499 11.862 9.654 12.11 C 9.133 12.263 8.627 12.187 8.154 11.915 C 5.83 10.583 3.499 9.264 1.184 7.917 C -0.411 6.989 -0.388 5.09 1.212 4.168 C 3.428 2.892 5.647 1.62 7.867 0.351 C 9.001 -0.297 10.196 -0.029 10.804 0.998 C 11.43 2.055 11.077 3.199 9.91 3.895 C 9.613 4.072 9.315 4.246 8.985 4.442 Z" fill="rgb(34, 180, 230)" height="12.187702456608097px" id="V7wLJNsRE" transform="translate(21.855 10.582)" width="11.145066460170412px"/><path d="M 4.139 7.818 C 4.138 8.597 4.158 9.324 4.132 10.05 C 4.093 11.186 3.289 12.069 2.24 12.17 C 1.244 12.266 0.325 11.62 0.067 10.625 C 0.015 10.427 0.005 10.215 0.004 10.01 C 0 7.398 -0.003 4.786 0.003 2.174 C 0.008 0.381 1.624 -0.55 3.183 0.344 C 5.476 1.66 7.767 2.978 10.05 4.312 C 10.825 4.765 11.163 5.479 11.053 6.371 C 10.943 7.273 10.418 7.849 9.545 8.081 C 8.947 8.241 8.386 8.099 7.857 7.785 C 6.656 7.072 5.448 6.369 4.139 5.6 C 4.139 6.379 4.139 7.073 4.139 7.818 Z" fill="rgb(35, 180, 230)" height="12.179644776053117px" id="eO_4v20Z6" transform="translate(18.198 21.062)" width="11.073526356966706px"/><path d="M 1.781 1.459 C 2.112 1.127 2.44 0.84 2.718 0.511 C 3.049 0.118 3.441 -0.008 3.948 0 C 4.381 0.008 4.691 0.13 4.99 0.444 C 5.789 1.282 6.624 2.085 7.439 2.908 C 8.044 3.52 8.04 4.306 7.437 4.912 C 6.608 5.744 5.779 6.578 4.945 7.406 C 4.452 7.895 3.428 7.891 2.935 7.401 C 2.064 6.536 1.196 5.668 0.331 4.798 C -0.108 4.356 -0.112 3.366 0.326 2.916 C 0.796 2.433 1.278 1.961 1.781 1.459 Z M 4.516 4.874 C 5.507 3.884 5.507 3.884 4.522 2.904 C 4.498 2.88 4.474 2.855 4.449 2.831 C 3.979 2.37 3.808 2.371 3.332 2.837 C 2.216 3.932 2.232 3.855 3.305 4.909 C 3.797 5.391 3.929 5.397 4.516 4.874 Z" fill="rgb(36, 180, 230)" height="7.77084806920632px" id="rA4j3peU1" transform="translate(12.576 12.768)" width="7.891324434316561px"/></g></svg>)
![](data:image/svg+xml,<svg display="block" role="presentation" viewBox="0 0 36 33" xmlns="http://www.w3.org/2000/svg"><defs ><linearGradient id="kiZHWhcHK-3083286839-linear-gradient" x1="0.49751243781094523" x2="0.5024875621890548" y1="0" y2="1"><stop offset="0" stop-color="rgb(67, 135, 253)"/><stop offset="1" stop-color="rgb(70, 131, 234)"/></linearGradient></defs><g d="M 0 32.241 L 0 0 L 36 0 L 36 32.241 Z M 7.816 30.427 L 0.433 17.639 C 0.149 17.147 0 16.59 0 16.022 C 0 15.454 0.149 14.896 0.433 14.405 L 7.816 1.617 C 8.1 1.125 8.508 0.717 9 0.433 C 9.492 0.149 10.05 0 10.617 0 L 25.383 0 C 25.951 0 26.508 0.149 27 0.433 C 27.492 0.717 27.9 1.126 28.184 1.617 L 35.567 14.405 C 35.85 14.896 36 15.454 36 16.022 C 36 16.59 35.85 17.147 35.567 17.639 L 28.184 30.427 C 27.9 30.918 27.492 31.326 27 31.61 C 26.508 31.894 25.951 32.044 25.383 32.044 L 10.617 32.044 C 10.05 32.044 9.492 31.894 9 31.61 C 8.508 31.326 8.1 30.918 7.816 30.427 Z M 33.533 22.344 L 22.676 11.486 L 18 10.235 L 13.8 11.796 L 12.178 16.022 L 13.482 20.727 L 24.996 32.241 L 27.439 32.132 Z M 18 9.498 C 14.397 9.498 11.476 12.419 11.476 16.022 C 11.476 19.624 14.397 22.545 18 22.545 C 21.603 22.545 24.523 19.624 24.523 16.022 C 24.523 12.419 21.602 9.498 18 9.498 Z M 18 20.971 C 15.266 20.971 13.05 18.755 13.05 16.021 C 13.05 13.288 15.266 11.072 18 11.072 C 20.734 11.072 22.95 13.288 22.95 16.022 C 22.95 18.755 20.734 20.971 18 20.971 Z M 14.903 15.769 L 14.903 17.797 C 15.204 18.312 15.627 18.745 16.135 19.056 L 16.135 15.769 Z M 17.346 14.06 L 17.346 19.519 C 17.556 19.558 17.77 19.581 17.99 19.581 C 18.191 19.581 18.387 19.56 18.579 19.528 L 18.579 14.06 Z M 19.903 16.612 L 19.903 19.02 C 20.42 18.692 20.844 18.237 21.135 17.698 L 21.135 16.612 Z M 22.694 20.04 L 22.019 20.716 C 21.961 20.773 21.929 20.851 21.929 20.932 C 21.929 21.013 21.961 21.091 22.019 21.148 L 24.582 23.711 C 24.639 23.768 24.717 23.8 24.798 23.8 C 24.879 23.8 24.957 23.768 25.014 23.711 L 25.69 23.036 C 25.747 22.978 25.779 22.9 25.779 22.82 C 25.779 22.739 25.747 22.661 25.69 22.604 L 23.126 20.04 C 23.069 19.983 22.991 19.951 22.91 19.951 C 22.829 19.951 22.752 19.983 22.694 20.04 Z" fill="transparent" height="32.2408px" id="H8N38u5P1" width="36px"><path d="M 0 32.241 L 0 0 L 36 0 L 36 32.241 Z" fill="transparent" height="32.2408px" id="PT8ze2Xzg" width="36px"/><path d="M 7.816 30.427 L 0.433 17.639 C 0.149 17.147 0 16.59 0 16.022 C 0 15.454 0.149 14.896 0.433 14.405 L 7.816 1.617 C 8.1 1.125 8.508 0.717 9 0.433 C 9.492 0.149 10.05 0 10.617 0 L 25.383 0 C 25.951 0 26.508 0.149 27 0.433 C 27.492 0.717 27.9 1.126 28.184 1.617 L 35.567 14.405 C 35.85 14.896 36 15.454 36 16.022 C 36 16.59 35.85 17.147 35.567 17.639 L 28.184 30.427 C 27.9 30.918 27.492 31.326 27 31.61 C 26.508 31.894 25.951 32.044 25.383 32.044 L 10.617 32.044 C 10.05 32.044 9.492 31.894 9 31.61 C 8.508 31.326 8.1 30.918 7.816 30.427 Z" fill="url(%23kiZHWhcHK-3083286839-linear-gradient)" height="32.043500050167786px" id="kiZHWhcHK" width="36px"/><g opacity="0.07"><path d="M 21.355 12.109 L 10.498 1.251 L 5.822 0 L 1.622 1.561 L 0 5.787 L 1.304 10.492 L 12.818 22.005 L 15.261 21.897 Z" fill="rgb(0, 0, 0)" height="22.005499999999998px" id="ovBVP9wuF" transform="translate(12.178 10.235)" width="21.354999999999997px"/></g><path d="M 6.524 0 C 2.921 0 0 2.921 0 6.524 C 0 10.127 2.921 13.047 6.524 13.047 C 10.126 13.047 13.047 10.127 13.047 6.524 C 13.047 2.921 10.126 0 6.524 0 Z M 6.524 11.474 C 3.79 11.474 1.574 9.257 1.574 6.524 C 1.574 3.79 3.79 1.574 6.524 1.574 C 9.257 1.574 11.474 3.79 11.474 6.524 C 11.474 9.258 9.257 11.474 6.524 11.474 Z" fill="rgb(255, 255, 255)" height="13.04738px" id="ervp6BboB" transform="translate(11.476 9.498)" width="13.046899999999999px"/><path d="M 0 1.709 L 0 3.737 C 0.3 4.252 0.723 4.685 1.232 4.996 L 1.232 1.709 Z M 2.443 0 L 2.443 5.459 C 2.652 5.498 2.866 5.521 3.087 5.521 C 3.288 5.521 3.483 5.5 3.675 5.468 L 3.675 0 Z M 4.999 2.552 L 4.999 4.96 C 5.516 4.632 5.94 4.177 6.232 3.638 L 6.232 2.552 Z M 7.791 5.98 L 7.115 6.656 C 7.058 6.713 7.026 6.791 7.026 6.872 C 7.026 6.953 7.058 7.031 7.115 7.088 L 9.679 9.651 C 9.736 9.708 9.814 9.74 9.895 9.74 C 9.976 9.74 10.054 9.708 10.111 9.651 L 10.787 8.976 C 10.844 8.918 10.876 8.84 10.876 8.76 C 10.876 8.679 10.844 8.601 10.787 8.544 L 8.223 5.98 C 8.166 5.923 8.088 5.891 8.007 5.891 C 7.926 5.891 7.848 5.923 7.791 5.98 Z" fill="rgb(255, 255, 255)" height="9.740400204467772px" id="zSfJxCKNT" transform="translate(14.903 14.06)" width="10.875600092315675px"/></g></svg>)
