Sure, you can handle it. But should you?
Let our experts manage the tech maintenance while you focus on your business.
Let our experts manage the tech maintenance while you focus on your business.
Configuration
Database Connector
Introduction
The Database Connector enables PostgreSQL, MySQL and Oracle databases to be indexed quickly and easily so that this data can then be used in Insight Apps, the Mindbreeze InSpire AI Chat or 360-Degree Views.
Configuration
Configuration of the index
In the Management Center, go to the “Configuration” menu and click the “Indices” tab. Then click “Add Index” to create a new index (optional).
Enter the index path to the database you want to index. If necessary, adjust “Display Name” of the index service and the associated “Filter Service”:
Configuration of the data source
Setup
Add a new data source with the “Add Data Source”.
Performance Settings (Advanced Setting)
Description | |
Concurrent Filter and Index Dispatch Threads | The number of threads dispatching data to the filter service and index service. If the number is smaller or equal to zero, serial dispatching is caused. |
Database Connection
Description | |||||||||
Database Driver* | Specifies the database driver used for connections. The following databases are available:
| ||||||||
Database Connection* | Specifies the JDBC connection string used to connect to the database. Examples:
| ||||||||
Database Credential* | The database credentials must be configured in the „Network“ Tab and selected here for authentication | ||||||||
* = These settings must be configured so that the connector works and is built. All other settings must be configured according to the application. | |||||||||
Metadata Settings
Description | |
Key Column Name* | Specifies the name of the column in the database table that acts as the unique key for Mindbreeze documents sent to the Mindbreeze filter and index service by the connector. |
Content Column Name* | Defines which column in the database table should be used as Mindbreeze document content. |
Group Property Name | Specifies the name of the property that contains multiple items. The column values used as items are defined by the setting „Grouped Properties“. |
ACL Grant Column Name* | Specifies the name of the column in the database table whose values represent a Grant Access Control Entry (ACE) in the Access Control List (ACL) for the indexed document. These values determine which users or groups are granted access to the search results. |
ACL Deny Column Name | Specifies the name of the column in the database table whose values represent a Grant Access Control Entry (ACE) in the Access Control List (ACL) for the indexed document. These values determine which users or groups are denied access to the search results. |
ACL Separator | Defines the character or string used to separate multiple values in the columns „ACL Grant Property“ and „ACL Deny Property“. |
Grant access to "everyone" per Defaut | If this is activated, access to search results will be granted to all users by default. |
Dynamic Aggregated Metadata | Specifies the column whose values (for each row) should be aggregated and counted in the search results. |
Grouped Properties | Defines the column names seperated by a semicolon (;) whose values should be grouped as a list of items under the property specified by the setting „Group Property Name“. |
* = These settings must be configured so that the connector works and is built. All other settings must be configured according to the application. | |
Extract Metadata
These settings are used to define metadata fields that follow a specific format, such as numbers, dates, or strings. For each such metadata field, the following configurations must be provided:
Description | |||||||
Target Property Name | The name of the property as it will appear in the Mindbreeze document. There are two predefined property names that can be configured when needed:
These properties should have date format in the database and their pattern should be defined in the setting „Format Options“. | ||||||
Source Property Name | The name of the corresponding column in the database table. | ||||||
Format | Specifies the data type of the source value:
| ||||||
Format Options | Defines the format pattern used to parse the source value. This is especially important for dates. Example: yyyy-MM-dd HH:mm:ss for a timestamp format. |
Query
Description | |
Query | The SQL query used to select data from the database table. |
Minimum Expected Query Results | Specifies the minimum number of results the SQL query is expected to return. This setting helps to prevent the accidental deletion of indexed data in cases where the query temporarily returns fewer results (e.g., due to a network issue or partial data availability).
|
References
If there are columns in the database table whose values refer to other rows in the same table, these values can be indexed as „Reference properties“. Reference properties allow you to enrich documents with additional metadata from the referenced rows.
For detailed guidance on how to use reference properties for metadata enrichment, see the documentation Configuration - Metadata Enrichment - General Information.
The following settings must be configured to enable reference property handling during crawling:
Description | |
Name | The name of the reference property in the Mindbreeze document. |
Value | The name of the column whose value points to the key column of another row in the same table. |
Category Name | The category of the reference property. Hint: This must be set to "Database". |
Category Instance | The category instance of the connector instance that has indexed the referenced row of the table. |