# Jdbc importer config file

**URL:** <https://discuss.elastic.co/t/jdbc-importer-config-file/85068>\
**Category:** Elasticsearch\
**Created:** [May 9, 2017, 11:00am UTC](https://discuss.elastic.co/t/jdbc-importer-config-file/85068 "2017-05-09T11:00:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gowtham](https://avatars.discourse-cdn.com/v4/letter/g/b4bc9f/32.png) [@gowtham](https://discuss.elastic.co/u/gowtham)\
**Post date:** [May 9, 2017, 11:00am UTC](https://discuss.elastic.co/t/jdbc-importer-config-file/85068/1 "2017-05-09T11:00:30Z")

</div>

@echo off

set DIR=%~dp0  
set LIB=%DIR%..\lib\*  
set BIN=%DIR%..\bin

REM ???  
echo {^  
"type" : "jdbc",^  
"jdbc" : {^  
"url" : "jdbc:mysql://localhost:3306/xxx",^  
"user" : "xxx",^  
"password" : "xxx",^  
"sql":[^  
{^  
"statement":"use authmaster";},^  
{^"statement":"create TABLE user select auth\_user.user\_id,center\_details.center\_name,center\_details.schema\_name,schema\_mapping.server\_url,user\_audit.\* from user\_audit inner join user\_schema\_info on user\_schema\_info.id=user\_audit.user\_schema\_info\_id inner join center\_details on center\_details.center\_id=user\_schema\_info.center\_id inner join schema\_mapping on user\_schema\_info.schema\_name=schema\_mapping.schema\_name inner join auth\_user on auth\_user.id=user\_schema\_info.auth\_user\_id";},^  
{^"statement":"select \* from user";},^  
]^  
"elasticsearch" : {^  
"cluster" : "elasticsearch",^  
"host" : "localhost",^  
"port" : 9300^  
},^  
"index" : "meta",^  
"type":"user"^  
}^  
}^ | "%JAVA\_HOME%\bin\java" -cp "%LIB%" -Dlog4j.configurationFile="%BIN%\log4j2.xml" "org.xbib.tools.Runner" "org.xbib.tools.JDBCImporter"  
how to perform join operation in jdbc importer

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 6, 2017, 11:00am UTC](https://discuss.elastic.co/t/jdbc-importer-config-file/85068/2 "2017-06-06T11:00:38Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.