lundi 27 avril 2015

How to Visualize nested XML documents in Elastic Search Kibana?

We want to store nested XML documents in Elastic search. Please find below the structure of the XML document .

<FileName>XYZ</FileName>
<Documents>
        <Document>
            <Identifier>DOC1</Identifier>
            <Type>XYZ Report</Type>
            <Pages>
                <Page>
                    <PageIdentifier>1</PageIdentifier>
                    <PageName>First Page</Page>
                </Page>
                <Page>
                    <PageIdentifier>2</PageIdentifier>
                    <PageName>Second Page</Page>
                </Page>
            </Pages>
        </Document>
        <Document>
            <Identifier>DOC2</Identifier>
            <Type>ABC Report</Type>
            <Pages>
                <Page>
                    <PageIdentifier>1</PageIdentifier>
                    <PageName>First Page</Page>
                </Page>
                <Page>
                    <PageIdentifier>2</PageIdentifier>
                    <PageName>Second Page</Page>
                </Page>
            </Pages>
        </Document>
</Documents>

Kindly answer my below queries

  1. Which is the best framework for converting XML documents to JSON to insert into Elastic Search.
  2. For visualization we are using Kibana along with elastic search . By default Kibana is not supporting JSON array objects. Which tool is used for unwinding the JSON arrays in elastic search. Is it possible to unwind the array in elastic search itself?
  3. Is it possible to use logstash for converting and inserting the XML documents which in residing in AWS S3?



Aucun commentaire:

Enregistrer un commentaire