Search

Clear filter
Announcement
Tony Coffman · Nov 20, 2019

Ad Hoc Reporting for InterSystems Platforms now on Open Exchange

Hello InterSystems Community, We're excited to announce that we've completed our first Open Exchange submission for InterSystems platforms. BridgeWorks VDM is an ad hoc reporting and graphical SQL query builder application that was designed for any user who needs access to their SQL projections in InterSystems Caché, InterSystems IRIS, InterSystems IRIS for Health databases as well as access to InterSystems DeepSee and InterSystems IRIS BI Cubes with minimal SQL scripting experience. VDM features: Drag and a drop query builder Interactive Data and Pivot grids Charting and Gauges Data Visualizations Banded Report Writer Report Scheduling and Batching Web reporting capabilities Data export to PDF, Excel, HTML, Word, CSV, Text Files, Image and more VDM leverages the Managed Provider for .Net to communicate with InterSystems databases, and no ODBC drivers are needed to access the SQL projections for InterSystems Caché, InterSystems IRIS and InterSystems IRIS for Health. VDM accesses DeepSee.RESTClient.cls for building MDX queries and communication with InterSystems DeepSee and InterSystems IRIS BI. Video walk through: jQuery(document).ready(function ($){$("#youtubexM5LKB0G25E").css("height",$("#youtubexM5LKB0G25E").css("width").replace(/[^0-9]/gim,"")/(560/315));$(window).resize(function(){ $("#youtubexM5LKB0G25E").css("height",$("#youtubexM5LKB0G25E").css("width").replace(/[^0-9]/gim,"")/(560/315));});}); Notes: While VDM is not a SQL syntax editor, the graphical query builder can be bypassed and SQL scripts can be pasted directly into the Advanced Query form for execution against your InterSystems database. The InterSystems DeepSee and InterSystems IRIS BI features are currently EAP. Community feedback on our project is appreciated.
Announcement
Anastasia Dyubaylo · Sep 6, 2019

[September 25, 2019] Join the InterSystems Developers Meetup in Boston

Hey Developers! Please join the upcoming InterSystems Developers Meetup in Boston which will be held on September 25th, 2019! It will take place in Boston Marriott Copley Place from 5:30 p.m. to 9 p.m. We meet to discuss solutions development on InterSystems IRIS. Come to tell your stories and share experience with InterSystems data platforms, for networking and developer conversations. Drinks and snacks will be provided. The format is usual: 15 min for a session, 5 min for Q&A. Here is the current agenda for the event: TIME TOPIC SPEAKER 5:30 p.m. Welcome and Introduction 6:00 p.m. Using Python Gateway with InterSystems IRIS @Eduard.Lebedyuk, InterSystems 6:20 p.m. VSCode ObjectScript - your IDE for InterSystems IRIS development @Dmitry.Maslennikov, CaretDev 6:40 p.m. Using Package Manager for deployment InterSystems Solutions @Evgeny.Shvarov, InterSystems 7:20 p.m. Coffee break 7:40 p.m. Falling in love with Visual Studio Code @John.Murray, George James Software 8:00 p.m. InterSystems IRIS and the Cloud @Anton.Umnikov, InterSystems 8:20 p.m. How Your Code Matters! @Dmitry.Maslennikov, CaretDev 8:40 p.m. Coffee break Note: If you want to present your story, please contact @Evgeny.Shvarov or @Anastasia.Dyubaylo in Direct Messages. Your stories are very welcome! So! Don't miss an excellent opportunity to meet and discuss new solutions with like-minded peers and to find out what's new in InterSystems technology. ⏱ Time: September 25, 2019 from 5:30 p.m. to 9 p.m. 📍Place: Champions Restaurant (Left Field Room), located on the 2nd floor of the Boston Marriott Copley Place ✅ Registration: RSVP for Boston InterSystems Developers Meetup* We look forward to seeing you! --- *Space is limited, so register today to secure your place. Admission free, registration is mandatory for attendees. Hi folks!If you happen to visit Global Summit 2019 this year - please join us on InterSystems Developers meetup on the last day of the summit, just after DevOps and AI symposium at the same building.Come to Champions, Copley at 5-30pm to chat and discuss in a relaxed atmosphere your dev experience with InterSystems IRIS.RSVP here ;)See you in Boston! Will this presentation be recorded. I cannot attend due to distance but will like to view this presentationThanksGeoV Hi George!Yes, we plan to have a Livestream. Stay tuned with the topic - we'll publish the link. This will be on Developers Video channel. Agenda update for the meetup: "InterSystems IRIS and the Cloud" session by @Anton.Umnikov “In this session we'll talk about how IRIS can interoperate with various components of the public cloud ecosystem, such as S3 storage, SageMaker machine learning framework, Elastic Map Reduce and others.” Space is limited, RSVP today! A bit more about my session "Falling in love with Visual Studio Code": According to the 2019 StackOverflow Developer Survey, Visual Studio Code is number 1. More than 50% of those surveyed said they use it. Why is it so popular? Why do I like it? Why do you? Today's evening on Global Summit 2019 promises to be very interesting and full of developers talks! Don't miss! Don't forget to RSVP here Thanks for everyone who came! We had a pretty nice event, hope to see you soon on the next InterSystems Dev Meetup in Boston! Hey Developers, Thanks to all participants of InterSystems Developers Meetup at InterSystems Global Summit 2019! Great speakers, great sessions! Here're some photos from the meetup: Big applause for @Evgeny.Shvarov, @Eduard.Lebedyuk, @Dmitry.Maslennikov, @Anton.Umnikov and @John.Murray! More photos from Global Summit 2019 you can find on InterSystems Developers Twitter or by following our official hashtag #GlobalSummit19. Your feedback is very welcome!
Announcement
Anastasia Dyubaylo · Oct 11, 2019

Global Summit 2019 Video: The State of the InterSystems Developer Community

Hi Community, It's time for the new videos from Global Summit 2019 on InterSystems Developers YouTube Channel! Are you ready? Please welcome the first session recording from InterSystems Developers: The State of the InterSystems Developer Community In this video we will discuss what’s new and notable in the InterSystems Developer Community. We will survey the broad array of resources for learning, collaborating, and prototyping, including: Online learning and documentation for InterSystems; A free new InterSystems IRIS sandbox environment you can spin up in seconds; What’s new with Developer Community and Global Masters; GitHub updates. Spoiler alert: ObjectScript is now a 1st class language on GitHub! Presenters: 🗣 @Evgeny.Shvarov, Manager, Developers Community and Startups🗣 @David.Reche, Senior Sales Engineer, Spanish Community Manager🗣 @Raj.Singh, Product Manager, Developer Experience Big applause for these speakers, thank you guys! 👏🏼 In addition, please read this article: InterSystems ObjectScript Package Manager. And... What's new on InterSystems Developers YouTube? We have created a new dedicated Global Summit 2019 playlist & Global Summit Keynotes playlist. They will be updated over time. Enjoy and stay tuned!
Announcement
Jeff Fried · Oct 28, 2019

InterSystems IRIS and IRIS for Health 2019.4 preview is published

Preview releases are now available for the 2019.4 version of InterSystems IRIS, IRIS for Health, and IRIS Studio! Container images are available via the WRC's preview download site. The build number for these releases is 2019.4.0.379.0. InterSystems IRIS Data Platform 2019.4 has many new capabilities including: Polyglot Extension (PeX) available for .Net ICM support for Tencent Cloud List Class available in the Native API for Java and .Net New CSF (Configuration State File) facility System security, performance, and efficiency enhancements Container and Cloud Deployment improvements InterSystems IRIS for Health 2019.4 includes all of the enhancements of InterSystems IRIS. In addition, this release includes FHIR searching with chained parameters (including reverse chaining) and minor updates to FHIR and other health care protocols. These are detailed in the documentation: InterSystems IRIS 2019.4 documentation and release notes IRIS for Health 2019.4 documentation and release notes InterSystems IRIS Studio 2019.4 is a standalone development image supported on Microsoft Windows. It works with InterSystems IRIS and IRIS for Health version 2019.4 and below, as well as with Caché and Ensemble. As this is a CD release it is only available in OCI (Open Container Initiative) a.k.a. Docker container format. The platforms on which this is supported for production and development are detailed in the Supported Platforms document. The download for IRIS Studio 2019.4 is not working. Community kits (preview) for InterSystems IRIS and InterSystems IRIS for Health are now available from the Docker hub. docker pull store/intersystems/iris-community:2019.4.0.379.0 docker pull store/intersystems/irishealth-community:2019.4.0.379.0 Hi Kurt Sorry about that. I have corrected the issue with downloading studio. Please let us know if you run into anything else.
Announcement
Anastasia Dyubaylo · Oct 24, 2019

[November 12-14, 2019] InterSystems DACH Symposium 2019

Dear Community, We're pleased to invite you to the InterSystems DACH Symposium 2019, which will take place from November 12th to 14th 2019 at The Westin Grand Hotel in Frankfurt am Main! This year, we will focus on best practices and use cases for AI, ML as well as API management, microservices and the use of containers for DevOps. You’ll experience exciting lectures, interactive sessions and hands-on coding exercises, which are suitable for both InterSystems experts and beginners. See for yourself how the new API Manager simplifies the orchestration of microservice architectures and how QuickML and InterSystems IRIS can help you to implement ML projects quickly and efficiently. So, remember: ⏱ Time: November 12-14, 2019 📍Venue: The Westin Grand Hotel, Frankfurt am Main, Germany ✅ Registration: SAVE YOUR SEAT See you in Frankfurt! Liebe Community, Wir laden euch herzlich ein zum InterSystems DACH Symposium 2019, das in diesem Jahr vom 12.-14. November im The Westin Grand Hotel in Frankfurt am Main stattfinden wird. Thematisch legen wir besondere Schwerpunkte auf Best Practices und Use Cases für KI, ML sowie API Management, Microservices sowie die Nutzung von Containern für DevOps. Meldet euch am besten gleich zu dieser kostenfreien Veranstaltung an: https://intersystems-dach-symposium.de/register/ Es erwarten euch spannende Vorträge, interaktive Sessions und praxisnahe Coding-Übungen, die sowohl für InterSystems-Profis wie auch –Einsteiger geeignet sind. Erfahrt aus erster Hand, wie der neue API Manager die Orchestrierung von Microservice-Architekturen vereinfacht und wie ihr mit QuickML und InterSystems IRIS Machine Learning Projekte schnell und effizient umsetzen könnt. Und, denk dran: ⏱ Zeit: 12. bis 14. November 2019 📍Veranstaltungort: The Westin Grand Hotel, Frankfurt am Main, Deutschland ✅ Registrierung: Sichern Sie sich Ihren Platz Sehen wir uns in Frankfurt! Any plans for a DC Meetup at this event? Hi John! Do you plan to come to DACH Summit 2019? Maybe. It's being considered. Will DC meetup influence the decision? ) John, we are considering it. There is a possibility if we have enough support and requests from developers. It's confirmed that I will be attending. The organizers have generously added me to the early evening "Beer & Bytes" demo sessions on Tuesday and Wednesday. I will demonstrate editing and debugging ObjectScript with Visual Studio Code using Serenji .
Announcement
Anastasia Dyubaylo · Oct 24, 2019

Video Recording: InterSystems Developers Meetup at Global Summit 2019

Hi Community, As you may know, we successfully held InterSystems Developers Meetup in Boston at Global Summit 2019. And now it's time to find out which solutions development on InterSystems IRIS have been discussed! Please welcome the Meetup video recording on InterSystems Developers YouTube Channel: ⏯ InterSystems Developers Meetup - Global Summit 2019 So, let's warmly greet these sessions from InterSystems developers: № TOPIC SPEAKER 1 Using Python Gateway with InterSystems IRIS @Eduard Lebedyuk, InterSystems 2 VSCode ObjectScript - your IDE for InterSystems IRIS development @Dmitriy Maslennikov, CaretDev 3 Using Package Manager for deployment InterSystems Solutions @Evgeny Shvarov, InterSystems 4 Falling in love with Visual Studio Code and Serenji @John Murray, George James Software 5 InterSystems IRIS and the Cloud @Anton Umnikov, InterSystems 6 How Your Code Matters! @Dmitriy Maslennikov, CaretDev P.s. Don't forget to check the useful resources on Open Exchange Marketplace. Big applause for these speakers! And thanks to all participants of the Meetup! 👏🏼 Please find more details in this post. Enjoy watching the video! And... What about the next events? Do you want our community to held more such meetups for InterSystems developers? Your feedback is very welcome! Please leave your suggestions in the comments of this post.
Announcement
Anastasia Dyubaylo · Oct 30, 2019

New Global Summit 2019 Video: Adopting InterSystems IRIS

Hi Community, The new video from Global summit 2019 is already on InterSystems Developers YouTube: ⏯ Adopting InterSystems IRIS In this video, we will introduce the InterSystems IRIS Adoption Guide, and describe the process of moving from Caché and/or Ensemble to InterSystems IRIS. We will also briefly touch on the conversion process for existing installations of Caché/Ensemble-based applications. Takeaway: InterSystems helps customers as they adopt InterSystems IRIS.Presenter: @Andreas.Dieckow, Principal Product Manager, InterSystems And... What's new on InterSystems Developers YouTube? We have created a new dedicated Global Summit 2019 playlist & Global Summit Keynotes playlist. They will be updated over time. Enjoy and stay tuned!
Article
Nikita Savchenko · Jan 5, 2019

Explore Text Data with InterSystems iKnow Entity Browser

This article introduces InterSystems iKnow Entity Browser, a web application which allows to visualize extracted and organized text data mined from a large number of texts, powered by InterSystems iKnow technology, which is also known as InterSystems Text Analytics in InterSystems IRIS. Feel free to play with the demo of this tool or learn more about it on InterSystems Open Exchange. I started the development of this project in late 2016. From now on, my iKnow Entity Browser is used around the world by those who use InterSystems technology in their stack and those who do text mining. This article should have appeared earlier, however, it's never late to tell something about the useful stuff! What InterSystems Text Analytics is About InterSystems iKnow (or InterSystems Text Analytics) is an embeddable NLP technology which allows to extract meaningful data from texts. Well, not only just to extract this data, but also to gather it, link, filter and prioritize. As a result, InterSystems iKnow provides a solid ground for building data applications for data mining. From the programming perspective, iKnow provides a rich API which allows to embed this technology to any application, regardless of its programming language. iKnow Entity Browser uses this API to visualize the processed data in a form of a tree of concepts and relations. Before InterSystems iKnow Entity Browser was released, the only out-of-the-box solution available for data exploration was the embedded iKnow viewer, which is shipped together with InterSystems' Cache-based and IRIS products. This viewer features many useful tools primarily for searching something in the processed text (in iKnow it is called domain), while iKnow Entity Browser is created also to visualize and organize concepts in a text. iKnow Knowledge Portal Look iKnow Entity Browser iKnow Entity Browser is an open-source project, meaning that anyone can contribute to its core. Here's the list of features that have been developed: visualization of similar and related concepts as a tree (snowflake diagram), zoom in and out support; graph editing tools: selection, deletion, undo & redo operations; data source customization, which also enables exploring the graph on remote servers; customizable tabular view of all entities presented on a graph, which can also be exported as a *.csv spreadsheet; mobile-friendly, touch-compatible, responsive user interface. iKnow Entity Browser Graph Demo Installation iKnow Entity Browser installation is pretty straightforward. Download the latest release (XML file) of the application and import it into iKnow-enabled namespace (for example, SAMPLES). This works with all latest InterSystems product releases, including InterSystems IRIS data platform. To import XML file, you can drag & drop the file onto the Studio (Atelier) window. Alternatively, you can import the file using the system management portal, in system explorer — classes. Then, open your browser at http://localhost:57772/EntityBrowser/ web page (change the host/port respectively to your server's setup and mind to append the trailing slash / at the end of the URL). To delete the application, simply delete the EntityBrowser package from Studio/Atelier. The installed web application will be deleted automatically if it wasn't modified since installation, the same way as it gets created during the installation. Currently, to use iKnow Entity Browser in different namespaces, you need to import it to each iKnow-enabled namespace, and manually set up web application (for example, you can clone /EntityBrowser application and rename it). Change the settings inside the web application to corresponding ones in this case (read the customization guide below). If you installed iKnow Entity Browser on the server and made the web application public, you can connect to this server from any front end, for example, even from this demo application. Customization Application's setting menu, located in the top right corner of the user interface allows to customize the appearance and data source. In the settings menu, you can specify the following (see the image below): Data source URL, which identifies the server with installed iKnow entity browser (/EntityBrowser web application). Domain name. When you create a new domain in InterSystems iKnow, you specify the name of the domain. This name goes into domain name input. A seed concept name which builds the graph. By default, iKnow Entity Browser builds the graph starting from related concepts to the seed concept you specify, however, you can change it to be similar concepts, using the drop-down menu on the left side from the seed concept input or the drop-down menu in the main view if enabled. Whether or not to place the seed concept input in the main view. Whether or not to place the query type drop-down menu in the main view. Whether or not to show hidden nodes in the tabular view. Hidden nodes are those which are not expanded in a view but present in a query result. Columns that are displayed in a tabular view. Here you can customize the column name and select a value it displays (ID, inbound edge type, label, score, spread, frequency, parent concept's label, parent concept's id). Reset all settings to defaults. iKnow Entity Browser Settings The Graph Once the seed concept is specified in settings, iKnow Entity Browser builds a graph of similar or related concepts to the seed concept. You can play with this graph by dragging its nodes, however, the physical force will always try to organize it in a form of the snowflake diagram. The graph can be edited using the controls in the bottom of the screen. This includes undo/redo buttons, zoom in/out and reset zoom buttons, reset selection button, unlink and delete selection buttons. Hovering over any of these buttons displays a tooltip. Menu with controls In case you need a list of selected concepts, you can toggle a tabular view by pressing on the corresponding button in the top right corner. Everything you do on the graph stays in sync with the tabular view and vice versa. In the tabular view, once you hover over one of the rows, the corresponding node is highlighted on the graph. If you click the row, the graph view automatically focuses on the corresponding node. As well as on the graph, you can click buttons in table rows to select/deselect nodes. Tabular View Once you have a selection of nodes, you can export them as a table in *.csv format. Press the tabular view button in the top right corner for the table to appear and then you'll find the "Export" button. This will export all selected nodes in a form of a table, the same table as you have in a tabular view. There's More iKnow Entity Browser is just one of the numerous projects I did for InterSystems corporation. Here are some if you haven't seen these projects yet: WebTerminal, Visual Editor, Class Explorer, Light Pivot Table, GlobalsDB Admin. Find these and other InterSystems-related projects on InterSystems Marketplace. All of my projects are open sourced, allowing others to contribute. The code of these projects is available on GitHub. You can also use their code as an example to build your own application on top of InterSystems' products. If you take a closer look, you'll find out that most of them are installable packages, shipped in a single XML file. If you are curious about using the same strategy for your packages, check this article. Hope you'll find iKnow Entity Browser and other projects useful! Enjoy! Thanks for posting Nikita. Your visualization has indeed been extremely helpful in showing what iKnow entities are all about to new audiences and is easily embeddable in applications where large numbers of entities need to be explored or navigated! Thank you Benjamin! Glad to hear this Thanks for posting. I followed the install directions and customized the domain and seed word and the web browser seemed to indicate that it was processing and never stopped. CPU usage was overloaded and I'm having to reboot the server. Has anyone else encountered this? In EntityBrowser.API class set PAGESIZE parameter to 100 and compile the class. Thanks, that fed me results quickly. What is this doing? I'm familiar with PAGESIZE as it relates to number of rows returned. I've noticed nodes now that say to display x more. So is this returning first 100, top 100, or something different? TOP 100.
Announcement
Anastasia Dyubaylo · Apr 24, 2019

New Video: Developing with Docker and InterSystems IRIS Community Edition

Hi Community!You're very welcome to watch a new video on InterSystems Developers YouTube, recorded in a new format called "Coding Talks":Developing with Docker and InterSystems IRIS Community Edition In this video, presented by @Evgeny.Shvarov, you will know how to develop InterSystems IRIS solution on ObjectScript using Docker with example of dockerised InterSystems IRIS repository.Read how to dockerize your repo here.And...A little bit about our new video format: Coding Talks is a short video in which the developer demonstrates a particular feature or functionality of InterSystems Data Platforms which he/she uses to in coding. Typical format: the face on side and editor with ObjectScript.So! Enjoy watching the video and you're very welcome to share your own ideas/themes for our new video format in the comments to this post!Stay tuned! This article needs to link to pre-requisite articles to be of much use. For a developer who is used to writing ObjectScript in Studio on a local Ensemble installation, the starting point for this video is so far removed from what is familiar as to make it pretty useless. Similarly, for a newcomer to InterSystems development there is little here to latch onto to get things started. As part of a series this might well make a lot of sense, but as a standalone video its like demonstrating how to build a space rocket by showing an astronaut strapping themselves in for takeoff - it felt like all of the hard work had already been done. Hi Duncan!As mentioned above the video is a sort of "work through" for this article. Could you be more specific what doesn't work?BTW, just Yesterday I recorded another one which shows how to start a totally new app with Github, IRIS on docker and VSCode. Hope it will answer some of your questions.
Announcement
Anastasia Dyubaylo · Dec 13, 2019

New Video: Using IoT in InterSystems IRIS for Health

Hi Everyone, Please welcome the new Global Summit 2019 video on InterSystems Developers YouTube Channel: ⏯ Using IoT in InterSystems IRIS for Health In this video, we will demonstrate connecting a heart rate sensor, to InterSystems IRIS for Health via an MQTT/IoT interface. We will show how the sensor reading becomes a well-formatted HL7 message, suitable for sharing and analysis. Takeaway: InterSystems IRIS for Health enables you to capture and use the latest wearable data from healthcare sensors.Presenter: @Anton.Umnikov, Senior Cloud Solution Architect, InterSystems Learn more in this InterSystems Online Learning Course. Enjoy watching the video! 👍🏼
Announcement
Anastasia Dyubaylo · Dec 14, 2018

New Badges on Global Masters: Special InterSystems IRIS Set

Hi Community! It's time for New Badges on InterSystems Global Masters Advocacy Hub! Please welcome:✔ InterSystems IRIS Reporter Badge✔ InterSystems IRIS Blogger Badge✔ InterSystems IRIS Influencer Badge✔ InterSystems IRIS Opinion Maker BadgeHow can GM Advocates get these badges? See the details below.Badge's NameRulesInterSystems IRIS ReporterAwarded after you published 10 / 50 / 100 / 250 articles (not questions) with InterSystems IRIS tag on Developer Community.Posts must not be deleted; they must be published.Counted only the posts with positive rating. Posts from the Developer Community Feedback group are not counted.InterSystems IRIS BloggerInterSystems IRIS InfluencerInterSystems IRIS Opinion Maker And...Please check the additional information about Global Masters:How to join InterSystems Global MastersGlobal Masters Badges DescriptionsGlobal Masters Levels DescriptionsChanges in Global Masters ProgramIf you have not joined InterSystems Global Masters Advocacy Hub yet, let's get started right now! Feel free to ask your questions in the comments to this post. Hi @Anastasia.Dyubaylo How long it will take to get the badge if we published a new Article? Thanks I believe it is 3 days. I think this is to confirm posts are real and not spam. Also to allow them to get some votes and confirm it has a positive rating. Thanks, Peter! Indeed, there is a 3 days delay which lets our DC Moderators team decide on the nature of the post and to let community vote positively or negatively. You don't get badges and points for negatively voted posts.
Announcement
Jeff Fried · Jan 22, 2019

InterSystems HealthShare Health Connect 2019.1 preview

The preview release of InterSystems HealthShare Health Connect 2019.1 is now available! Kits and container images are available via WRC's preview download site. InterSystems HealthShare Health Connect version 2019.1 is the first version of InterSystems HealthShare Health Connect synchronized with InterSystems IRIS, and includes many new features and capabilities, most notably: FHIR STU3 Support Java Business Hosts Managed File Transfer (MFT) Containerized and cloud deployment New interoperability capabilities that speed configuring and troubleshooting of productions These are detailed in the draft documentation and release notes for InterSystems HealthShare Health Connect (Note that the Health Connect documentation is currently available only to registered healthcare customers via an SSO login.) Preview releases allow our customers to get an early start working with new features and functionality. They are supported for development and test purposes, but not for production. This preview release does not provide an upgrade from earlier versions of InterSystems HealthShare Health Connect; if you are interested in testing the upgrade process, please contact your InterSystems representative. We noticed that SAMPLES DB appears to be missing, was this intentional? Are you planning to add it in the official release? Also, will there separate notification on build releases with list of fixes? Thank youYuriy The IRIS-based products don't ship a SAMPLES database. Instead there's a documented procedure for setting up your own, then fetching the samples you want.
Question
Zaheer Uddin · Dec 18, 2018

Unable to connect using InterSystems ODBC in PHP, access denied

I am unable to connect to InterSystems ODBC client. I am seeing the following error: [Cache ODBC][State : S1000][Native Code 417] Access denied. $cnx = new PDO("odbc:Driver={InterSystems ODBC};Server=<IP>;Uid=<id>;Pwd=<password>;"); Am i doing anything wrong? Although, I can successfully connect and retrieve data in MS Excel using ODBC connection where I have configured my DSN and all If you're using InterSystems IRIS try this connection string (replacing values with appropriate): "Driver=InterSystems ODBC Driver;Host=127.0.0.1;Port=56772;Database=USER;UID=myUsername;PWD=" and for Caché/Ensemble try (driver name could be InterSystems ODBC): "Driver=Cache ODBC Driver;Host=127.0.0.1;Port=1972;Database=USER;UID=myUsername;PWD=" If the problem persist, check Audit log. i got the same error message, have you solved the problem?
Announcement
Evgeny Shvarov · Dec 1, 2018

InterSystems on vSAN - Virtually Speaking Podcast with Murray Oldfield

Hi Community!Check the fresh Virtually Speaking recording "InterSystems on vSAN" with @Murray.Oldfield Have a great weekend!
Announcement
Thomas Carroll · Apr 5, 2019

InterSystems IRIS Community Edition Now Available On The Docker Store

Hi Community! We're pleased to announce that that InterSystems IRIS Community Edition is available on the Docker Store! InterSystems IRIS Community Edition is the no-cost developer edition designed to lower the barriers to entry to get started with IRIS. Now that it is listed on the Docker Store, running an IRIS Community instance is as easy as - docker run -d -p 52773:52773 store/intersystems/iris:2019.1.0.511.0-community For more on running IRIS in containers check out our Documentation or one of the many Community posts on the topic! Confirming that! Really great news, Joe! What are the limitations of Community edition? One limitation I can see straight away is that this version only includes outdated files for Node.js (ie the iris*.node files). All I see is iris610.node and iris700.node. Is there a reason why the Node.js version 8 and version 10 interface files haven't been included? What a wonderful news There's a section about Community Edition limitations in the document at https://irisdocs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=ACLOUD#ACLOUD_limitsHere's a screenshot of what it currently says:A big disappointment for me is the exclusion of namespace mapping. Those of us who create tools for the InterSystems world commonly use namespace mapping to make our tools available in the users' namespaces. See Evgeny's article here I downloaded IRIS Community edition (store/intersystems/iris:2019.1.0.510.0-community) and was able to create package and global mappings without any issues. I was able to create the mappings, but they don't seem to work for me. Not even after an IRIS restart.I'm using the %ALL pseudo-namespace. I created these mappings (no restarts):Ens* global mapping for ENSLIB -> USERDeepSee* global mapping for ENSLIB -> %ALLEns* package mapping for ENSLIB -> USERHere's the result: I notice that your mappings get code from ENSLIBMy use-case is a bit different.Can you create a new database and namespace pair called XYZ and then define a %ALL mapping so that the globals ^XYZ and the routines XYZ* and the package XYZ get fetched from your XYZ namespace from all other namespaces, e.g. USER ?I'd expect mappings to ENSLIB to work, otherwise the "Ensemble" features of IRIS would be broken in Community Edition.It seems to me that those are allowed but mappings we define to our own databases get ignored. Yeah, apparently only DeepSee and Ens packages/globals can be mapped successfully.Tried random package and it didn't show up even after mapping to %ALL. Thanks, Rob!Introduced your issue here. Please share more requests and feedback there Thanks, John!Your feedback is filed here. Also here. I beat you to it! This is a restriction in the Community Edition and it is what is meant byAll InterSystems IRIS functionality is included except the following:Namespace mapping...You can create mappings and activate configurations which contain mappings if that is useful for some purpose (eg. building a configuration for someone else) however all mappings which do not involve a system database are ignored.