New post

Search

Clear filter
Question
Scott Roth · Dec 7, 2020

Linked Table vs Connecting to outside DB using JDBC and a Business Process (BPL)

I have a case where I need to look up the NPI provider against an External MS SQL database to retrieve our Provider Identifier to send to a downstream system. In the past I would use
Announcement
Ikram Shah · May 16, 2024

[Video] IRIS AI Studio Walkthrough: Unleash the Power of Vector Embeddings in IRIS DB

Hi Community, Here is a brief walkthrough on the capabilities of IRIS AI Studio platform. It covers one complete flow from loading data into IRIS DB as vector embeddings and retrieving
Article
Evgeniy Potapov · Aug 16, 2022

How to make drill down from IRIS DB to PowerBI via Adaptive Analytics

One of the most important tasks of dashboards is, on the one hand, to help you perceive data in an aggregated form, and, on the other hand, not to lose the depth of immersion in the
Question
Ankur Shah · Nov 5, 2019

Cache DB - How I can access identity column value in SqlComputeCode with property

How I can access identity column value in SqlComputeCode with property? I want to store the LabCode value in database as combination of LabName & LabID property. In LabCode field
Question
Rahul Reddi · Apr 2, 2022

missing cconnect executable error while connecting to remote DB from Wordpress based website

Hi Team, We are facing an issue connecting to a remote Cache DB server using CacheODBC 2018 on the client side. The connection works fine without SSL on the Cache server, but when
Question
Saghir Hussain · Jul 10, 2024

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS"

Hi I get the following error when I am trying to create a linked server connection via MS OLE DB Provider for ODBC Drivers in MS SQL Server Management Studio. The message I get is:
Article
Ikram Shah · May 18, 2024

IRIS AI Studio: Playground to explore RAG capabilities on top of IRIS DB vector embeddings

In the previous article, we saw in detail about Connectors, that let user upload their file and get it converted into embeddings and store it to IRIS DB. In this article, we'll explore
Question
Mark Runyan · Jun 27, 2023

Full Db backup cbk file from Cache 2017.2.2 needs to be restored for SQL access

We are retiring a hosted application for an electronic health care records (EHR) system which stored the data on Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.2.2 (Build
Question
Kunal Tiwari · Jul 10, 2025

Persistent Python DB-API Connection Issues (SSL Error) to IRIS CE Docker despite SSL disabled

Hello, I'm trying to connect a Python backend application to an InterSystems IRIS Community Edition instance running in a Docker container on an AWS EC2 instance. I'm facing persistent
Question
Kyle Johnson · Dec 29, 2017

OLE DB provider 'MSDASQL' for linked server returned data that does not match expected data length for column

I setup a linked server to a cache database to query the data and when I try an query the data I get OLE DB provider 'MSDASQL' for linked server 'xxx' returned data that does not match
Question
Lakshmi Ankireddipalli · Jun 16, 2023

How do we map Globals (holds data which spreads across different DBs) to multiple Databases

We are trying to come up with huge DataStore which needs to store HIPAA transactions and Data getting partitioned with idkey - YYYYMM. Current Live data get inserted into current Month

#DTL

240 Posts•7 Followers

t t

0 posts•0 comments
Article
David Loveluck · Sep 28, 2015

DTL TechFAQ

Ensemble is based on message flow, and a data transformation is a way to convert from one message type to another. DTL (Data Transformation Language) adds a layer to this - it provides
Question
DMITRIY SOSNOVIСН · Jul 29, 2020

Dbeaver support

Hi all, any news about support of the IRIS platform in the DBeaver? I only found this https://github.com/dbeaver/dbeaver/issues/6289 Github issue. They are waiting for a new version