Search

The preview release of InterSystems IRIS 2019.1 is now available - give it a try!Kits and container images are available via WRC's preview download site.InterSystems IRIS Data Platform 2019.1 is the third major version of InterSystems IRIS. It has many new capabilities including:Significant enhancements to SQL usability and performanceImproved scalability and operations for sharded clustersClient language updates and performance boostsNew interoperability capabilities that speed configuring and troubleshooting of productionsSystem security, performance, and efficiency enhancementsThese are detailed in the draft documentation and release notes for InterSystems IRIS.Server platform support for traditional installations have been updated, as have the base OS layer and storage drivers for InterSystems IRIS containers. You can read details in the draft Supported Platforms document.With 2019.1, InterSystems IRIS now officially supports self-service BI tools using ODBC connections, specifically Tableau and PowerBI. Customers interested in using these are encouraged to take the Power BI survey or Tableau survey; this feedback will help us in providing dedicated connectors to these tools in a future release.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. Glad to see thew newest version, great work.Hope to see some details about community and expression editions. Unfortunately, both of these versions did not work well for me as I expected, so, I would like to see how they differ from the original version and about limitations. Is there an ETA for 2019.1 preview versions of Caché and Ensemble, for those who haven't yet migrated to InterSystems IRIS? Great news Jeff. It looks like a significant release and the one we will be targeting for our move from Caché to IRIS.But in this context, what I'm missing from your announcement and the release notes is mention of an upgrade installation from Caché to IRIS (rather than a completely new install and then having to manually create all configuration and security items that exist on the Caché platform and having to rename database files and so on and so on). You stated in late November that was in the works and coming for 2019.1. Hi John - for Caché and Ensemble we have just released a 2018.1.1 version, and will shortly have a 2018.1.2. We don't plan a 2019.1 version of Cache and Ensemble - we're focused on keeping these stable and adding in specific enhancements as needed, and on making it easy for customers to migrate to InterSystems IRIS when it's right for them. Hi Wolf - You are correct, this preview does not include the upgrade installation from Caché to IRIS. Still in the works; we'll have more news about this shortly. In that case I'd like to lobby for devchange JGM785 to get into Ensemble 2018.1.2. This devchange addresses a longstanding weakness in Portal, namely that its schema editor didn't respect server-side source control. Thanks, John...yes this request is already registered and your lobbying seems to have already started through a different channel ;-) OK, we will get out some of these details. If you can drop a line about what didn't work that would be great. - email joe.carroll@intersystems.com, or file something in the WRC, or use the feedback button on the quickstarts - There is a known issue that you may be looking at w.r.t. limitation on the # databases. We'll also have a 'call for feedback' on the Developer Community forum about this soon, have a few things to adjust first.

what is mirroring?? Take a look at this documentation. It goes in to a lot of detail with some useful diagrams.*edit*There is also this useful Mirroring 101 forum post. If ever you are looking for generalized information, you can always look at learning.intersystems.com as well as the documentation (docs.intersystems.com). There's a lot of good videos there that you can use to help get going. If you have any specific questions there are plenty of us who would be happy to answer them. I agree with the previous answers as a good starting point. If you get past there and want to set up a mirror, take a look at this post.

Easily transform a CSV file into a personalized preview of DeepSee - InterSystems BI AnalyzeThis can be found on InterSystems Open Exchange. Use the Download link to navigate to GitHub and begin installing the project. Follow the “Installation” section of the GitHub README. After installation, navigate to the User Portal from the Management Portal: Once here, a new Link will have been added, click on the link and then select "New" to begin: Use “Browse” to locate a csv file to import: Click on “Next” to see a preview of your data and select “Measure” or “Dimension”: As defined, “Measures” are the value you would like to aggregate. “Dimensions” are the values you would like to aggregate on. You can also select to hide properties that are not good Dimensions or Measures. For example, “ProviderId” is unique, so this will not be a good value to group on. We also do not want any sort of sum or aggregate of this number, so we will not include it here: All properties default to a Dimension. We will find some properties we want to change to be Measures: Here we can see that “TotalDischarges”, “AverageCoveredCharges”,”AverageTotalPayments”, and “AverageMedicarePayments” would be good values to aggregate. We will make them Measures: We also know these are dollar amounts, so we will change their type from Integer to Currency: Now that we are happy with our data, we can click “Import”. This will start processing the data as seen here: Once this stage is complete (speed depends on the amount of data being processed), we will see some new buttons on the dialog box: Here we will click on “Sample Dashboard” to view the generated sample based on our data: We can now have our data in a Cube so that we can start exploring the analytics capabilities in just a few minutes. If any bugs are experienced during this process, please feel free to email me at psteiwer@intersystems.com, or file a bug report on GitHub. For general questions, please comment on this article so others can benefit from the information as well. Head over to InterSystems Open Exchange and download AnalyzeThis today! We had to chose one out of these 4 book covers for AnalyzeThis, we chose #1, do you agree with us? Yes, the 1st one is a full match)@Peter.Steiwer, do you plan also to share the short screencast on how to use the tool in the best way? We could deploy it on Community Channel I do not currently have a screencast, but on the Community Channel there is the Flash Talk from Global Summit 2018 that can be viewed for now Hi @Peter.Steiwer!Tried to play with the demo and got the following:Installed on IRIS Docker Community version: IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2019.2 (Build 107U) Wed Jun 5 2019 17:26:23 EDT Hello @Evgeny.Shvarov, Just to close the loop on this issue, @Peter.Steiwer fixed it back in July 24, 2019. Please feel free to download the latest version here. Thanks, Asaf Hi, @Asaf.Sinay , @Peter.Steiwer! Yes, tried this on mac recently with 2019.3 on IRIS docker CE. This bug is solved - great! But on the final step, it says "It's working"... - and it's working for a long time. Never saw the result, yet) Hi @Evgeny.Shvarov Please feel free to create an Issue on GitHub. Please include the CSV file you are trying to use as well Peter done https://github.com/psteiwer/AnalyzeThis/issues/35 Objectscript Package manager has the updated version 1.1.2 as well. So Analyzethis can be installed as: USER:zpm>install analyzethis Hi @Evgeny.Shvarov This is fixed in v1.1.3

Hi Community!Thank you for being with InterSystems Developer Community yet another year! We appreciate it very much!We want to know how helpful DC for you today and how could we make it better. Could you please go through this short 5 min survey which will let us know what do you think about DC and what could be improved.We wish you a Merry Christmas and a Happy New Year! Sincerely, Your InterSystems Developer Community Team

Hello, I am new to InsterSystems Cache - having a SQL Server background. However I am dealing with a Third Party who use InterSystems Cache to hold some of our data. To do some analysis I need to view a backup of the database. They are prepared to send me a backup.My question is - how can I view this backup ( would this be the CACHE.dat file?).Do I effectively need to have an installation of CACHE on my machine to be able to view this? Is it possible to view it from SQL Server? Any help would be appreciated.ThanksColin Hi Robert - thanks for confirming this for me. Regarding Cache/SQL Server I am certainly open to exploring Cache further. Thanks, Colin #1) if it is a Caché Backup you need an Installation of Caché to restore it.#2) if it is a CACHE.DAT file you also need an installation of Caché and mount this as an additional DataBase.Without the installation of Caché it's a thrilling exercise to high-level experts. Not really advisable.try to have the same processor type { big / little endian :== (Intel/AMD) or not } as the original Caché instances. This saves some headache.Forget about SQL Server. Caché is far more efficient and advanced technology!

Hi Community!Please welcome a new video on InterSystems Developers YouTube Channel:InterSystems IRIS Roadmap In this video you will learn where InterSystems IRIS is headed. We'll discuss our vision and key investments we are making for the future.Takeaway: InterSystems is committed to fueling my innovations by giving me the technology I need.Presenter: @Jeffrey.Fried, Director of Product Management, InterSystemsAnd...Additional materials to the video you can find in this InterSystems Online Learning Course.Don't forget to subscribe our InterSystems Developers YouTube Channel. Enjoy and stay tuned!

The preview release of InterSystems IRIS 2019.2 is now available - give it a try! Container images are available via the WRC's preview download site. The build number for these releases is 2019.2.0.100.0. InterSystems IRIS Data Platform 2019.2 is the first CD (continuous delivery) release of InterSystems IRIS. It has many new capabilities including: Addition of the IRIS Native API for Python and Node.js and relational access for Node.js Simplified sharding architecture and flexible sharded schema design Support for the new PowerBI connector for InterSystems IRIS New look in the Management Portal System security, performance, and efficiency enhancements Enhancements to the InterSystems Cloud Manager These are detailed in the prerelease documentation and release notes. 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. For more information on what a CD release is, review the new release cadence post on InterSystems Developer Community. 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. Nice to see this preview appear, and being a Docker container made it easy for me to download, spin up and verify that our Serenji extension for VSCode seems to work fine. Not that I'm surprised, seeing how good at maintaining backward compatibility I've always found ISC to be. Great news, Jeff!Could we expect IRIS Community Edition 2019.2 preview too?

Hi Community!Please welcome a new video on InterSystems YouTube Channel:InterSystems and Python QuickStart InterSystems IRIS™ data platform supports two lightweight Python APIs that provide direct access to InterSystems IRIS databases via relational tables (PyODBC) or multidimensional storage (Native API):PyODBC lets your application quickly retrieve, update, and delete data.The Native API for Python lets your application directly access the underlying data structure within InterSystems IRIS (known as globals) as well as call ObjectScript methods and routines.Watch the video to review ways to connect your application to InterSystems IRIS data platform, or follow the steps in the exercise below to use PyODBC and the Native API for Python to connect to InterSystems IRIS.Visit the Python QuickStart on the InterSystems learning site for more.Enjoy and stay tuned!

Hey Community!As you know, InterSystems Developer Community is always evolving. We have a number of different pages in popular social networks. And now we're more than happy to launch the InterSystems Developer Community on LinkedIn! Please welcome:1. Developer Community Page on LinkedIn: to stay in the know about articles, answers, announcements, hot discussions, best practices based on InterSystems technology - so good if you are an active user of LinkedIn!2. InterSystems Developers Group on LinkedIn: to network with other developers.Imagine that you want to invite a high-pro DC member to your event, or you have a question or need advice... How to contact him/her? Now it's easy! Go to DC LinkedIn Group and send a direct message!What's next?We are planning to expand. What do you think about it? In what social networks do you want to see Developer Community? Please leave all your suggestions in the comments of this post.Enjoy and stay tuned! For those who requested direct communication on DC -Developers Group is just for that: join, connect, and chat directly. It doesn't satisfy the request on direct messaging on DC, but it is something which could help.

Hey Developers, Learn about InterSystems Reports, powered by Logi Analytics, a report-generation tool that enables you to rapidly create and view visual reports of your data. ⏯ A Look at InterSystems Reports 👉🏼 Subscribe to InterSystems Developers YouTube. Enjoy and stay tuned! I think i have managed to get the report server installed. The licence details in Discord helped. And the note about not using ! Character in passwords was useful as all my passwords tend to have an ! In them. I am waiting for my laptop to complete its cleanup and space free up and then i should be able to test it through the smp. Thanks Nigel

Hi Community! Enjoy watching the new video on InterSystems Developers YouTube: ⏯ Introduction to InterSystems Reports InterSystems Reports, powered by Logi Analytics, is a report generation tool that enables you to rapidly create and view visual reports of your data. This video introduces you to InterSystems Reports and its core components. ➡️ Subscribe to InterSystems Developers YouTube. Enjoy and stay tuned!

Hi Developers! Here're the technology bonuses for the InterSystems Interoperability Contest that will give you extra points in the voting: Business Process BPL or Business Rule DTL Usage Custom Interoperability Adapter Usage Production EXtension(PEX) Java or .NET usage Workflow Engine usage ZPM Package deployment Docker container usage See the details below. Business Process BPL or Business Rules Usage - 1 point One of the key features of IRIS Interoperability Productions are business processes, which could be described by BPL (Business Process Language). Learn more on Business Processes in documentation. Business Rules it's a no-code/low-code approach to manage the processing logic of the interoperability production. In InterSystems IRIS you can create a business rule which you can create visually or via the ObjectScript representation. You can collect the Business Process/Business Rule bonus if you create and use the business process or business rule in your interoperability production. Business Rule Example Learn more on Business Rules in documentation. Custom Interoperability Adapter Usage - 1 point InterSystems Interoperability production can contain inbound or Outbound adapters which are being used to communicate with external systems by business services and operations of the production. You can use out-of-the-box adapters (like File, or Email) or develop your own. You get the bonus if you develop your own custom inbound or outbound adapter and use it in your production. Example of an adapter. Learn more on adapters. Production EXtension (PEX) Usage - 2 points PEX is a Java or .NET extension of Interorability productions. You get this bonus if you use PEX with JAVA or .NET in your interoperability production. PEX Demo. Learn more on PEX in Documentation. Workflow Engine Usage - 1 point Workflow Engine its a part of IRIS Interoperability which could be used to automate distribution of tasks among users. You get this bonus if you use include the usage of Workflow Engine in your interoperability production. Learn more on Workflows in Documentation. There are Community modules WorkflowAPI and WorkflowUI-ngx which provide a nice UI layer on Angular for the Workflow engine. ZPM Package deployment - 1 point You can collect the bonus if you build and publish the ZPM(ObjectScript Package Manager) package for your Full Stack application so it could be deployed with: zpm "install your-full-stack-solution-name" command on IRIS with ZPM client installed. ZPM client. Documentation. Docker container usage - 1 point The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container. You can collect the bonus if you use any of the following docker templates: IRIS Interoperability Template Feel free to ask any questions about using the listed technologies. Good luck in the competition!

We are glad to announce that DBeaver has supported InterSystems IRIS out-of-the-box since version 7.2.4. You don't need to configure it manually anymore, just find the IRIS icon in the Connections list. All necessary fields are already filled. But please, do not forget to enter your username and password. By default, InterSystems IRIS driver doesn't include in DBeaver. For the first connection DBeaver suggests downloading the driver from the official InterSystems GitHub repository. This driver will be used for all further connections. The current version does not contain IRIS specific features, but all main DBeaver functions will work for your database. If you think that it can be important to add something else, please let us know. That's great! DBeaver it's an amazing application! We have been using it for a few weeks now. It is very powerful. @Paul.Hurley , thanks for the feedback!Developers! Please, provide more reviews if you like/dislike the tool, thanks in advance! Hi @Tatiana.Krupenya ! Thanks for the article! What is the way to establish connections to IRIS via DBeaver over the SSL? The last couple of times I tied this, it told me it couldn't find the jar file to download. I got it from the dev directory on my IRIS server and configured it manually. Does it work on the following version? Cache for Windows (x86-64) 2016.1.2 (Build 208U) Not sure, but you can try there any way should be available driver for Cache, which should work I've used it with Cache 2018, but not as far back as 2016. You'll have to manually add the driver to DBeaver first to try it. To do that, first get a copy of the JDBC driver, which should be in the installation directory for your Cache instance. Look for a folder called dev, then java, then lib, then JDK17 or JDK18 depending on which version of Java is installed on your machine, then there should be a jar file with a name like cache-jdbc-x.y.z.jar. Copy that somewhere easy to get to. In DBeaver, click on the Database menu, then Driver Manager. Click New. Give the driver a name like Cache 2016 or something you'll recognize. Under driver files, click Add File and choose that .jar file. The class name for the driver should be com.intersys.jdbc.CacheDriver. In the sample URL field put a URL that would connect to your Cache instance, which would look like jdbc:Cache//(server):(port)/(namespace). Click on Test Driver to verify. If it works, click OK. Now when you go to Database, New Connection, you should see that driver listed as an option.

According to IDC, more than 80% of information it is NoSQL, especially text into documents. When the digital services or applications not process all this information, the business lose. To face this challenge, it is possible use OCR technology. OCR uses machine learning and/or trained image patterns to transform image pixels into text. This is important, because many documents are scanned into images inside PDF, or many documents contains images with text inside. So OCR are an important step to get all possible data from a document. To do OCR, the main open source solution used is Google Tesseract, the most popular solution into the Python and Java community. Tesseract has support to more than 100 idioms and can be trained with new models to recognize car plates, captchas and so on. Tesseract was created in C++, so Java uses it consuming an intermediate, called Tess4J. My following code shows it to you: private String extractTextFromImage(File tempFile) throws TesseractException { ITesseract tesseract = new Tesseract(); tesseract.setDatapath("/usr/share/tessdata/"); //directory to trained models tesseract.setLanguage("eng+por"); // choose your language/trained model return tesseract.doOCR(tempFile); //call tesseract function doOCR() //passing the file to be processed with OCR technique } To allows IRIS to use this Java Class and get the results from Java, we need to use PEX and Java Gateway solutions. First it is necessary config Java Proxy into the production and second, config a PEX business operation or service to communicate IRIS and Java into a production. Class dc.ocr.OcrProduction Extends Ens.Production { XData ProductionDefinition { <Production Name="dc.ocr.OcrProduction" LogGeneralTraceEvents="false"> <Description></Description> <ActorPoolSize>2</ActorPoolSize> <Item Name="OcrService" Category="" ClassName="dc.ocr.OcrService" PoolSize="1" Enabled="true" Foreground="false" Comment="" LogTraceEvents="false" Schedule=""> </Item> <Item Name="JavaGateway" Category="" ClassName="EnsLib.JavaGateway.Service" PoolSize="1" Enabled="true" Foreground="false" Comment="" LogTraceEvents="false" Schedule=""> <Setting Target="Host" Name="ClassPath">.:/usr/irissys/dev/java/lib/JDK18/*:/opt/irisapp/* :/usr/irissys/dev/java/lib/gson/* :/usr/irissys/dev/java/lib/jackson/*:/jgw/ocr-pex-1.0.0.jar </Setting> <Setting Target="Host" Name="JavaHome">/usr/lib/jvm/java-8-openjdk-amd64/</Setting> </Item> <Item Name="OcrOperation" Category="" ClassName="EnsLib.PEX.BusinessOperation" PoolSize="1" Enabled="true" Foreground="false" Comment="" LogTraceEvents="false" Schedule=""> <Setting Target="Host" Name="%gatewayPort">55555</Setting> <Setting Target="Host" Name="%remoteClassname">community.intersystems.pex.ocr.OcrOperation</Setting> <Setting Target="Host" Name="%gatewayExtraClasspaths">.:/usr/irissys/dev/java/lib/JDK18/* :/opt/irisapp/*:/usr/irissys/dev/java/lib/gson/* :/usr/irissys/dev/java/lib/jackson/* :/jgw/ocr-pex-1.0.0.jar </Setting> </Item> </Production> } } Now any IRIS production can communicate with Java and Tesseract! See: //call ocr method to get text from image, if you want to use pex Set pRequest = ##class(dc.ocr.OcrRequest).%New() Set pRequest.FileName = file.Filename // call java pex operation to do ocr, passing file into pRequest and receive ocr text with pResponse Set tSC = ..SendRequestSync("OcrOperation", pRequest, .pResponse, 1200) //save the results into database to use text analytics - nlp Set ocrTable = ##class(dc.ocr.OcrTable).%New() Set ocrTable.FileName = file.Filename Set ocrTable.OcrText = pResponse.StringValue Set tSC = ocrTable.%Save() All code details, with comments can be found into my OCR Service repository (https://openexchange.intersystems.com/package/OCR-Service). Now, with the text extracted, we need to use IRIS NLP engine to analyze textual data and get insights to support decisions. For this, when a text is extracted, it is saved into a table, and this table is used by NLP engine as text source. See the table %Save() above and see the following code with NLP referencing OCRTable (place with texts extracted). See: Class dc.ocr.OcrNLP Extends %iKnow.DomainDefinition [ ProcedureBlock ] { XData Domain [ XMLNamespace = "http://www.intersystems.com/iknow" ] { <domain name="OcrNLP" disabled="false" allowCustomUpdates="true"> <parameter name="DefaultConfig" value="OcrNLP.Configuration" isList="false" /> <data dropBeforeBuild="true"> <table listname="OcrNLPTable" batchMode="true" disabled="false" listerClass="%iKnow.Source.SQL.Lister" tableName="dc_ocr.OcrTable" idField="ID" groupField="ID" dataFields="OcrText" metadataColumns="FileName" metadataFields="filename" /> </data> <matching disabled="false" dropBeforeBuild="true" autoExecute="true" ignoreDictionaryErrors="true" /> <metadata> <field name="filename" operators="=" dataType="STRING" storage="0" caseSensitive="false" disabled="false" /> </metadata> <configuration name="OcrNLP.Configuration" detectLanguage="true" languages="en,pt" userDictionary="OcrNLP.Dictionary#1" summarize="true" maxConceptLength="0" /> <userDictionary name="OcrNLP.Dictionary#1" /> </domain> } } See full details and configuration into my OCR Service github repository. Now we can upload some files and go to the Explorer to see concepts and CRC generated. See my animation with all steps discussed here: Happy OCR/NLP hacking! Hi @Yuri.Gomes The OCR response it's fast! Really impressive Congrats on this great demo Thanks Henrique! And it is running with a docker with 2 cores and 2 gb ram Hi Yuri, are you able to do a zpm distribution of your code? With the assistance of Intersystems SE, we still failed to get the docker download to configure. Thank you

Hey Developers, The InterSystems Multi-Model Contest is over. Thank you all for participating in our exciting coding marathon! And now it's time to announce the winners! A storm of applause goes to these developers and their applications: 🏆 Experts Nomination - winners were determined by a specially selected jury: 🥇 1st place and $2,000 go to the iris-image-index-demo project by @José.Pereira 🥈 2nd place and $1,000 go to the zapm project by @MikhailenkoSergey 🥉 3rd place and $500 go to the iris-multimodel-suite project by @Renato.Banzai 🏆 Community Nomination - an application that received the most votes in total: 🥇 1st place and $1,000 go to the HealthInfoQueryLayer project by @Botai.Zhang 🥈 2nd place and $500 go to the iris-vaccine-tracker project by @Henrique.GonçalvesDias 🥉 3rd place and $250 go to the iris-image-index-demo project by @José.Pereira Congratulations to all the participants! Thank you for your attention to the contest and the efforts you pay in this exciting coding competition! And what's next? We already announced the InterSystems Grand Prix Programming Contest! Total prize: $16,000 Join the Grand Prix and stay tuned! 😉 Congratulations to all contenders! Big congrats, Henrique! 🥳