Nueva publicación

Encontrar

Pregunta
· 22 ene, 2025

Transform rows to colums or colums to rows

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 Comentario
Comentarios (1)1
Inicie sesión o regístrese para continuar
Anuncio
· 22 ene, 2025

[Video] Open Source LLMs

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! 👍

Comentarios (0)1
Inicie sesión o regístrese para continuar
Pregunta
· 22 ene, 2025

Question about using ODBC for SQL Gateway connections

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 comentarios
Comentarios (2)1
Inicie sesión o regístrese para continuar
Anuncio
· 22 ene, 2025

Looking for Exam Design Feedback for InterSystems ObjectScript Specialist Certification Exam

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 comentarios
Comentarios (3)2
Inicie sesión o regístrese para continuar
InterSystems Official
· 22 ene, 2025

Aprende FHIR como nunca antes

¡Tenemos un nuevo curso para ti!... pero sólo si te interesa estar a la última en el mundo de la interoperabilidad en entornos sanitarios. 

Igual no lo sabes, pero la familia de productos de InterSystems, con IRIS for Health y Health Connect a la cabeza, son la tecnología base para gestionar e integrar datos clínicos y administrativos de más de la mitad de la población de España... (por no hablar de EEUU, UK, Paises Bajos,...). Así que, teniendo en cuenta esto, si te dedicas al desarrollo de soluciones  o a la implementación de interfaces o integraciones en el sector salud, este es otro curso que no te puedes perder. Pincha y regístrate. ¡¡No lo dudes!!. Más que nada porque las plazas son limitadas... (ahí lo dejo, que luego me dicen que no lo aviso 😉).

¡Ah!, que se me olvidaba, el curso se llama: Implementación e integración de soluciones FHIR; es un curso online, de 21 horas lectivas y con él aprenderás cómo construir soluciones e integraciones con el protocolo HL7-FHIR en InterSystems IRIS for Health™ y HealthShare® Health Connect.  

¡¡Apúntate la fecha y resérvate los días!! 3 al 6 de Marzo de 2025(*).

Además, por ser la primera convocatoria que hacemos de este curso, quien se registre antes del 15 de Febrero tendrá un descuento del 60%.

¡¡Vamooooss!! Que las plazas son limitadas... lo he dicho ya, no? Pues avisado queda!! 🙂

Tienes toda la oferta formativa en nuestra página web, en la sección: Servicios de formación para partners y clientes
(*) Las fechas pueden variar. Consulta siempre la web para la información más actual

1 Comentario
Comentarios (1)2
Inicie sesión o regístrese para continuar