MS SQL Server

1. Download Elasticsearch

2. Install Elasticsearch

   Follow instructions on https://www.elastic.co/products/elasticsearch

3. Install JDBC importer

   wget http://xbib.org/repository/org/xbib/elasticsearch/importer/elasticsearch-jdbc/<version>/elasticsearch-jdbc-<version>-dist.zip

   (update version respectively)

4. Download SQL Server JDBC driver from the vendor

5. Copy driver into lib folder

   cp SQLJDBC4.jar $JDBC_IMPORTER_HOME/lib

6. Set up the database you want to be indexed. This includes allowing TCP/IP connections

7. Start Elasticsearch

   ./elasticsearch.bat
   
   

8. Start JDBC importer

   bin=$JDBC_IMPORTER_HOME/bin
   
   lib=$JDBC_IMPORTER_HOME/lib
   
   echo '{
   
       "type" : "jdbc",
   
       "jdbc": {
   
           "url":"jdbc:sqlserver://localhost:1433;databaseName=ICFV",
   
           "user":"elasticsearch",
   
           "password":"elasticsearch",
   
           "sql":"select * from ScoreCards",
   
           "index" : "myindex",
   
           "type" : "mytype"
   
       }
   
   }' | java \
   
          -cp "${lib}/*" \
   
          -Dlog4j.configurationFile=${bin}/log4j2.xml \
   
          org.xbib.tools.Runner \
   
          org.xbib.tools.JDBCImporter
   
   

9. You should see messages from the importer in the logfile.

原文连接：https://github.com/jprante/elasticsearch-jdbc

关注公众号，获取更多相关文章