#Data Import and Export

This topic unites posts which describe approaches, tools, and solutions to import and export data into InterSystems IRIS and other InterSystems Data platform products: CSV, JSON, SQL, flat files, binary files, globals, streams, etc.

Year

AllTop

Question

Bransen Smith · Oct 29, 2024

How to programmatically export individual HL7 schemas?

As the title suggests, I would like to programmatically export each HL7 schema category as XML, either as a stream object or to a file. How would I go about doing this?

#Data Import and Export #Globals #HL7 #ObjectScript #InterSystems IRIS

2 4

1 166

Question

Rahul Raj · Oct 28, 2024

Exporting Cache data along with the table schema

Hi! I am trying to export Cache data to my SQL database and am trying to export the schema as well.

The Data Export wizard on the Management Portal only allows me to export the data but not the schema. Is there anyway to get the schema exported as well?

#Databases #Data Import and Export #Caché

0 4

1 159

Question

Bransen Smith · Oct 29, 2024

How to programmatically export individual Data Lookup Tables?

As the title suggests, I would like to programmatically export each individual data lookup table as XML, either as a stream object or to a file. How would I go about doing this?

#Data Import and Export #Globals #ObjectScript #InterSystems IRIS

0 4

0 138

Question

Philippe Ebinger · Oct 4, 2024

Why is the XML export different when executed through various methods (VS Code, Studio, and the console)?

I have three different methods for exporting classes and projects as XML files, but each one produces slightly different output:

#Data Import and Export #Studio #Terminal #VSCode #InterSystems IRIS

0 1

0 132

Question

Gabriel Silva d... · Jan 17

Problems with data replication in Caché 2016.2

Hello everyone,

I’m facing issues with replicating data from my Caché 2016 database to a PostgreSQL database. I need to handle around 300 data updates per minute, and whenever certain tables are modified, those changes must be reflected in other databases.

So far, I’ve tried various approaches, including:

#API #Azure #Databases #Data Import and Export #Performance #SQL #Caché

0 6

0 109