Question Benjamin De Boe · Nov 13 Charting lineage across views and statements Hi, A customer today asked whether we could offer anything like the nice lineage charts that dbt offers, based on SQL view metadata. They are very much aware of our dbt-iris adapter, but were asking in the context of their landing area, which combines foreign tables and views, ahead of possibly using dbt for onward transformations. #Data Model #SQL #InterSystems IRIS 0 0 0 47
Article Benjamin De Boe · Jun 6 4m read Connecting to Cloud SQL from Microsoft Power BI using ODBC and TLS/SSL We're excited to continue to roll out new features to InterSystems IRIS Cloud SQL, such as the new Vector Search capability that was first released with InterSystems IRIS 2024.1. Cloud SQL is a cloud service that offers exactly that: SQL access in the cloud. That means you'll be using industry-standard driver technologies such as JDBC, ODBC, and DB-API to connect to this service and access your data. The documentation describes in proper detail how to configure the important driver-level settings, but doesn't cover specific third-party tools as - as you can imagine - there's an infinite number of them. In this article, we'll complement that reference documentation with more detailed steps for a popular third-party data visualization tool that several of our customers use to access IRIS-based data: Microsoft Power BI. #Cloud #ODBC #Security #SQL #SSL #InterSystems IRIS 8 17 0 349
InterSystems Official Benjamin De Boe · Jan 11 InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML are now Generally Available InterSystems is pleased to announce the General Availability of InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML, two foundational services for developing cloud-native solutions powered by the proven, enterprise-class performance and reliability of InterSystems IRIS technology. #Cloud #IntegratedML #SQL #InterSystems IRIS #InterSystems Official 10 2 0 322
Announcement Benjamin De Boe · Nov 14, 2023 New White Paper on the use of reporting nodes with mirroring We recently published a new White Paper on the use of reporting nodes ("asynchronous reporting mirror members" in full) in a mirrored environment. More and more customers are looking into this mechanism as a quick and easy way to set up a copy of their production data that stays current, yet can be used for analytical querying or heavy-duty reporting workloads without impacting the source system. Read the White Paper here. #Analytics #Mirroring #Developer Community Official #InterSystems IRIS #InterSystems IRIS for Health 1 0 1 168
Article Benjamin De Boe · Nov 9, 2023 3m read Connecting to Cloud SQL with DBeaver using SSL/TLS With the release of InterSystems IRIS Cloud SQL, we're getting more frequent questions about how to establish secure connections over JDBC and other driver technologies. While we have nice summary and detailed documentation on the driver technologies themselves, our documentation does not go as far to describe individual client tools, such as our personal favourite DBeaver. In this article, we'll describe the steps to create a secure connection from DBeaver to your Cloud SQL deployment. #Cloud #JDBC #Security #SQL #SSL #InterSystems IRIS 9 20 2 1.5K
InterSystems Official Benjamin De Boe · Sep 21, 2023 Deprecation of InterSystems IRIS NLP, formerly known as iKnow InterSystems has decided to stop further development of the InterSystems IRIS Natural Language Processing, formerly known as iKnow, technology and label it as deprecated as of the 2023.3 release of InterSystems IRIS. InterSystems will continue to support existing customers using the technology, but does not recommend starting new development projects outside of the core text exploration use cases it was originally designed for. #iFind #Large Language Model (LLM) #InterSystems Natural Language Processing (NLP, iKnow) #InterSystems IRIS #InterSystems Official 7 7 0 732
InterSystems Official Benjamin De Boe · Jun 30, 2023 Developer Access Program for InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML InterSystems IRIS Cloud SQL is a fully managed cloud service that brings the power of InterSystems IRIS relational database capabilities used by thousands of enterprise customers to a broad audience of application developers and data professionals. InterSystems IRIS Cloud IntegratedML is an option to this database-as-a-service that offers easy access to powerful Automated Machine Learning capabilities in a SQL-native form, through a set of simple SQL commands that can easily be embedded in application code to augment them with ML models that run close to the data. Today, we announce the Developer Access Program for these two offerings. Application developers can now self-register for the service, create deployments and start building composable applications and smart data services, with all provisioning, configuration and administration taken care of by the service. #Cloud #IntegratedML #SQL #InterSystems IRIS #InterSystems Official 5 0 0 344
Announcement Benjamin De Boe · Jun 13, 2023 Join the Early Access Program for Foreign Tables Last week at the InterSystems Global Summit, we announced our new Foreign Tables capability, which was introduced as an experimental feature with the 2023.1 release earlier this year. #Early Access Program (EAP) #Relational Tables #SQL #InterSystems IRIS 7 0 0 284
Article Benjamin De Boe · Feb 13, 2023 4m read When to use Columnar Storage With InterSystems IRIS 2022.2, we introduced Columnar Storage as a new option for persisting your IRIS SQL tables that can boost your analytical queries by an order of magnitude. The capability is marked as experimental in 2022.2 and 2022.3, but will "graduate" to a fully supported production capability in the upcoming 2023.1 release. The product documentation and this introductory video, already describe the differences between row storage, still the default on IRIS and used throughout our customer base, and columnar table storage and provide high-level guidance on choosing the appropriate storage layout for your use case. In this article, we'll elaborate on this subject and share some recommendations based on industry-practice modelling principles, internal testing, and feedback from Early Access Program participants. #Analytics #Columnar Storage #SQL #Vector Search #InterSystems IRIS 14 2 2 582
Article Benjamin De Boe · Jan 10, 2023 4m read Columnar Storage in 2022.3 As you may well remember from Global Summit 2022 or the 2022.2 launch webinar, we're releasing an exciting new capability for including in your analytics solutions on InterSystems IRIS. Columnar Storage introduces an alternative way of storing your SQL table data that offers an order-of-magnitude speedup for analytical queries. First released as an experimental feature in 2022.2, the latest 2022.3 Developer Preview includes a bunch of updates we thought were worth a quick post here. #Columnar Storage #SQL #Vector Search #InterSystems IRIS Open Exchange app 9 2 3 690
Article Benjamin De Boe · Oct 18, 2022 6m read Keeping the API happy - SQL utilities cleanup With IRIS 2021.1, we released a significant revision our SQL utilities API at %SYSTEM.SQL. Yes, that's a while ago now, but last week a customer asked a few questions about this and then @Tom Woodfin applied gentle mental pressure ;-) to make me describe the rationale of these changes in a little more detail on the Developer Community. So here we go! #SQL #InterSystems IRIS 9 1 2 704
Article Benjamin De Boe · Sep 13, 2022 8m read CI/CD with IRIS SQL In the vast and varied SQL database market, InterSystems IRIS stands out as a platform that goes way beyond just SQL, offering a seamless multimodel experience and supporting a rich set of development paradigms. Especially the advanced Object-Relational engine has helped organizations use the best-fit development approach for each facet of their data-intensive workloads, for example ingesting data through Objects and simultaneously querying it through SQL. Persistent Classes correspond to SQL tables, their properties to table columns and business logic is easily accessed using User-Defined Functions or Stored Procedures. In this article, we'll zoom in on a little bit of the magic just below the surface, and discuss how it may affect your development and deployment practices. This is an area of the product where we have plans to evolve and improve, so please don't hesitate to share your views and experiences using the comments section below. #Best Practices #Continuous Delivery #Continuous Integration #Source Control #SQL #InterSystems IRIS 11 6 0 899
Article Benjamin De Boe · Dec 15, 2021 4m read 2021.2 SQL Feature Spotlight - Advanced Table Statistics This is the third article in our short series around innovations in IRIS SQL that deliver a more adaptive, high-performance experience for analysts and applications querying relational data on IRIS. It may be the last article in this series for 2021.2, but we have several more enhancements lined up in this area. In this article, we'll dig a little deeper into additional table statistics we're starting to gather in this release: Histograms #Relational Tables #SQL #InterSystems IRIS 10 0 0 506
Article Benjamin De Boe · Dec 15, 2021 4m read 2021.2 SQL Feature Spotlight - Smart Sampling & Automation for Table Statistics This is the second piece in our series on 2021.2 SQL enhancements delivering an adaptive, high-performance SQL experience. In this article, we'll zoom in on the innovations in gathering Table Statistics, which are of course the primary input for the Run Time Plan Choice capability we described in the previous article. #Relational Tables #SQL #InterSystems IRIS 11 4 1 759
Article Benjamin De Boe · Dec 15, 2021 4m read 2021.2 SQL Feature Spotlight - Run Time Plan Choice The 2021.2 release of the InterSystems IRIS Data Platform includes many exciting new features for fast, flexible and secure development of your mission-critical applications. Embedded Python definitely takes the limelight (and for good reason!), but in SQL we've also made a massive step forward towards a more adaptive engine that gathers detailed statistical information about your table data and exploits it to deliver the best query plans. In this brief series of articles, we'll take a closer at three elements that are new in 2021.2 and work together towards this goal, starting with Run Time Plan Choice. It's hard to figure out the right order to talk about these (you can't imagine how often I've reshuffled them in writing this article!) because they fit together in such a nice way. As such, feel free to go on a limb and read these in random order . #Relational Tables #SQL #InterSystems IRIS 13 2 1 708
InterSystems Official Benjamin De Boe · Jun 14, 2021 InterSystems IRIS, InterSystems IRIS for Health & HealthShare Health Connect 2021.1 are now Generally Available InterSystems is very pleased to announce the 2021.1 release of InterSystems IRIS Data Platform, InterSystems IRIS for Health and HealthShare Health Connect, which are now Generally Available to our customers and partners. The enhancements in this release offer developers more freedom to build fast and robust applications in their language of choice, both server-side and client-side. This release also enables users to consume large amounts of information more effectively through new and faster analytics capabilities. #Release #Health Connect #InterSystems IRIS #InterSystems IRIS for Health #InterSystems Official 6 28 1 1.7K
InterSystems Official Benjamin De Boe · Apr 21, 2021 InterSystems IRIS, IRIS for Health and Health Connect 2021.1 previews are now published Preview releases are now available for the 2021.1 version of InterSystems IRIS, IRIS for Health and HealthShare Health Connect. As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together. #Release #Health Connect #InterSystems IRIS #InterSystems IRIS for Health #InterSystems Official 5 6 0 882
InterSystems Official Benjamin De Boe · Apr 8, 2021 InterSystems IRIS and IRIS for Health 2020.4 are now Generally Available (GA) GA releases are now available for the 2020.4 version of InterSystems IRIS, InterSystems IRIS for Health and InterSystems IRIS Studio. InterSystems IRIS Data Platform 2020.4 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos. It has many new capabilities including: Enhancements for application and interface developers, including: #Release #InterSystems IRIS #InterSystems IRIS for Health #InterSystems Official 3 1 0 418
Article Benjamin De Boe · Feb 23, 2021 1m read IRIS memory configuration wizard - looking for feedback Hi, I just published isc-mem-config on OpenExchange and ZPM. It's a prototype to test whether this kind of user experience (UX) is a good fit for novice and / or more seasoned users. The settings it generates are already fairly-good-practice :-), but also being reviewed by experts within InterSystems in parallel. #InterSystems IRIS Open Exchange app 3 2 1 193
Discussion Benjamin De Boe · Nov 9, 2020 Accent sensitivity and other internationalization issues Hi, InterSystems IRIS has long supported the obvious translation functions required to for converting to upper or lowercase to enforce case-insensitive string comparison (e.g. in ObjectScript with $zconvert) and sorting (e.g. with SQL collation functions, not to be confused with NLS collation). Customers in international contexts have at times used custom workarounds to also treat accent insensitivity or even more advanced normalization duct tape. We’re looking to address such use cases at the system and SQL level to increase convenience for this international audience, which is well represented on the Developer Community. #ObjectScript #SQL #InterSystems IRIS 1 5 0 300