---
updatedAt: 2026-09-28T14:53:24.000Z
agentTools:
projectIndex: https://developer.searchblox.com/llms.txt
---
# XML DB Connector
Setting up XML DB Connector
## **Create a Database Collection in SearchBlox**
* **Access Collection Creation**\
Log in to the SearchBlox Admin Console\
Go to the Collections tab\
Click either:\
Create a New Collection button, or\
The "+" (plus) icon in the collections panel
* **Configure Collection Type**\
Choose "Database Collection" from the list\
This allows the system to connect with XML databases
* Define Collection Properties\
**Collection Name:** Enter a unique name (example: XML\_Products)\
**Access Control:**\
Choose:\
Private – only selected users can access\
Public – everyone can access\
\*\* Security: **Enable/disable depending on how sensitive the data is\
\*\* Language:**\
Default is English\
Select another language if your content is in a different language
* **Finalize Creation**\
Click Save to create the collection\
A confirmation message will appear after successful creation
## **XMLSample Data**
The sample XML file is used to set up SQL queries and database connection URLs.
Steps to Test the DB Connector:
Download the XML file.
Save it in the required folder.
Follow the given instructions to check whether the DB connector is working properly.
```xml personal.xml
rootValue120MJohnDoesupportcodingcarHonda CivicABC Insurance12345sunroofrims07-17-2017oil change01-03-2018new tirestruckDodge RamABC Insurance12345lift kittow package08-27-2017new tires01-08-2018oil changework12345home12357internet24FJaneRobertssalesmarketingphonecarToyota CamryCar Insurance98765upgraded stereo05-11-2017tires rotated11-03-2017oil changecarHonda AccordCar Insurance98765custom paintcustom wheels10-07-2017new air filter01-13-2018new brakeshome98765work98753rootValue2rootValue3rootValue4
```
* The main element in this XML file is people.
* The structure of objects in the file is represented in the following table.\
[Learn more on Parsing XML Data](https://cdn.cdata.com/help/DVG/jdbc/pg_xmldatabase.htm)
[block:image]
{
"images": [
{
"image": [
"https://files.readme.io/8161f30-jsonrawdatastructure.png",
"jsonrawdatastructure.png",
569
],
"align": "center",
"caption": "**JSON Objects in the file**"
}
]
}
[/block]
## **Database Collection Settings**
Essential Configuration Parameters
* Database Type Selection\
Step: Open the Database Type dropdown menu\
Action: Select "XML" as the database type\
Purpose: This allows the system to properly read, process, and index XML data
* Select XML as the database type from the dropdown menu.
* Enter the Database URL String in the required format (as shown in the example).
* ```
jdbc:xml:DataModel=Relational;URI=file_path.xml
```
* Enter the exact URI (path or location) of your XML file.
* Enter the SQL query that will read the data from the XML file and store it.
* ```Text sql
SELECT * FROM xml_document
```
* Click Save to store your settings.
* Click Test Database Collection to verify the setup.\
The database connection must be successful for indexing to work properly.
> 📘 Configure SQL Query
>
> * To get data from the XML file, you must provide a SELECT SQL query.
> * You must map a unique field to uid (this is required).
> * The query should follow SQL SELECT query format with mappings. [SQL Query for Database Collection](https://developer.searchblox.com/docs/sql-query-for-db-collection)
> ```
> SELECT as uid , as title, as content FROM LIMIT 100
> ```
>
> * n the above query, the fields are shown using a hierarchical structure for example:
> ```
> [people].[personal.name.first]
> [people].[vehicles.maintenance.date]
> ```
>
> [Reference for select queries for Database XML Connector](https://cdn.cdata.com/help/DVG/jdbc/pg_systemtablesintro.htm)
>
> * If your table has more than 100 records, use the LIMIT option in your query to control how many documents are indexed.\
> Example:
> ```
> SELECT as uid , as title, as content FROM LIMIT 100
> ```
> Otherwise, a minimum of 50 rows will be indexed.
## **Schedule and Index**
This setting lets you choose when and how often a collection should be indexed.
Schedule Frequency options available in SearchBlox:
Once
Hourly
Daily
Every 48 Hours
Every 96 Hours
Weekly
Monthly
The following actions are available for Database Collections:
| Action | Description |
| :----------- | :----------------------------------------------------------------------------- |
| **Schedule** | You can set up automatic indexing for each collection using the options above. |
To know more about Database Collection refer [Database Collection](https://developer.searchblox.com/docs/database-collection)
Search results in faceted search is shown here:
