Nova postagem

Pesquisar

Pergunta
· jan 22

write local file in health connect cloud

#Operação de negócios #DTL #FTP #HL7 #Health Connect

Hello,

I hope this is a simple ask..

basically I need to create local files daily at a certain time for example 11:30pm.

1. file name needs to be like  xxx__20250113.txt , the date part should be next day's timestamp with format YYYYMMDD, so I will write about 17 files like that with different names.

2. write a dummy hard coded word for example “Dummy Word” in the file.  the file eventually will be used by other operations to add hl7 message on top of this  in it with the live interface message. 

3. this needs to be done every night at 11:45pm

So how am I going to implement this?

     1. Should this be like an operation on a schedule? If so, how exactly that can be done?

      2. Should I do this in Vss code and use task manager? If so, how can it be done?

Thanks for your input!

btw, this is on cloud version

Discussão (0)1
Entre ou crie uma conta para continuar
Pergunta
· jan 22

Transform rows to colums or colums to rows

#SQL #Caché #InterSystems IRIS

Hello guys,

I need to tranform columns into rows or rows into columns.

I'm using only SQL Cache.

The code:

SELECT
    codRepresentante
    ,vendasAbril
    ,vendasAgosto
FROM
    Ped.MetasRepresen
WHERE ano = 2024

The columns: 

Can you help me?

Thanks

1 Comment
Discussão (1)1
Entre ou crie uma conta para continuar
Anúncio
· jan 22

[Video] Open Source LLMs

#Artificial Intelligence (AI) #Large Language Model (LLM) #Vídeo #Outro

Hi Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Open Source LLMs

In this video, we explore the differences between open-source and proprietary large language models (LLMs). Proprietary models, like those from OpenAI or Google, operate as black boxes hosted in their cloud environments, offering high-quality performance but limiting data control and fine-tuning options. In contrast, open-source models can be downloaded and run locally, offering greater flexibility, transparency, and control over data, though they often require significant hardware resources and may deliver lower-quality output.

🗣  Presenter: @Don Woodlock, Vice President, Healthcare Solutions Development, InterSystems

Enjoy watching, and look forward to more videos! 👍

Discussão (0)1
Entre ou crie uma conta para continuar
Pergunta
· jan 22

Question about using ODBC for SQL Gateway connections

#JDBC #ODBC #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS

I am currently experiencing frustration with trying to Authenticate an Active Directory account through JDBC as the Hospital System moves from OnPrem SQL Server to using Azure SQL Server with Microsoft Entra Authentication.

Microsoft cannot give me a straight answer of what is required from a JDBC standpoint to authenticate from a Linux environment.

I am working with WRC, but we are both struggling to find the specific answer for JDBC. If I use my local desktop and JDBC to connect through DBeaver I don't have an issue. So, I am thinking the issue is with not having a java keystore, or keys setup within Linux for this to work.

It got me thinking is that we do not have this issue with the Linux ODBC connections we use with Perl so maybe I should move to using ODBC in Intersystems as well. But we have so much code developed using the existing JDBC SQL Gateway connections, so I have some questions.

  • What is the difference between using JDBC vs ODBC for SQL Gateway connections?
  • How does it affect the SQL Adapters/code that is already in use if we move to ODBC from JDBC?
  • Where does the ODBC.ini have to live for InterSystems to work?
    • the Documentation references the Templates in the bin directory, but those are templates. Where do I need to put the true odbc.ini that I intend to use?
  • Can I use my existing Linux ODBC.ini?

 

Thanks

Scott

2 Comments
Discussão (2)1
Entre ou crie uma conta para continuar
Anúncio
· jan 22

Looking for Exam Design Feedback for InterSystems ObjectScript Specialist Certification Exam

#Certificação #ObjectScript #SQL #InterSystems IRIS #InterSystems IRIS for Health

Hi Everyone!

The Certification Team of InterSystems Learning Services is currently developing an InterSystems ObjectScript Specialist certification exam, and we are reaching out to our community for feedback that will help us evaluate and establish the contents of this exam.   

Please note that this is one of two exams being developed to replace our InterSystems IRIS Core Solutions Developer exam. You can find more details about the other exam, InterSystems IRIS Developer Professional exam, here. 

How do I provide my input? Complete our Job Task Analysis (JTA) survey! We will present you with a list of job tasks, and you will rate them on their importance as well as other factors. 

How much effort is involved? It takes about 20-30 minutes to fill out the survey. You can be anonymous or identify yourself and ask us to get back to you.  

How can I access the survey? You can access the survey here. 

  • Survey does not work well on mobile devices - you can access it, but it will involve a lot of scrolling.
  • Survey can be resumable if you return to it on the same device in the same browser – Use the Next button at the bottom of the page to save your answers 
  • Survey will close on March 15, 2025 

What’s in it for me? You get to weigh in on the exam topics for our new exam, and as a token of our appreciation, all participants will be entered into a raffle where 10 lucky winners will receive a $50 Tango gift card, Global Masters points, and potentially other swag. Note: Tango gift cards are only available for US-based participants. InterSystems and VA employees are not eligible. 

Here are the exam title and the definition of the target role: 

InterSystems ObjectScript Specialist 

An IT professional who is familiar with object-oriented programming concepts and: 

  • creates InterSystems IRIS classes, 
  • writes and reviews InterSystems ObjectScript and SQL code, and 
  • uses both objects and SQL for data access. 

At least six months to one year of experience with the tasks listed above is recommended. 

3 Comments
Discussão (3)2
Entre ou crie uma conta para continuar