{"id":2304,"date":"2021-01-29T07:40:56","date_gmt":"2021-01-29T07:40:56","guid":{"rendered":"http:\/\/crmtiger.com\/blog\/?p=2304"},"modified":"2024-11-26T06:49:31","modified_gmt":"2024-11-26T06:49:31","slug":"how-to-encrypt-confidential-data-in-vtiger-database","status":"publish","type":"post","link":"https:\/\/crmtiger.com\/blog\/how-to-encrypt-confidential-data-in-vtiger-database\/","title":{"rendered":"How do I encrypt confidential data in the vTiger database?"},"content":{"rendered":"<p>Data security is key in any software, and due to the high number of security-vulnerable algorithms, there are a lot of issues with data security.<br \/>\nThe vTiger database is easily hacked by the hecklers, who steal important data like customer&#8217;s phone numbers, emails, SSNs, addresses, etc. and sell those data in the market at a higher cost.<br \/>\n<!--more--><\/p>\n<h3 style=\"color: #00acef;\"><strong><span style=\"text-decoration: underline;\">vTiger Community Database Safe?<\/span><\/strong><\/h3>\n<ul style=\"list-style-type: none;\">\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> Database is open and easy to check.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> Easy target from heckler using SQL injection.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> There is no encryption of important data.<\/li>\n<\/ul>\n<h3 style=\"color: #00acef;\"><strong><span style=\"text-decoration: underline;\">How does CRMTiger help?<\/span><\/strong><\/h3>\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/>\u00a0The\u00a0<a href=\"https:\/\/crmtiger.com\/vtiger-plugins.html?utm_source=website-nm&amp;utm_medium=blog-nm&amp;utm_campaign=vtiger-plugins-nm\" target=\"_blank\" rel=\"noopener noreferrer\">CRMTiger team<\/a>\u00a0implemented the option to encrypt any field from any module in the database using the \u201cSHA256\u201d encryption algorithm.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> Encrypt any of the confidential fields in the database so they will not be hacked by any third party.\n<ul style=\"list-style-type: circle;\">\n<li>Email<\/li>\n<li>Phone #<\/li>\n<li>SSN<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 style=\"color: #00acef;\"><strong><span style=\"text-decoration: underline;\">Encryption Setting:<\/span><\/strong><\/h3>\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> There is an option in settings to allow modules and fields to be set in encryption.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> From the Settings page, you could simply encrypt all previous entries.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a class=\"dt-single-image\" href=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-configuration.png\" data-dt-img-description=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2305 size-full\" src=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-configuration.png\" alt=\"img\" width=\"884\" height=\"276\" srcset=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-configuration.png 884w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-configuration-300x94.png 300w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-configuration-768x240.png 768w\" sizes=\"auto, (max-width: 884px) 100vw, 884px\" \/><\/a><\/p>\n<h3 style=\"color: #00acef;\"><strong>Where will encryption apply?<\/strong><\/h3>\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li><img decoding=\"async\" src=\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\" alt=\"\" \/> Encryption will apply in the following view of the vTiger CRM.\n<ul style=\"list-style-type: circle;\">\n<li>List view<\/li>\n<li>Edit view<\/li>\n<li>Detail view<\/li>\n<li>Report<\/li>\n<li>Email \/ SMS going out from the system<\/li>\n<li>Report<\/li>\n<li>Dashboard<\/li>\n<li>API Integration<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 style=\"color: #00acef;\"><strong><span style=\"text-decoration: underline;\">Encryption in Database:<\/span><\/strong><\/h3>\n<p><a class=\"dt-single-image\" href=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-database.png\" data-dt-img-description=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2306 size-full\" src=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-database.png\" alt=\"img\" width=\"785\" height=\"270\" srcset=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-database.png 785w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-database-300x103.png 300w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-encryption-database-768x264.png 768w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<h3 style=\"color: #00acef;\"><strong><span style=\"text-decoration: underline;\">Display original data in vTiger:<\/span><\/strong><\/h3>\n<p><a class=\"dt-single-image\" href=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-original-data.png\" data-dt-img-description=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2307 size-full\" src=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-original-data.png\" alt=\"img\" width=\"1025\" height=\"350\" srcset=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-original-data.png 1025w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-original-data-300x102.png 300w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-original-data-768x262.png 768w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2021\/01\/vtiger-original-data-1024x350.png 1024w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\" \/><\/a><\/p>\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: none;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: circle;\">\n<li>In all the places above, the CRMTiger team updated the encryption logic so it would convert encrypted values from the database and decrypt them to display the original value to the user.<\/li>\n<li>When you save a record, either from Edit View, Quick Edit, or Quick Create, it will convert the data into encrypted format in the database.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>I hope you find this blog useful.<\/p>\n<p><span style=\"font-weight: 400;\">Please contact us at\u00a0<a href=\"mailto:info@crmtiger.com\">info@crmtiger.com<\/a> if you need further help from us.<\/span><\/p>\n<p>Let us know if you need more information on this<br \/>\n<a href=\"https:\/\/crmtiger.com\/contact-us.html?utm_source=blog-nm&amp;utm_medium=crmtiger-nm&amp;utm_campaign=del-module-vtiger-nm\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2316 size-full\" src=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2020\/11\/CRMTiger.jpg\" alt=\"img\" width=\"650\" height=\"160\" srcset=\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2020\/11\/CRMTiger.jpg 650w, https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2020\/11\/CRMTiger-300x74.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<div class=\"more-info\">\n<div class=\"more-info\">\n<p><span style=\"color: #00acef;\"><strong>Do you need more information?<\/strong><\/span><\/p>\n<p style=\"color: #000000; font-size: 11pt;\">For any further information \/ queries regarding technology, please email us at\u00a0<a href=\"mailto:info@crmtiger.com\">info@crmtiger.com<\/a><br \/>\nOR call us at\u00a0<span style=\"color: #00acef; font-size: 12pt;\">+1 630 861 8263.<\/span>\u00a0Alternately,\u00a0you can request information by filling out the <a href=\"http:\/\/crmtiger.com\/contact-us.html\">Contact Us<\/a>\u00a0form.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Data security is key in any software, and due to the high number of security-vulnerable algorithms, there are a lot of issues with data security. The vTiger database is easily hacked by the hecklers, who steal important data like customer&#8217;s phone numbers, emails, SSNs, addresses, etc. and sell those data in the market at a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2304","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vtiger-7-1"],"_links":{"self":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/comments?post=2304"}],"version-history":[{"count":10,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2304\/revisions"}],"predecessor-version":[{"id":3890,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2304\/revisions\/3890"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media\/2308"}],"wp:attachment":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media?parent=2304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/categories?post=2304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/tags?post=2304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}