lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kay <uh.keer...@gmail.com>
Subject Indexing Multiple Datasources
Date Mon, 11 Jun 2012 15:59:23 GMT
Hello,

We have 2 MS SQL Server Databases which we wanted to index .But most of the
columns in the Databases have the same names. For e.g. Both the DB’s have
the columns First name ,Last name ,etc.

How can you index multiple Databases using single db-data-config file and
one schema? 

Here is my data-config file
<dataConfig>

<dataSource type="JdbcDataSource" name="ds-2"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost;DatabaseName= " user="" password="" />
    <document name="PersonTable">
		<entity dataSource="ds-2" name="People" query="SELECT
BusinessEntityID,FirstName,LastName FROM dbo.PersonTable">
			<field column="BusinessEntityID" name="BusinessEntityID" />
			<field column="FirstName" name="FirstName" />
			<field column="LastName" name="LastName" />
			<field column="Department" name="Department" />
			<field column="Age" name="Age" />
			
		</entity>
		</document>
	    
    <document name="person">
		<entity dataSource="ds-1" name="People" query="SELECT   
BusinessEntityID,NameStyle,Title,FirstName,MiddleName,LastName,ModifiedDate
FROM AdventureWorks.Person.Person">
			<field column="BusinessEntityID" name="BusinessEntityID" />
			<field column="NameStyle" name="NameStyle" />
			<field column="Title" name="Title" />
			<field column="FirstName" name="FirstName" />
			<field column="MiddleName" name="MiddleName" />
			<field column="LastName" name="LastName" />
			<field column="ModifiedDate" name="ModifiedDate" />
		</entity>
    </document>	
			
</dataConfig>
And schema file:

<fields>
<field name="BusinessEntityID" type="string" indexed="true" stored="true"
required="true"/>
<field name="NameStyle" type="string" indexed="true" stored="true"/>
<field name="Title" type="string" indexed="true" stored="true"/>
<field name="FirstName" type="string" indexed="true" stored="true"/>
<field name="MiddleName" type="string" indexed="true" stored="true"/>
<field name="LastName" type="string" indexed="true" stored="true"/>
<field name="Department" type="string" indexed="true" stored="true"/>
<field name="Age" type="string" indexed="true" stored="true"/>
</fields>
 <uniqueKey>BusinessEntityID</uniqueKey>

 <defaultSearchField>LastName</defaultSearchField>


We would appreciate your help!

Thanks!


--
View this message in context: http://lucene.472066.n3.nabble.com/Indexing-Multiple-Datasources-tp3988957.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message