Rechercher

質問
· 2025年4月13日

Cache 2017 Linux ODBC with SSL Configuration

#Caché

Using Cache 2017.2 sever as my target.

I have a x64 Ubuntu client setup going.  This is NOT server. Just client. 

I have the Linux Ubuntu x64 ODBC driver gzip file. 

ODBC-2018.1.5.659.0-lnxubuntux64.tar.gz is all I could find.  Someone posted it in another post.

I can connect to a test sever that does NOT use SSL.  That works pretty easily.

But I have A server with SSL enabled. With Windows Cache ODBC drivers I can use SSL just fine.

This is what my SSLDefs.ini file on the Windows machines look like and it works just fine.

YES. I know. Not super secure because of the settings. Man in the middle, ect,ect ... but that is how it is currently working.
So I have to work with it.  ( Not my server )

[MyServer1 TLS to an instance without TLS-protected InterSystems ODBC]
Address=192.168.50.130
Port=1972
SSLConfig=TestServerSSL

[TestServerSSL]
Protocols=24
KeyType=2
VerifyPeer=0
CipherList=ALL:!aNULL:!eNULL:!EXP:!SSLv2
Password=
CertFile=
KeyFile=
CAfile=
[TLSNoVerify]
Protocols=16
KeyType=2
VerifyPeer=0
CipherList=ALL:!aNULL:!eNULL:!EXP:!SSLv2
Password=
CertFile=
KeyFile=
CAfile=

I can't find any good info for the Linux setup.
Exactly how to setup odbc.ini
How to possibly setup the equivalent of SSLdefs.ini for linux.
What exact path variables and such is needed.
ISC_SSLconfigurations path.
LD_LIBRARY_PATH for cconnect?
possibly a 3rd or 4th ini setting maybe?

Grok and ChatGPT can't make heads or tails of any of this. 
As I think it confuses IRIS and Cache so you end up with wonky results.

I just need example files for each exact INI file.
Where they go maybe?
and what system path variables and such to set to exactly.

 

Example of ODBC for Windows driver working fine with the SSL settings.

 

This is what I see when trying to connect to the SSL enabled server.

stevenc@HP:/etc$ isql -v TestServer
[S1000][unixODBC][Cache ODBC][State : S1000][Native Code 65530]
[libcacheodbc.so]
UNKNOWN MSG
[ISQL]ERROR: Could not SQLConnect
1 Comment
ディスカッション (1)0
続けるにはログインするか新規登録を行ってください
記事
· 2025年4月13日 2m read
Open Exchange

Building (strikeout) Prompting the UI for InterSystems FHIR With Lovable

#Artificial Intelligence (AI) #FHIR #フロントエンド #Generative AI (GenAI) #UI 開発 #InterSystems IRIS for Health

Hi developers!

This will be a very short article as in April 2025 with Lovable and other Prompt-to-UI tools it becomes possible to build the frontend with prompting. Even to the folks like me who is not familiar with modern UI techics at all.

Well, I know at least the words javascript, typescript and ReactJS, so in this very short article we will be building the ReactJS UI to InterSystems FHIR server with Lovable.ai.

Let's go!

First of all we will need an InterSystems FHIR Server instance. 

You can get it on AWS or you can spin it out directly on your laptop with IRIS for Health if you have docker installed.

I will follow the docker way - and the easiest step is to clone this Open Exchange repository with:

> cd devfoloder

>git clone  git clone git@github.com:intersystems-community/iris-fhir-template.git

>cd iris-fhir-template 

>docker compose up -d

Once started you can check FHIR server REST API working with the swagger at localhost:32873/swagger-ui/index.html:

Check some calls (e.g. Patient resource) and see that there is some data.

OK! Let's build the UI now.

Go to Lovable.dev and create an account, its free.

Ask Lovable to build the UI vs FHIR server, including the resources and functionality you want. E.g. prompt could be:

Dear Lovable! Please build the UI vs an FHIR server R4 to manipulate Patient, Medication, observation, and lab results resources. 

And it will build it out.

After it is done, ask Lovable to point the UI to a FHIR REST API URL: localhost:52873/fhir/v4.

And it should work. Make sure you set up proper user access (I'd start with no security initially just to make sure REST services receive and provide data properly) and feel free to improve the UI with prompting. 

Next you can ask lovable to deploy the solution to internet. To make it working make sure you deploy IRIS FHIR server as well or point to AWS one if you are there.

That's it!

Image

 

Lovely, isn't it?

Here is the video with all the steps and more:

2 Comments
ディスカッション (2)1
続けるにはログインするか新規登録を行ってください
ディスカッション
· 2025年4月12日

Code Golf - Maximum Coverage

#Code Golf #InterSystems IRIS

There is a list of numbers from 1 to 190.

AllList="1,2,3,4,5,6,7,8,9,.....,187,188,189,190"

There is a collection of sets of these values:

List(1)="3,5,6,7,9"
List(2)="1,2,6,9"
List(3)="5,8,9"
List(4)="2,4,6,8"
List(5)="4,7,9"

What is an elegant approach in Object Script to pick the least number of list items:

  • List(1)
  • List(5)
  • List(n)

That together would cover as many numbers as possible from the AllList.

Interested in best coverage over efficiency.

7 Comments
ディスカッション (7)1
続けるにはログインするか新規登録を行ってください
ディスカッション
· 2025年4月11日

Routers: Best practices for multiple operations

#ビジネスルール #Ensemble #Health Connect #InterSystems IRIS for Health

Hello 

We are pretty new to Ensemble and we are considering on using a default setup for our production. Let me explain the situation. We have one sender that sends HL7 ADT messages to our system. We have 60+ other systems that need to recieve ADT messages. We where thinking on a few ways on how to do the setup. 

Setup1:

We create one big ADTRouter that contains a first mapping. The result is send to another big ADTRouter that contains all the filters/expressions and mappings for the recieving systems. These' are the Pro's and Cons from my point of view I could be very wrong so please help me out here to know if I'm correct:

Pro's

- Not to much database overhead.

- I'm not sure but will this be performant?

Con's

- Not very maintainable.

-Could be slow and not performant?

 

Setup2

We still create on big router with one first mapping. But instead we send the result to 60+ other routers with their own filters/expressions, and mappings.

the pro's and con's from my point of view:

Pro's

- Very maintainable.

-I think it's faster then setup 1 but I'm not sure?

Con's

- A lot of database overhead

- Or could be slower then setup1? I'm not sure.

 

For maintenance I would prefer setup2 but I'm not sure on how this wil affect the database? And if this most performant way? And what the effect will be if we keep adding other routers? And advice would be very helpfull. 

Thanks in advance

4 Comments
ディスカッション (4)2
続けるにはログインするか新規登録を行ってください
お知らせ
· 2025年4月11日

[Video] Integrating DBT and Apache Airflow with InterSystems IRIS

#Global Summit 2024 #ビデオ #InterSystems IRIS #Summit

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Integrating DBT and Apache Airflow with InterSystems IRIS @ Global Summit 2024

This session is your guide to setting up efficient, manageable data pipelines that save time and boost reliability. We'll show you how to bring together the processing power of dbt, the scheduling strength of Apache Airflow, and the robust data management capabilities of InterSystems IRIS. By the end of this session, you'll have a clear understanding of how to implement these tools in harmony, making your data workflows smoother and more effective. This is perfect for those looking to enhance their data operations with straightforward, effective solutions.

Presenters:
🗣 @Reven Singh, Sales Engineer, InterSystems  
🗣 @Herman Bruwer, Sales Engineer, InterSystems  

Want to learn something new? Watch the video and subscribe for more!

ディスカッション (0)1
続けるにはログインするか新規登録を行ってください