Endeca Integrator support for *.dita?

CloverDX Platform
1

Hello,
I’m just learning how to use Integrator. I have a project where we need to read data from *.dita files, which are just xml files. I’ve tried putting together a small Endeca Integrator project to try it out with some *.dita files, but am having two problems.

1. In Preferences > File Associations, I set up *.dita files to be opened up by the XML Editor. But when it tries to open them in the project, the editor says the files are empty on the Design tab, but clearly show the xml contents on the Source tab.

2. I am using XML_READER to read a *.dita file in a graph, and have mapped the nodes from the *dita files to the XML_READER, and created the metadata on the edge. But when I run the graph I get the following error:

ERROR [WatchDog_0] - Error details:
org.jetel.exception.JetelRuntimeException: Component [XMLReader:XMLREADER] finished with status ERROR.
at org.jetel.graph.Node.createNodeException(Node.java:535)
at org.jetel.graph.Node.run(Node.java:514)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.RuntimeException: field topicEPM not found on #0|Field1|S->

Is DITA supported in Endeca Integrator? They’re really only xml files, with a different extension - can Integrator read xml files even if they have a different extension?

Thank you.

2

Regarding reading/processing XML based data in CloverETL, you may watch following piece from CloverETL’s Quick Start Guide:

Using XMLExtract

3

I’ve now got an XML_EXTRACT that appears to read records from the dita files using a schema. Thanks!

Would you mind please pointing me to some documentation on creating the metadata, and configuring the Bulk Add/Replace? I’d appreciate it. I’m getting the error below:

ERROR [WatchDog_0] - Error details:
org.jetel.exception.JetelRuntimeException: Graph element [Bulk Add/Replace Records:BULK_ADD_REPLACE_RECORDS] failed with unknown cause.

Thanks again.

4

I can’t help you with BULK_ADD_REPLACE_RECORDS component as it is Endeca specific - you would need to contact Oracle Endeca support.

As for metadata in CloverETL in general, you have many options. You can create them manually or extract from some existing structure - like XSD.
See this doc on importing metadata from XSD file.
You may also look at the whole Metadata section of CloverETL Documentation.