{"id":1716,"date":"2016-12-19T16:58:53","date_gmt":"2016-12-19T16:58:53","guid":{"rendered":"https:\/\/wetransform.eu\/?post_type=news-and-events&#038;p=1716"},"modified":"2022-07-08T13:46:07","modified_gmt":"2022-07-08T13:46:07","slug":"halestudio-3-1","status":"publish","type":"news-and-events","link":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/","title":{"rendered":"hale\u00bbstudio 3.1 brings MS SQL Server Support"},"content":{"rendered":"<p>Just in time for the new year, we have a nice gift for all of you: The latest hale\u00bbstudio release is ready! There were several main areas of work in the past months, largely driven by your requirements and support.<\/p>\n<p>These are the highlight features we've added:<\/p>\n<ul>\n<li>Read and write Microsoft SQL Server databases, including support for Geography and Geometry column types<\/li>\n<li>Add custom validation rules by integrating a Schematron validator <\/li>\n<li>Use SKOS code lists<\/li>\n<li>Validate against code list values<\/li>\n<li>View instance counts for condition contexts instantly<\/li>\n<li>Hide optional properties<\/li>\n<li>GML Encoding: Specify a number format for geometry ordinates, e.g. if you want a fixed precision<\/li>\n<li>GML Encoding: Perform strict Simple Features SF-0 profile encoding for geometries<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/mssql.png\" alt=\"hale\u00bbstudio 3.1.0 Load from MS SQL Server Database\" \/><\/p>\n<p>We've also fixed several bugs and added smaller improvements. The whole list is available in the <a href=\"https:\/\/github.com\/halestudio\/hale\/blob\/master\/CHANGELOG.md#310\">changelog<\/a>.<\/p>\n<p>Get the latest version, and let us know what you think of it!<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/halestudio\/hale\/releases\">Downloads on Github<\/a><\/li>\n<li><a href=\"http:\/\/help.halestudio.org\/latest\/index.jsp\">Online Help<\/a><\/li>\n<li><a href=\"https:\/\/discuss.wetransform.to\">Support Forum<\/a><\/li>\n<\/ul>\n<h2>MS SQL Server Support<\/h2>\n<p>hale\u00bbstudio already supports most of the common relational database management systems, such as Microsoft SQL Server, PostGreSQL and Oracle (via the <a href=\"https:\/\/www.wetransform.to\/services\/support\/\">subscription plugins<\/a>). The one glaring omission was Microsoft SQL Server, for which we have now added reader and writer support.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/import-ms-sql.png\" alt=\"import ms sql\" \/><\/p>\n<p>We have tested our implementation with SQL Server versions up to 2012. Let us know if you find any issues with newer versions. Thanks to the Bundesanstalt f\u00fcr Wasserbau for funding this work!<\/p>\n<h2>SKOS Codelists and Codelist value Validation<\/h2>\n<p>Codelists and their cousin Enumerations are a cornerstone of data specifications and data quality. They are used by most of you to ensure that only a set of agreed values is used for certain properties of objects. While the spatial data community, and in particular INSPIRE, has defined some specific formats for such codelists, there are also formats such as SKOS (<a href=\"https:\/\/www.w3.org\/2004\/02\/skos\/\">Simple Knowledge Organisation System<\/a>) that are in wide use - not only for Linked Data. Now you can load SKOS resources as code lists in hale studio, where a SKOS concept represents an individual code. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/codevalidation.png\" alt=\"Code Validation\" \/><\/p>\n<p>In addition, we've added codelist value and reference validation to the live validation in hale studio. Thanks to the Bundesanstalt f\u00fcr Wasserbau for funding this work!<\/p>\n<h2>Context Counts<\/h2>\n<p>To filter source data by the value of one or more properties, you can define contexts for the mapping. When you have loaded source data in hale studio, you can now see directly how many instances and values there are that match these contexts. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/contexts.png\" alt=\"define contexts for the mapping\" \/><\/p>\n<h2>Again, Improved Compliance with INSPIRE Data Specifications 4.0<\/h2>\n<p>The INSPIRE data specifications mandate usage of the GML SF-0 profile for all of the Annex I themes except Cadastral Parcels. We have now improved the encoding and transformation to better create allowed geometry structures in such cases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just in time for the new year, we have a nice gift for all of you: The latest hale\u00bbstudio release is ready! There were several main areas of work in the past months, largely driven by your requirements and support. These are the highlight features we&#8217;ve added: Read and write Microsoft SQL Server databases, including [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[26],"tags":[21,27],"class_list":["post-1716","news-and-events","type-news-and-events","status-publish","hentry","category-release-notes","tag-halestudio","tag-product-update"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.6 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>hale\u00bbstudio 3.1 brings MS SQL Server Support - wetransform<\/title>\n<meta name=\"description\" content=\"For the hale\u00bbstudio 3.1 release there were several main areas of work, including Microsoft SQL Server Support.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"hale\u00bbstudio 3.1 brings MS SQL Server Support\" \/>\n<meta property=\"og:description\" content=\"For the hale\u00bbstudio 3.1 release there were several main areas of work, including Microsoft SQL Server Support.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/\" \/>\n<meta property=\"og:site_name\" content=\"wetransform\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-08T13:46:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/mssql.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@wetransformto\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/\",\"url\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/\",\"name\":\"hale\u00bbstudio 3.1 brings MS SQL Server Support - wetransform\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/wetransform.to\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wetransform.eu\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/mssql.png\",\"datePublished\":\"2016-12-19T16:58:53+00:00\",\"dateModified\":\"2022-07-08T13:46:07+00:00\",\"description\":\"For the hale\u00bbstudio 3.1 release there were several main areas of work, including Microsoft SQL Server Support.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wetransform.eu\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/mssql.png\",\"contentUrl\":\"https:\\\/\\\/wetransform.eu\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/mssql.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/halestudio-3-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wetransform.to\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"News & Events\",\"item\":\"https:\\\/\\\/wetransform.to\\\/de\\\/news-and-events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"hale\u00bbstudio 3.1 brings MS SQL Server Support\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/wetransform.to\\\/de\\\/#website\",\"url\":\"http:\\\/\\\/wetransform.to\\\/de\\\/\",\"name\":\"wetransform\",\"description\":\"Making environmental data useful and accessible\",\"publisher\":{\"@id\":\"http:\\\/\\\/wetransform.to\\\/de\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/wetransform.to\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/wetransform.to\\\/de\\\/#organization\",\"name\":\"wetransform\",\"url\":\"http:\\\/\\\/wetransform.to\\\/de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"http:\\\/\\\/wetransform.to\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wetransform.to\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/large-logo-whitebg.png\",\"contentUrl\":\"https:\\\/\\\/wetransform.to\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/large-logo-whitebg.png\",\"width\":1024,\"height\":1024,\"caption\":\"wetransform\"},\"image\":{\"@id\":\"http:\\\/\\\/wetransform.to\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/wetransformto\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wetransform-gmbh\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"hale\u00bbstudio 3.1 brings MS SQL Server Support - wetransform","description":"For the hale\u00bbstudio 3.1 release there were several main areas of work, including Microsoft SQL Server Support.","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":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/","og_locale":"de_DE","og_type":"article","og_title":"hale\u00bbstudio 3.1 brings MS SQL Server Support","og_description":"For the hale\u00bbstudio 3.1 release there were several main areas of work, including Microsoft SQL Server Support.","og_url":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/","og_site_name":"wetransform","article_modified_time":"2022-07-08T13:46:07+00:00","og_image":[{"url":"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/mssql.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@wetransformto","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/","url":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/","name":"hale\u00bbstudio 3.1 brings MS SQL Server Support - wetransform","isPartOf":{"@id":"http:\/\/wetransform.to\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/#primaryimage"},"image":{"@id":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/#primaryimage"},"thumbnailUrl":"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/mssql.png","datePublished":"2016-12-19T16:58:53+00:00","dateModified":"2022-07-08T13:46:07+00:00","description":"For the hale\u00bbstudio 3.1 release there were several main areas of work, including Microsoft SQL Server Support.","breadcrumb":{"@id":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/#primaryimage","url":"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/mssql.png","contentUrl":"https:\/\/wetransform.eu\/wp-content\/uploads\/2022\/05\/mssql.png"},{"@type":"BreadcrumbList","@id":"https:\/\/wetransform.to\/de\/news-and-events\/halestudio-3-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wetransform.to\/de\/"},{"@type":"ListItem","position":2,"name":"News & Events","item":"https:\/\/wetransform.to\/de\/news-and-events\/"},{"@type":"ListItem","position":3,"name":"hale\u00bbstudio 3.1 brings MS SQL Server Support"}]},{"@type":"WebSite","@id":"http:\/\/wetransform.to\/de\/#website","url":"http:\/\/wetransform.to\/de\/","name":"wetransform","description":"Making environmental data useful and accessible","publisher":{"@id":"http:\/\/wetransform.to\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/wetransform.to\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"http:\/\/wetransform.to\/de\/#organization","name":"wetransform","url":"http:\/\/wetransform.to\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"http:\/\/wetransform.to\/de\/#\/schema\/logo\/image\/","url":"https:\/\/wetransform.to\/wp-content\/uploads\/2022\/07\/large-logo-whitebg.png","contentUrl":"https:\/\/wetransform.to\/wp-content\/uploads\/2022\/07\/large-logo-whitebg.png","width":1024,"height":1024,"caption":"wetransform"},"image":{"@id":"http:\/\/wetransform.to\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/wetransformto","https:\/\/www.linkedin.com\/company\/wetransform-gmbh\/"]}]}},"_links":{"self":[{"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/news-and-events\/1716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/news-and-events"}],"about":[{"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/types\/news-and-events"}],"author":[{"embeddable":true,"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/comments?post=1716"}],"version-history":[{"count":2,"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/news-and-events\/1716\/revisions"}],"predecessor-version":[{"id":2393,"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/news-and-events\/1716\/revisions\/2393"}],"wp:attachment":[{"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/media?parent=1716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/categories?post=1716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wetransform.to\/de\/wp-json\/wp\/v2\/tags?post=1716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}