This steps opens a dialog with all the database connections:
The Import Criteria dialog will open next, showing a default query string like select * from table in the SQL Query pane:
The dialog contains the following items:
The SQL Query string is editable. You can specify which fields should be taken into consideration.
If you edit the query string so that the query does a join of two or more tables and selects columns with the same name from different tables you should use an alias for the columns like in the following example. That will avoid a confusion of two columns mapped to the same name in the result document of the importing operation.
select s.subcat_id, s.nr as s_nr, s.name, q.q_id, q.nr as q_nr, q.q_text from faq.subcategory s, faq.question q where ...The input data will be displayed in a tabular form in the Import Settings panel. The XML Import Preview panel will contain an example of what the generated XML will look like.