Importing from Multiple tables using Solr DIH

[Souvik Chakraborty]

Hi all,

 

I have the below configuration which is working absolutely fine.

 

 

Data-config.xml:

 

<?xml version="1.0" encoding="UTF-8" ?>

<dataConfig>

<dataSource name="db" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@//172.16.29.92:1521/d11gr21" user="eig_nbl_dev"
password="eig_nbl_dev"/>

<dataSource name="dastream" type="FieldStreamDataSource" />

<document>

  <entity 

      name="messages" pk="BLOB_PK" transformer='DateFormatTransformer'

      query="select * from BLOB_TEST"

                  deltaQuery="select BLOB_PK from BLOB_TEST where
to_char(last_modified,'YYYY-MM-DD HH24:MI:SS') &gt;
'${dataimporter.last_index_time}' "

      dataSource="db">

                <field column ="BLOB_PK" name ="id" />

                <field column="last_modified"  dateTimeFormat="YYYY-MM-DD
HH24:MI:SS" locale="en" />

    <entity 

        name="message" 

        dataSource="dastream"

        processor="TikaEntityProcessor"

        url="message"

        dataField="messages.MESSAGE"

        format="text">

                                

        <field column="text" name="mxMsg" blob="true" />

      </entity>

    </entity> 

 </document>

</dataConfig>

 

Now my requirement is that I have a similar table BLOB_TEST1 and have the
same fields as that of BLOB_TEST.

I wish to index it the same way as I have done it for BLOB_TEST.

Can't figure out how to accomplish that.

Any help would be highly appreciated.

 

-Souvik