Connection config for indexing a database to Solr

db-data-config

<dataConfig>
  <dataSource type="JdbcDataSource"
            driver="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/employees"
            user="user"
            password="password" /> 
  <document>
    <entity name="id" query="select emp_no as 'id', first_name, last_name from employees limit 1000;" />
  </document>
</dataConfig>

db-data-config2

select e.emp_no as 'id', e.birth_date,
	(
		select t.title
		order by t.`from_date` desc
		limit 1
	) as 'title_s', e.first_name, e.last_name, e.gender as 'gender_s', d.`dept_name` as 'dept_s'
from employees e
join dept_emp de on de.`emp_no` = e.`emp_no`
join departments d on d.`dept_no` = de.`dept_no`
join titles t on t.`emp_no` = e.`emp_no`
group by `emp_no`
limit 1000;

multiple-entitites

<dataConfig>
  <dataSource type="JdbcDataSource"
            driver="com.mysql.jdbc.Driver"
            name="employees_db"
            url="jdbc:mysql://localhost:3306/employees"
            user="user"/> 
  <dataSource type="JdbcDataSource"
            driver="com.mysql.jdbc.Driver"
            name="posten_db"
            url="jdbc:mysql://localhost:3306/kawdbprod1"
            user="user"
            password="password"/> 
  <document>
    <entity name="employees"
      dataSource="employees_db"
     query="select e.emp_no as 'id', e.birth_date,
	(
		select t.title
		order by t.from_date desc
		limit 1
	) as 'title_s', e.first_name, e.last_name, e.gender as 'gender_s', d.dept_name as 'dept_s', 'employees' as 'source_s'
from employees e
join dept_emp de on de.emp_no = e.emp_no
join departments d on d.dept_no = de.dept_no
join titles t on t.emp_no = e.emp_no
group by e.emp_no
limit 1000;" />
  <entity name="posten"
    dataSource="posten_db"
    query="select product_id as 'id', title as 'product_s', 'posten' as 'source_s'
          from kaw_produkt_valid_index limit 100;"
    />
  </document>
</dataConfig>