Hi Wolfgang, ManifoldCF is meant to handle a binary document and its metadata. You must provide the document. Metadata is optional.
The JDBC connector does not currently support metadata. In order to index this, therefore, you will need to decide what should go into your "binary document" from your database fields. You can append together multiple fields into one document by means of SQL, e.g. the CONCAT operator or its Oracle equivalent. This would go into one field in Solr, then, which is what you'd search on. Alternatively, if you really need separate indexed fields in Solr for search reasons, you can request a JDBC connector enhancement to add metadata support. You'd still need a binary document, although you could return a blank value for that. So I guess the answer depends on what you are trying to do on the whole. Karl On Tue, Jul 17, 2012 at 6:27 AM, Wolfgang Schreiber <[email protected]> wrote: > Hello, > > we are trying to ingest data from an Oracle database into Solr. > We managed to insert docs into Solr but only document IDs are inserted and no > other data fields. > > Can you provide an example how to setup the import job in ManifoldCF ? > > > Assume we have the following initial situation: > > 1) Our Oracle table looks something like: > > ADDRESS > -------------------------- > ID NUMBER > ZIP NUMBER > CITY VARCHAR(2) > STREET VARCHAR(2) > > > 2) In Solr's schema.xml we added the following fields for the database > columns > ... > <field name="ZIP" type="int" indexed="true" stored="true" /> > <field name="City" type="string" indexed="true" stored="true" /> > <field name="Street" type="string" indexed="true" stored="true" /> > ... > > > So here are our questions: > > * How do we have to setup the queries for the ManifoldCF job? > In particular how exactly must the seeding query and the data query look > like? > > * How do the Solr field mappings look like? > > > We read your online documentation as well as your MEAP book but could not > find a workíng example for a successful import between Oracle and Solr. > Any help is welcome! > > Best regards > Wolfgang
