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
