{"id":7374,"date":"2023-05-12T10:16:42","date_gmt":"2023-05-12T08:16:42","guid":{"rendered":"https:\/\/wp.delphin.de\/?post_type=glossar&#038;p=7374"},"modified":"2026-07-02T08:57:13","modified_gmt":"2026-07-02T06:57:13","slug":"odbc","status":"publish","type":"glossar","link":"https:\/\/www.delphin.de\/en\/glossar\/odbc\/","title":{"rendered":"ODBC (Open Database Connectivity)"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><strong>ODBC (Open Database Connectivity)<\/strong> is a vendor-neutral, standardized interface for accessing relational database systems. It was developed by Microsoft in the early 1990s based on the SQL specification of the SQL Access Group and has since established itself as a cross-industry standard. ODBC uses the following database language: <strong>SQL<\/strong> \u2013 commonly referred to as \u201eStructured Query Language,\u201c but according to the ANSI definition, it is a proper noun. The key advantage of ODBC is that applications can access a wide variety of database systems via a unified application programming interface (API) without having to develop a separate, proprietary connection for each system.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How does ODBC work?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">ODBC acts as an intermediary layer between an application and a database system. When a program wants to access a database, it does not send its query directly to the database system, but rather to the <strong>ODBC Driver Manager<\/strong>. This forwards the request to the appropriate, vendor-specific ODBC driver, which in turn handles the actual communication with the database and returns the results in a standardized format. Thanks to this architecture, it doesn\u2019t matter whether Microsoft SQL Server, Oracle, MySQL, DB2, or another relational database is running in the background\u2014the application always communicates via the same, uniform interface and the same SQL command set. This makes ODBC-based solutions particularly flexible, cross-platform, and easy to maintain, since changing the database system usually requires only replacing the driver.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why is ODBC relevant in measurement technology?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In industrial measurement data acquisition, large volumes of measurement and process data are often generated; this data should not be viewed in isolation but rather in the context of other company data\u2014such as test specimen parameters, order data, formulas, or results from previous test runs. An ODBC interface allows measurement software to be directly connected to standard enterprise databases or ERP systems. This allows setpoints and test parameters to be automatically retrieved from a database before a measurement begins, and the processed results to be automatically written back to the database once the measurement is complete. This reduces manual data entry, prevents data entry errors, and lays the foundation for fully automated, traceable test and measurement processes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">ODBC at Delphin \u2013 Practical Applications<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In measurement technology software <strong>ProfiSignal<\/strong> Delphin Technology provides an SQL\/ODBC interface as a programming interface to relational database systems such as Microsoft SQL Server, Oracle, or MySQL. This allows, for example, test specimen parameters to be imported from a test bench database and the test results recorded and preprocessed by ProfiSignal to be automatically written back. In combination with other interfaces provided by the measurement software, ODBC helps seamlessly integrate measurement data acquisition, test bench automation, and higher-level enterprise systems.<\/p>","protected":false},"featured_media":0,"template":"","class_list":["post-7374","glossar","type-glossar","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.delphin.de\/en\/wp-json\/wp\/v2\/glossar\/7374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.delphin.de\/en\/wp-json\/wp\/v2\/glossar"}],"about":[{"href":"https:\/\/www.delphin.de\/en\/wp-json\/wp\/v2\/types\/glossar"}],"wp:attachment":[{"href":"https:\/\/www.delphin.de\/en\/wp-json\/wp\/v2\/media?parent=7374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}