{"id":906,"date":"2013-02-07T21:56:25","date_gmt":"2013-02-08T05:56:25","guid":{"rendered":"http:\/\/www.andreanolanusse.com\/en\/?p=906"},"modified":"2013-02-18T19:36:47","modified_gmt":"2013-02-19T03:36:47","slug":"what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers","status":"publish","type":"post","link":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/","title":{"rendered":"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers?"},"content":{"rendered":"<p>Finally the day has come, Embarcadero acquired AnyDAC and there is a lot to talk about, early last year I invested a lot of time evaluating AnyDAC and know you know why \ud83d\ude42 &#8211; I was very impressive with the amount of features, \u00a0AnyDAC is everything dbExpress tried to be and never reached.<\/p>\n<p>The reason I say that it&#8217;s because AnyDAC really allows developers to target multiples database without the workarounds required by \u00a0dbExpress, like: Field Mapping when you persist the TFields. For long time AnyDAC allowed developers that use Delphi\/C++Builder Professional edition to connect their application to Enterprise databases like Oracle, SQL Server, Sybase, Informix and others, something that was only possible through Enterprise and Architect edition, and much more.<\/p>\n<p>Beyond that, there is a lot of specific database features supported by AnyDAC, which I consider very helpful in any database development, here some examples per database:<\/p>\n<ul>\n<li>For all databases\n<ul>\n<li>Automatic Connection Recovery<\/li>\n<li>Unified DB Events Support<\/li>\n<li>Simplified\u00a0architecture, it means no more Query + ClientDataSet + Provider just for a bi-directional cursor<\/li>\n<li>Much better performance when compared with dbExpress<\/li>\n<li>TADMemTable &#8211; in memory dataset, faster than TClientDataSet<\/li>\n<li>Much easier to migrate BDE applications to AnyDAC than the traditional dbExpress architecture<\/li>\n<\/ul>\n<\/li>\n<li><span style=\"line-height: 13px;\">Oracle<\/span>\n<ul>\n<li>SELECT FOR UPDATE clause &#8211; no more workaround doing UPDATE just to lock the record<\/li>\n<li>Query execution aborting &#8211; we always need that right?<\/li>\n<li>ROWID columns for fast data editing and refreshing<\/li>\n<li>RETURNING clause for fast data refreshing &#8211; no more select after the update to get a new value generated by trigger<\/li>\n<li>and more&#8230;<\/li>\n<\/ul>\n<\/li>\n<li>Firebird\n<ul>\n<li>RETURNING clause for fast data refreshing<\/li>\n<li>Trusted authentication<\/li>\n<li>DB services &#8211; backup, restore, validate, security, etc<\/li>\n<li>Query execution aborting<\/li>\n<\/ul>\n<\/li>\n<li>PostgreSQL\n<ul>\n<li>Yep, now you can connect\u00a0natively\u00a0with PostgreSQL<\/li>\n<li>and more&#8230;<\/li>\n<\/ul>\n<\/li>\n<li>SQL Server\n<ul>\n<li>Batch commands with multiple result sets &#8211; Now you can use that and improve your app performance<\/li>\n<li>Query execution aborting<\/li>\n<li>and more&#8230;<\/li>\n<\/ul>\n<\/li>\n<li>MySQL\n<ul>\n<li>AUTO_INCREMENT columns and retrieving of last inserted value.<\/li>\n<\/ul>\n<\/li>\n<li>Drivers for several databases on Windows, Mac and iOS<\/li>\n<\/ul>\n<p>This is a small list of interesting things on AnyDAC, you can find more <strong><a href=\"http:\/\/www.da-soft.com\/anydac\/personalized-api.html\">here<\/a><\/strong>.<\/p>\n<p>AnyDAC is a step forward and worth the effort to migrate from dbExpress to AnyDAC, there are lot of feature needed by Delphi and C++Builder developers, many of these features has been requested for a long time and you will have when using AnyDAC.<\/p>\n<p>You may ask what is going to happen with dbExpress? BDE is dead, but still around :), dbExpress is not dead and I don&#8217;t think will die soon, but there is no reason to keep two database access technology since AnyDAC is way better than dbExpress.<\/p>\n<p>AnyDAC trial is available for download <strong><a href=\"http:\/\/www.da-soft.com\/anydac\/download.html\" target=\"_blank\">here<\/a><\/strong>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Finally the day has come, Embarcadero acquired AnyDAC and there is a lot to talk about, early last year I invested a lot of time evaluating AnyDAC and know you know why \ud83d\ude42 &#8211; I was very impressive with the amount of features, \u00a0AnyDAC is everything dbExpress tried to be and never reached. The reason [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_s2mail":"yes","footnotes":""},"categories":[11,10],"tags":[93,90,78],"class_list":["post-906","post","type-post","status-publish","format-standard","hentry","category-cbuilder","category-delphi","tag-cbuilder","tag-delphi","tag-embarcadero"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers? | Andreano Lanusse<\/title>\n<meta name=\"description\" content=\"Embarcadero acquired AnyDAC, much better technology than dbExpress, in this article see some of the advantages to start using AnyDAC.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers? | Andreano Lanusse\" \/>\n<meta property=\"og:description\" content=\"Embarcadero acquired AnyDAC, much better technology than dbExpress, in this article see some of the advantages to start using AnyDAC.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\" \/>\n<meta property=\"og:site_name\" content=\"Andreano Lanusse | Technology and Software Development\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-08T05:56:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-19T03:36:47+00:00\" \/>\n<meta name=\"author\" content=\"Andreano Lanusse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andreano Lanusse\" \/>\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\":\"Article\",\"@id\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\"},\"author\":{\"name\":\"Andreano Lanusse\",\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b\"},\"headline\":\"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers?\",\"datePublished\":\"2013-02-08T05:56:25+00:00\",\"dateModified\":\"2013-02-19T03:36:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\"},\"wordCount\":459,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b\"},\"keywords\":[\"C++Builder\",\"Delphi\",\"Embarcadero\"],\"articleSection\":[\"C++Builder\",\"Delphi\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\",\"url\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\",\"name\":\"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers? | Andreano Lanusse\",\"isPartOf\":{\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#website\"},\"datePublished\":\"2013-02-08T05:56:25+00:00\",\"dateModified\":\"2013-02-19T03:36:47+00:00\",\"description\":\"Embarcadero acquired AnyDAC, much better technology than dbExpress, in this article see some of the advantages to start using AnyDAC.\",\"breadcrumb\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.andreanolanusse.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#website\",\"url\":\"https:\/\/www.andreanolanusse.com\/en\/\",\"name\":\"Andreano Lanusse | Technology and Software Development\",\"description\":\"Where Andreano Lanusse talk about technology, software development, programming techniques, databases, games and more through articles, tutorials and videos\",\"publisher\":{\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.andreanolanusse.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b\",\"name\":\"Andreano Lanusse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/49ab23ef70c249c0cb3469f14ef07edc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/49ab23ef70c249c0cb3469f14ef07edc?s=96&d=mm&r=g\",\"caption\":\"Andreano Lanusse\"},\"logo\":{\"@id\":\"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/image\/\"},\"description\":\"Andreano Lanusse is an expert and enthusiastic on software development industry, at Embarcadero he is focused on helping to make sure the products being developed meet the expectations of Embarcadero's customers, as well as defining market strategies for Latin America. Today as Latin Lead Evangelist he spends great deal of time in developer conferences, tradeshows, user group, and visiting customers throughout Latin America. Before Embarcadero, he worked 13 years for Borland, Andreano has worked as Support Coordinator, Engineer, Product Manager, including Product Line Sales Manager, where was responsible to manage the relationship with Brazil developer community, also has worked as Principal Consultant for Borland Consulting Services on the development and management of critical applications. He previously served as Chief Architect for USS Solu\u00e7\u00f5es Gerenciadas (now USS Tempo). Andreano holds a bachelor's degree in Business Administration Marketing Emphasis from Sumare Institute, MBA in Project Management from FGV, certification in Microsoft products, all Borland ALM products, and all CodeGear product line.\",\"sameAs\":[\"http:\/\/www.andreanolanusse.com\",\"https:\/\/x.com\/andreanolanusse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers? | Andreano Lanusse","description":"Embarcadero acquired AnyDAC, much better technology than dbExpress, in this article see some of the advantages to start using AnyDAC.","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:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/","og_locale":"en_US","og_type":"article","og_title":"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers? | Andreano Lanusse","og_description":"Embarcadero acquired AnyDAC, much better technology than dbExpress, in this article see some of the advantages to start using AnyDAC.","og_url":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/","og_site_name":"Andreano Lanusse | Technology and Software Development","article_published_time":"2013-02-08T05:56:25+00:00","article_modified_time":"2013-02-19T03:36:47+00:00","author":"Andreano Lanusse","twitter_misc":{"Written by":"Andreano Lanusse","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#article","isPartOf":{"@id":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/"},"author":{"name":"Andreano Lanusse","@id":"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b"},"headline":"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers?","datePublished":"2013-02-08T05:56:25+00:00","dateModified":"2013-02-19T03:36:47+00:00","mainEntityOfPage":{"@id":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/"},"wordCount":459,"commentCount":10,"publisher":{"@id":"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b"},"keywords":["C++Builder","Delphi","Embarcadero"],"articleSection":["C++Builder","Delphi"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/","url":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/","name":"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers? | Andreano Lanusse","isPartOf":{"@id":"https:\/\/www.andreanolanusse.com\/en\/#website"},"datePublished":"2013-02-08T05:56:25+00:00","dateModified":"2013-02-19T03:36:47+00:00","description":"Embarcadero acquired AnyDAC, much better technology than dbExpress, in this article see some of the advantages to start using AnyDAC.","breadcrumb":{"@id":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.andreanolanusse.com\/en\/what-does-anydac-acquisition-by-embarcadero-mean-for-delphi-and-cbuilder-developers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.andreanolanusse.com\/en\/"},{"@type":"ListItem","position":2,"name":"What does AnyDAC acquisition by Embarcadero mean for Delphi and C++Builder Developers?"}]},{"@type":"WebSite","@id":"https:\/\/www.andreanolanusse.com\/en\/#website","url":"https:\/\/www.andreanolanusse.com\/en\/","name":"Andreano Lanusse | Technology and Software Development","description":"Where Andreano Lanusse talk about technology, software development, programming techniques, databases, games and more through articles, tutorials and videos","publisher":{"@id":"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.andreanolanusse.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":["Person","Organization"],"@id":"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/b51fdf99c01fcd6ae0a5ae894c23837b","name":"Andreano Lanusse","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/49ab23ef70c249c0cb3469f14ef07edc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/49ab23ef70c249c0cb3469f14ef07edc?s=96&d=mm&r=g","caption":"Andreano Lanusse"},"logo":{"@id":"https:\/\/www.andreanolanusse.com\/en\/#\/schema\/person\/image\/"},"description":"Andreano Lanusse is an expert and enthusiastic on software development industry, at Embarcadero he is focused on helping to make sure the products being developed meet the expectations of Embarcadero's customers, as well as defining market strategies for Latin America. Today as Latin Lead Evangelist he spends great deal of time in developer conferences, tradeshows, user group, and visiting customers throughout Latin America. Before Embarcadero, he worked 13 years for Borland, Andreano has worked as Support Coordinator, Engineer, Product Manager, including Product Line Sales Manager, where was responsible to manage the relationship with Brazil developer community, also has worked as Principal Consultant for Borland Consulting Services on the development and management of critical applications. He previously served as Chief Architect for USS Solu\u00e7\u00f5es Gerenciadas (now USS Tempo). Andreano holds a bachelor's degree in Business Administration Marketing Emphasis from Sumare Institute, MBA in Project Management from FGV, certification in Microsoft products, all Borland ALM products, and all CodeGear product line.","sameAs":["http:\/\/www.andreanolanusse.com","https:\/\/x.com\/andreanolanusse"]}]}},"_links":{"self":[{"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/posts\/906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/comments?post=906"}],"version-history":[{"count":0,"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/posts\/906\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/media?parent=906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/categories?post=906"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/en\/wp-json\/wp\/v2\/tags?post=906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}