{"id":8399,"date":"2025-11-07T22:51:59","date_gmt":"2025-11-07T22:51:59","guid":{"rendered":"https:\/\/wiki.xontel.com\/?post_type=manual_documentation&#038;p=8399"},"modified":"2025-11-07T22:52:00","modified_gmt":"2025-11-07T22:52:00","slug":"odbc-settings","status":"publish","type":"manual_documentation","link":"https:\/\/wiki.xontel.com\/ar\/documentation\/telsip-cloud-call-center\/call-center-v-1-x-x\/settings\/odbc-settings\/","title":{"rendered":"ODBC Settings"},"content":{"rendered":"<p>The ODBC Settings section allows administrators to configure and manage database connections using the Open Database Connectivity (ODBC) standard. These settings enable the system to interface with external databases, essential for logging, reporting, and analytics.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large image-border\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"359\" src=\"https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47-1024x359.png\" alt=\"\" class=\"wp-image-8400\" srcset=\"https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47-1024x359.png 1024w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47-300x105.png 300w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47-768x269.png 768w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47-1536x539.png 1536w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47-18x6.png 18w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/11\/image-47.png 1878w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p style=\"font-size:20px\"><strong>Add ODBC Manager<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large image-border\"><img decoding=\"async\" width=\"771\" height=\"1024\" src=\"https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/05\/image-128-771x1024.png\" alt=\"\" class=\"wp-image-3515\" srcset=\"https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/05\/image-128-771x1024.png 771w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/05\/image-128-226x300.png 226w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/05\/image-128-768x1020.png 768w, https:\/\/wiki.xontel.com\/wp-content\/uploads\/2025\/05\/image-128.png 994w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p><strong>ODBC Driver<\/strong>: Select the appropriate driver for the database type (e.g., PostgreSQL, MySQL, MyOracle).<\/p>\n\n\n\n<p><strong>Database<\/strong>: Name of the target database you wish to connect to.<\/p>\n\n\n\n<p><strong>Table Name<\/strong>: Specific table within the database that holds the desired data.<\/p>\n\n\n\n<p><strong>ODBC Server<\/strong>: Hostname or IP address of the database server.<\/p>\n\n\n\n<p><strong>User Name<\/strong>: The database username used for authentication.<\/p>\n\n\n\n<p><strong>Password<\/strong>: The secure password associated with the provided username.<\/p>\n\n\n\n<p><strong>Column Name<\/strong>: Used to identify the specific column in the table that holds the key data (e.g., contact number).<\/p>\n\n\n\n<p><strong>Column Number<\/strong>: The index of the column to be read (starting from 0 or 1, depending on the system&#8217;s indexing logic).<\/p>\n\n\n\n<p><strong>Contact Details Template<\/strong>: Define how contact details should be displayed using dynamic placeholders. For example: <code>Name: {{name}}, Phone: {{phone}}<\/code>.<\/p>\n\n\n\n<p><strong>Active<\/strong>: Toggle to activate or deactivate this ODBC connection.<\/p>\n\n\n\n<p><\/p>","protected":false},"author":1,"featured_media":0,"parent":8374,"menu_order":9,"template":"","manualdocumentationcategory":[45],"manual_doc_tag":[],"class_list":["post-8399","manual_documentation","type-manual_documentation","status-publish","hentry","manualdocumentationcategory-telsip"],"_links":{"self":[{"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manual_documentation\/8399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manual_documentation"}],"about":[{"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/types\/manual_documentation"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manual_documentation\/8399\/revisions"}],"predecessor-version":[{"id":8401,"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manual_documentation\/8399\/revisions\/8401"}],"up":[{"embeddable":true,"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manual_documentation\/8374"}],"wp:attachment":[{"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/media?parent=8399"}],"wp:term":[{"taxonomy":"manualdocumentationcategory","embeddable":true,"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manualdocumentationcategory?post=8399"},{"taxonomy":"manual_doc_tag","embeddable":true,"href":"https:\/\/wiki.xontel.com\/ar\/wp-json\/wp\/v2\/manual_doc_tag?post=8399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}