Come to Barcelona and join us !!
Choose the tag if you want to post something which doesn't relate to InterSystems data platforms or services.
Hey guys!
Thanks for participating in our small but productive COS marathon on behalf Adventofcode 2017!
The leaderboard is here:
And we are ready to announce the winner but need your public repositories with COS solutions inside. Please share it below in comments.
We have results!
1st place: Bert Sarens! Repository.
2nd place: Peter Steiwer! Repository.
3rd place: Dmitry Maslennikov. Repository.
Congratulations Bert!
You get 10,000 Global Masters points and the title of the AdventOfCode champion in Caché ObjectScript at least until December 2018!
Peter and Dmitry!
Hello everyone,
From now till the 25th of december each day 2 programming problems to sharpen your programming skills.
Theme this year:
The night before Christmas, one of Santa's Elves calls you in a panic. "The printer's broken! We can't print the Naughty or Nice List!" By the time you make it to sub-basement 17, there are only a few minutes until midnight. "We have a big problem," she says; "there must be almost fifty bugs in this system, but nothing else can print The List. Stand in this square, quick!
A request came from a customer to estimate how long it would take to encrypt a database with cvencrypt utility.
This question is a little bit like how long is a piece of string — it depends. But its an interesting question. The answer primarily depends on the performance of CPU and storage on the target platform the customer is using, so the answer is more about coming up with a simple methodology that can be used to benchmark the CPU and storage while running cvencrypt.
Methodology
- Copy a large and representative CACHE.
Hello all.
I think the forum experience is great as whole, but it could improve even more if we had somewhere to share our ideas. So that's why I'm creating a thread dedicated for that purpose. Maybe this way someone from InterSystems could catch something good?
To most of us it's almost dogmatic that $H can't be negative!
This is correct concerning the COS Special Variable $HOROLOG.
No doubt. It's the presentation of the actual date & time.
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
For dates before 1841 it's suggested to use Julian date before 1841.
Good for calculations.
But what about values in $H_format ?
Conversion functions $ZD(), $ZDT(), $ZDH(), $ZDTH() and
for SQL $system.SQL.TOCHAR() and $system.SQL.TODATE()
take care of the conversion to human readable date. You know this.
Hi, Community!
I'm pleased to invite you to InterSystems Community Meetup we would have in Cambridge on 8th of August.
Hi, Community!
You know we would have a meetup in Boston on the 8th of July August with the following agenda:
| Time |
Topic |
Presenter |
|---|---|---|
| 5-30pm |
Registration and welcome coffee |
|
| 5-55pm | Opening | Evgeny Shvarov |
| 6-00pm | Atelier 1.1 | Andreas Dieckow, Joyce Zhang, Michelle Stolwyk |
| 6-30pm | REST API in Caché |
Fabian Haupt |
| 7-00pm | Coffee break | |
| 7-30pm | Online Learning and Developer Community |
Douglas Foster, Evgeny Shvarov |
| 8-00pm | End of the Meetup. |
Hi All,
We have a application currently running on Zen framework, now business wants to use Angular JS as their front-end technology for any future release but they don't want to upgrade the existing the modules which are already there in Zen (as of now).
Hi, Community!
Recently we announced Developer Community Meetup in Cambridge, MA. Let me describe what is it.
Meetup it's a one evening event where you can enjoy some sessions by presenters (today InterSystems engineers, tomorrow you can be a presenter) and chat with local developers and InterSystems developers, engineers and product managers (depends on who is in town) and discuss your problems, experience, and success with InterSystems technologies.
InterSystems would provide the place, technical sessions, some food and beverages.
We think the Developer Community would benefit from it.
Hi, Community!
Let me share the news about InterSystems Technology Student Contest we just have launched!
marking code snippets as python doesn't enable highlighting for python code
Does anybody know good interesting and detailed articles or maybe bookes about the binding of SSL сertificates?
Thank you.
Some folks here may find this interesting:
https://groups.google.com/forum/#!topic/enterprise-web-developer-commun…
Question:
Where can I find the openssl command line tool for Windows?
Answer:
The openssl command line utility comes with Unix, but not with Windows. It is used for working with security certificates.
The main site is
There are no binaries on this site but in the Community section there is a link for binaries which leads to:
https://www.openssl.org/community/binaries.html
This contains a link to "An informal list of third party engines":
https://wiki.openssl.org/index.php/Binaries
At the time of writing this had two entries for OpenSSL for Windows.
This is a follow-up to Murray's article for scripting pButtons data extraction on Unix/MacOS: Extracting pButtons data to CSV for UNIX/MacOS
###Extracting pButtons data to a CSV file on Windows
PowerShell scripting was used in this article because it is available by default on Windows platforms.
The script, Extract_pButtons.ps1, will search the given pButtons file until it finds the marker for the beginning of the section. The section will be printed line-by-line, from the header to the line before the section end marker.
Hi, Community!
I'm glad to announce UK Technology Summit 2016 started!
#ISCTech2016 tag will help be in touch with all is happening in the Summit.
You are very welcome to discuss the Summit here in comments too!
If I am in a community on this website looking at articles would expect a search box at top so I can search within this community.
1) The search top right is too general (I don't want to have to sub search, refine or just ignore irrelevant results)
2) Most forums have the ability to easily search within them on other sites, which is what as a user I would expect
The recent post about help with the Cache Language and the responses were very helpful.
I suggest two new tags, and the tags being permanently toward the top of the tag list.
1) Help with understanding the Developer Community
2) Help with Cache and all the various off-shoots
Presenter: Rich Taylor
Task: Use an LDAP schema that differs from the provided default
Approach: Give examples of customized LDAP schema development, using LDAP APIs and ZAUTHORIZE
In this session we explore the various options of for working with LDAP as an authentication and authorization framework. We will look beyond the simple LDAP schemas into working with more complex LDAP configurations that incorporate application level security information.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Andreas Dieckow
Task: Securely store sensitive information
Approach: Give examples of data-at-rest encryption and data element encryption
Description: In this session, InterSystems will showcase how to use API calls to programmatically do everything using your own scripts. This approach is highly effective if you have recipe based settings and configurations that you would like to roll out in a controlled and fast fashion.
Problem: Implement Security relevant information correctly and how. Examples are Credit Card information, Sensitive information (e.g. SSN, Classified Information)
Solution: Data-at-rest encryption and data element encryption
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Andreas Dieckow
Task: Apply SQL security to multiple servers in a distributed system
Approach: Provide code samples for using new API calls to apply SQL security statements to multiple instances of our products
Description: The requirement that started at all. See examples on how to use this new feature and integrate it into your application by discuss code examples.
Problem: SQL Security is local to the instance and most of time driven by customer application code. That it is only local to the instance and is not automatically going to other instances requires a solution.
Solution: With application code use new API calls to issue SQL security statements that is applied to multiple instances.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Benjamin De Boe
Task: Perform advanced analytics on huge amounts of data
Approach: Use third-party analytics frameworks to leverage your entire clustered environment
In this session, we’ll explain what machine learning means and how it can help you gain insights in vast amounts of data, leveraging complex environments.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Harry Tong
Task: Load terabytes of data into a distributed environment
Approach: Leverage parallelism and open-source tools
In this session, we’ll discuss how to load TBs of data into a distributed environment, leveraging parallelism and open source to reach exceptional load rates.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Tony Pepper
Task: Host an application based on InterSystems’ technology in a public cloud environment
Approach: Provide a checklist of things to think about before you deploy
Are you looking at hosting your applications in the public cloud? This talk will highlight what you need to think about when deploying InterSystems technology in any public cloud environment.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Mark Bolinsky
Task: Provide failover for distributed systems without using a VIP
Approach: Demonstrate using InterSystems’ database mirroring with external traffic managers such as F5 LTM/GTM
With distributed environments and even public cloud environments, the use of a VIP sometimes is not desirable or even possible given network topology or deployment. The session will demonstrate integrating database mirroring with external traffic managers such F5 LTM/GTM using API based triggers in InterSystems products to interface with the F5 appliances. This not only presents automated redirection for the local mirror members, but also provided automated client redirection to asynchronous DR mirror members.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Michael Broesdorf
Task: Use the Internet of Things in a business application
Approach: Demonstrate incorporating device-generated messages into a business process, and using that information to trigger physical events
(Session Sequence: Dependent on EOPEN) IoT may be the most hyped idea of the year, but how do you actually make use of it in your business applications? This session gives a detailed demonstration of incorporating device generated messages into an business process, to interact with your business applications and triggering physical events as a part of a business process.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Alain Houf
Guest Speaker: Joop van Uden of Philips Healthcare
Task: Evolve your data model as you build your application
Approach: Provide a real-world example of how to leverage the flexibility of the document data model and how to easily integrate it into existing environments
Description: Come and learn how you can leverage new technology like the document data model in your current environment. We will explore a customer use case that managed to include this brand new technology within weeks in their current application stack and start to benefit from it.
Problem: Tools that help you build a stable backend, sometimes are in the way when you need to evolve.
Solution: Use flexible data models like the document data model for areas where you have to evolve constantly and mix and match it with the power of the OO and relational model.
Dependencies: Most value if session "The Power of Handling Data without a Schema" was attended before.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Luca Ravazzolo
Task: Track the status and performance of clustered environments
Approach: Give examples of using modern technology to spot potential bottlenecks before they turn into problems
This session will discuss how modern technology can be used to keep track of the status and performance of your cloud clustered environments.
Content related to this session, including slides, video and additional learning content can be found here.
Presenter: Mark Massias
Guest Speaker: Bruce Porteous of Northgate
Task: Build a composite application that bridges data silos
Approach: Give a real-world example of combining data from multiple sources to run a composite application
Most organizations need to bridge silos of data or combine separate applications. This session describes techniques for building composite applications and silos. The session also looks at a real application that does this. It uses workflow to assign cases to individuals for investigation and extracts information from multiple systems to provide the investigator with a complete context for the case at the scene of the incident.
Content related to this session, including slides, video and additional learning content can be found here.