How to save Data transformation Target data into Globals

Question

Question

Smythe Smythee · Apr 25, 2022

Hi Team,

I am Working on one data transformation, In the data transformation the data transformation data needs to be saved in the globals.

Can you please help me to save the data into the globals in a Persistent class.

Thanks in advance

Product version: Ensemble 2018.1

$ZV: Cache for Windows (x86-64) 2018.1.1 (Build 312_1_18937U) Fri Apr 26 2019 17:58:36 EDT

Discussion (7)1

Log in or sign up to continue

Marc Mundt · Apr 26, 2022

Since this is a new design you should use persistent classes (SQL tables/objects) instead of writing directly to globals. A Data Transformation can use any persistent class as it's target, so this is also easier than storing directly in globals.

https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI...

0 0

score 1 · Answer 1 · 2022-04-25T12:42:04-04:00

All persistent classes will save their data in globals automatically. It will save using the standard structures of the IRIS SQL layer.

If you have an existing global structure that you need to maintain you'll need to map your classes to your global structure. See this series of articles on how to do that.

score 0 · Answer 2 · 2022-04-26T05:04:17-04:00

Hi,

I need the save the value getting in my target message into the globals. please find the example for my data transformation

The value in the target message needs to stored in the globals. Can you please share any example so i can proceed further.

Thank you in advance

score 0 · Answer 3 · 2022-04-26T10:00:43-04:00

Can you explain more about your use case? What is the purpose of copying these fields directly into globals? Is there another application that will read the values from the globals?

score 0 · Answer 4 · 2022-04-26T10:21:10-04:00

Yes another application will take the date from the saved globals

About my user story

1.Store the patient information in Cache database

2.Store the patient information coming in ADT Message in Persistent class

score 0 · Answer 5 · 2022-04-26T10:28:07-04:00

Is there already a defined structure for these globals/do these globals already exist? Or will you design something new?

score 0 · Answer 6 · 2022-04-26T10:29:27-04:00

Smythe Smythee · Apr 26, 2022

I have define the new globals for this use case

0 0