{"id":178,"date":"2011-10-20T13:30:51","date_gmt":"2011-10-20T17:30:51","guid":{"rendered":"http:\/\/www.eclipsepracticemanagementsoftware.com\/blog\/?p=178"},"modified":"2021-03-10T15:02:11","modified_gmt":"2021-03-10T19:02:11","slug":"eclipse-odbc-under-the-hood","status":"publish","type":"post","link":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/","title":{"rendered":"ECLIPSE, SQL & ODBC: Under the Hood"},"content":{"rendered":"

2020 Update: ECLIPSE now includes custom statement design software with\u00a0 Client\/Server versions.<\/span><\/em><\/p>\n

From 1985 through 1999, ECLIPSE had a proprietary database\u00a0\u2013 designed by me. Performance was as much as 1000 times faster than competitive products. (I received research credit for some of these innovations as part of my graduate studies in computer science.) Of course, there were trade-offs\u2026<\/p>\n

So, 15 years later, in 2000, we moved to a widely used, well-documented, commercial database vendor that specialized in high-performance systems. The new database added a new twist \u2013 it was SQL<\/a> &\u00a0ODBC compliant<\/a>, which provided an immediate advantage to clients. Today, companies from across (and outside) the United States have used SQL & ODBC to customize ECLIPSE, and some have released\u00a0 their own complementary products to handle electronic sign-in, allow patients to schedule their own appointments, interact with social media, etc.<\/p>\n

With an inexpensive ODBC driver (or a\u00a0Server based version of ECLIPSE with SQL), you can create customized reports, databases and screens to link to and access your ECLIPSE data without waiting for us to fit your<\/em> needs to our<\/em> agenda (which is affected by thousands of offices)\u2026 \u00a0We try to handle \u201cmacro\u201d issues \u2013 issues that affect all clients (e.g. Meaningful Use certification). ODBC allows you to handle your own \u201cmicro\u201d issues \u2013 issues more likely to be specific to your office.<\/p>\n

For example, one of the unfortunate things I\u2019ve learned after more than two decades handling thousands of clients is that, when it comes to bills & statements, it\u2019s rare that I can find three offices that agree with one another on the perfect statement. In fact, each office\u2019s concept of \u201cacceptable\u201d seems to vary widely. SQL & ODBC allow you (if you\u2019re a \u201cpower user\u201d or a professional programmer) to create custom statements and reports with nothing from us but a set of specifications. You can even use off-the-shelf products such as Crystal Reports<\/a> to interact with most ECLIPSE data. Companies that specialize in creating reports for ECLIPSE can usually be found by contacting the HELP Desk.<\/p>\n

Among other things, this also means that terms like obsolescence don\u2019t need to enter your vocabulary. (How many of your colleagues have replaced obsolete software over the past 25 years?). An open database means you can add features or port the entire database without worrying about the integrity of your data. And most data — including financial data that relates to the entire practice — can be directly accessed from\u00a0programs that have an ODBC interface. Finally,\u00a0a SQL\/ODBC\u00a0 interface means you interact directly with ECLIPSE data in real time — which is why 3rd parties prefer it.<\/p>\n","protected":false},"excerpt":{"rendered":"

2020 Update: ECLIPSE now includes custom statement design software with\u00a0 Client\/Server versions. From 1985 through 1999, ECLIPSE had a proprietary database\u00a0\u2013 designed by me. Performance was as much as 1000 times faster than competitive products. (I received research credit for … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[12,13],"tags":[],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-general","category-practice-management"],"yoast_head":"\nECLIPSE, SQL & ODBC: Under the Hood - ECLIPSE Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ECLIPSE, SQL & ODBC: Under the Hood - ECLIPSE Blog\" \/>\n<meta property=\"og:description\" content=\"2020 Update: ECLIPSE now includes custom statement design software with\u00a0 Client\/Server versions. From 1985 through 1999, ECLIPSE had a proprietary database\u00a0\u2013 designed by me. Performance was as much as 1000 times faster than competitive products. (I received research credit for … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/\" \/>\n<meta property=\"og:site_name\" content=\"ECLIPSE Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-20T17:30:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-10T19:02:11+00:00\" \/>\n<meta name=\"author\" content=\"Mike Norworth\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mike Norworth\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/\",\"url\":\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/\",\"name\":\"ECLIPSE, SQL & ODBC: Under the Hood - ECLIPSE Blog\",\"isPartOf\":{\"@id\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#website\"},\"datePublished\":\"2011-10-20T17:30:51+00:00\",\"dateModified\":\"2021-03-10T19:02:11+00:00\",\"author\":{\"@id\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#\/schema\/person\/77b0ff03a4cb25079e40a98746886c81\"},\"breadcrumb\":{\"@id\":\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ECLIPSE, SQL & ODBC: Under the Hood\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#website\",\"url\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/\",\"name\":\"ECLIPSE Blog\",\"description\":\"Direct from the developers... Mike Norworth & Dr. Karen Walters. D.C.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#\/schema\/person\/77b0ff03a4cb25079e40a98746886c81\",\"name\":\"Mike Norworth\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fc5b4af7c33087471c7bf77771ef82b1129f08a383a46013509b986d8addb3dd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fc5b4af7c33087471c7bf77771ef82b1129f08a383a46013509b986d8addb3dd?s=96&d=mm&r=g\",\"caption\":\"Mike Norworth\"},\"sameAs\":[\"http:\/\/www.eclipsepracticemanagementsoftware.com\"],\"url\":\"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/author\/mikenorworth\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ECLIPSE, SQL & ODBC: Under the Hood - ECLIPSE Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/","og_locale":"en_US","og_type":"article","og_title":"ECLIPSE, SQL & ODBC: Under the Hood - ECLIPSE Blog","og_description":"2020 Update: ECLIPSE now includes custom statement design software with\u00a0 Client\/Server versions. From 1985 through 1999, ECLIPSE had a proprietary database\u00a0\u2013 designed by me. Performance was as much as 1000 times faster than competitive products. (I received research credit for … Continue reading →","og_url":"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/","og_site_name":"ECLIPSE Blog","article_published_time":"2011-10-20T17:30:51+00:00","article_modified_time":"2021-03-10T19:02:11+00:00","author":"Mike Norworth","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mike Norworth","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/","url":"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/","name":"ECLIPSE, SQL & ODBC: Under the Hood - ECLIPSE Blog","isPartOf":{"@id":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#website"},"datePublished":"2011-10-20T17:30:51+00:00","dateModified":"2021-03-10T19:02:11+00:00","author":{"@id":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#\/schema\/person\/77b0ff03a4cb25079e40a98746886c81"},"breadcrumb":{"@id":"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/eclipsepracticemanagementsoftware.com\/blog\/2011\/10\/20\/eclipse-odbc-under-the-hood\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ECLIPSE, SQL & ODBC: Under the Hood"}]},{"@type":"WebSite","@id":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#website","url":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/","name":"ECLIPSE Blog","description":"Direct from the developers... Mike Norworth & Dr. Karen Walters. D.C.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#\/schema\/person\/77b0ff03a4cb25079e40a98746886c81","name":"Mike Norworth","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fc5b4af7c33087471c7bf77771ef82b1129f08a383a46013509b986d8addb3dd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fc5b4af7c33087471c7bf77771ef82b1129f08a383a46013509b986d8addb3dd?s=96&d=mm&r=g","caption":"Mike Norworth"},"sameAs":["http:\/\/www.eclipsepracticemanagementsoftware.com"],"url":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/author\/mikenorworth\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1Kj8h-2S","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=178"}],"version-history":[{"count":13,"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":708,"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/178\/revisions\/708"}],"wp:attachment":[{"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eclipsepracticemanagementsoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}