What does your Solr.log say? Any error ?
> Am 17.04.2020 um 20:22 schrieb RaviKiran Moola > <ravikiran.moola@radiant.digital>: > > > Hi, > > Greetings!!! > > We are working on indexing data from multiple data sources (MySQL & MSSQL) in > a single collection. We specified data source details like connection details > along with the required fields for both data sources in a single data config > file, along with specified required fields details in the managed schema and > here fetching the same columns from both data sources by specifying the > common “unique key”. > > Unable to index the data from the data sources using solr. > > Here I’m attaching the data config file and screenshot. > > Data config file: > <dataConfig> > <dataSource type="Jdbc-1" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://182.74.133.92:3306/ra_dev" user="devuser" > password="Welcome_009" batchSize="1" /> > <dataSource type="Jdbc-2" > driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://182.74.133.92;databasename=BB_SOLR" user="matuser" > password="MatDev:07"/> > <document name="mbc details"> > <entity name="ra_details" dataSource="Jdbc-1" query="SELECT > MBC_NUMBER,ACTIVE_FLAG FROM mbc_tbl"> > <field column="MBC_NUMBER" name="MBC_NUMBER"/> > <field column="ACTIVE_FLAG" name="ACTIVE_FLAG"/> > <entity name="mbc_details" dataSource="Jdbc-2" query="SELECT > MBC_NUMBER,ACTIVE_FLAG FROM mbc_tbl"> > <field column="MBC_NUMBER" name="MBC_NUMBER"/> > <field column="ACTIVE_FLAG" name="ACTIVE_FLAG"/> > </entity> > </entity> > </document> > </dataConfig> > > > Thanks & Regards, > Ravikiran Moola > +91-9494924492 >
