Hello!

I'm trying to create some foreign tables to a PostgreSQL database. In some cases, columns with certain datatypes cannot be consumed by IRIS and the following error is thrown:

[SQLCODE: <-237>:<Schema import for foreign table did not return column metadata>]

[%msg: <Unkown data type returned by external database>]

For example: serial4 typed ID columns are typical examples. Is it possible, what's the best way of resolving these datatypes, which- seemingly- don't have proper JDBC metadata mappings?

If one of your packages on OEX receives a review, you get notified by OEX only of YOUR own package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

Hey Community!

We're happy to share the next video in the "Code to Care" series on our InterSystems Developers YouTube:

⏯ From Words to Molecules: How AI Is Transforming Medicine and Beyond

https://www.youtube.com/embed/YK___IalmYE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi, Community!

Looking for an efficient way to allow providers to see whether prior authorization is required? See how the Coverage Requirements Discovery (CRD) module of the InterSystems Payer Services ePrior Authorization solution can help:

Coverage Requirements Discovery

https://www.youtube.com/embed/MY1If1CEjrM?utm_source=youtube&utm_medium=social&utm_campaign=MY1If1CEjrM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯ Foreign Tables In 2025.2 @ Ready 2025

https://www.youtube.com/embed/pIMa7lqWiHc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

🚀 We’re excited to share that InterSystems is once again joining Hack Jak Brno 2025.

📅 Event dates: 28 - 30 November 2025
📍 Location: Masaryk University in Brno
🔗 Learn more and register at www.hackjakbrno.cz 🚀

Hi Everyone,

As I'm sure most of you will be aware, we have an excellent resource available to developers in the Open Exchange, which is a place for Community Members to share open source resources, templates, tools and demos built with or for InterSystems technologies. This has been a massive success, with >1100 projects shared!

In my previous article, I structured network communications
in these 3 possible layers, and covered the last

• Client <---> Transport
• Server <---> Transport
• Client <---> Server

In fact, you have the most control over the last one.
The IRIS side as a server is yours and under your full control.
Up to now, the Transport layer was assumed to be as passive as a bare wire.

Here are the technology bonuses for the InterSystems "Bringing Ideas to Reality" Contest 2025 that will give you extra points in the voting:

• Developer Experience idea implemented - 4
• IRIS Vector Search usage -3
• Embedded Python usage -3
• InterSystems Interoperability - 3
• InterSystems IRIS BI - 3
• VSCode Plugin - 3
• FHIR Tools - 3
• Docker container usage -2
• ZPM Package Deployment - 2
• Online Demo -2
• Find and report a bug - 2
• Code Quality pass - 1
• Article on Developer Community - 2
• The second article on Developer Community - 1
• Video on YouTube - 3
• YouTube Short - 1
• First Time Contribution - 3

See the details below.

• HealthShare Unified Care Record Overview – Virtual December 15-16, 2025