Data Generation for XML Data Type stored in DB Column

[Premlal Digarse]

Dear All,

For one of our application - TEMENOS T24, we want to explore synthetic data generation however as our core banking app will store data as XML data type in database column,  we need your help if someone has done already.

1. Does CA TDM tool supports data generation for XML data type where XML data is stored in database columns. In our case the database is SQL server.
2. If it supports, do you have any documentation/ information/ flow to share which can help us understand on this.
   
   Regards
   Prem

[Marcy Nunns]

There is a support case open right now that seems similar to this use case.  Once we have a documented solution, I will post here.

~Marcy

[Premlal Digarse]

Hi Marcy,

Any update on this please?

Regards

Prem

[Marcy Nunns]

Found out that the TDM tool does not yet support data generation for XML data type where XML data is stored in database columns.   But hopefully soon.

[Premlal Digarse]

Hi Marcy,

Any update on this please?

Regards

Prem

[Rafael Cintra]

Hey @Premlal Digarse,

Just out of curiosity, what's the column data type where your XML data is stored? My understanding is that it would the native XML datatype avialable within SQL Server, right?

Thanks,

[Premlal Digarse]

Hi @Rafael Cintra,

Yes it is XML data type in SQL server DB.

Regards

Prem

[Premlal Digarse]

Hi @Marcy Nunns,

Would you please check if there is any update on this feature please? 

Not sure if I can follow up on this formally via any ticket ? Please suggest.

Regards

Prem

-------------------------------------------

[Marcy Nunns]

As per engineering, the answer should be yes - however Portal won't generate XML skeleton.  Your generator rules would be responsible for generating the whole XML document.

-------------------------------------------

[Premlal Digarse]

Thank you for the response @Marcy Nunns,

Do you have any documentation with a sample rule to generate a basic XML document.

Please share if it is available or any information around this would be helpful.

-------------------------------------------

[Marcy Nunns]

The sample rule could look like this:

<?xml version="1.0"?>
<root>
</root>

Or even simpler - just copy any valid XML document into generator and you will have sample rule for generating XML document.