Hello Karl, thank you very much for your quick answer!
So if I understand correctly ... 1) ... all mappings added to the "Solr Field Mapping" tab are ignored in case of a JDBC resource connector? 2) Our data query must look somehow like (regarding that || is Oracle's concatenation operator): SELECT ID AS "$(IDCOLUMN)", ADDRESS_URL AS "$(URLCOLUMN)", 'ZIP:' || ZIP || ';city:' || CITY || ';street:' || STREET AS "$(DATACOLUMN)" FROM ADDRESS WHERE ID IN $(IDLIST) This would result into DATACOLUMN values like: ZIP:70173;City:Stuttgart;Street:Heilbronner We tried this statement and we got the data into the text field of our Solr index. It seems we are one step further! Thank you for your help! Best regards Wolfgang -----Ursprüngliche Nachricht----- Von: Karl Wright [mailto:[email protected]] Gesendet: Di 17.07.2012 12:42 An: [email protected] Betreff: Re: How to import data from Oracle to Solr 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
