...
Use “New Connection” to choose the database and define the connection string.
...
...
Views can now be excluded if preferred. Since Views often contain data already present in other tables, excluding them will help reduce duplicate data discovery and improve performance.
...
Supported DBMS
Some databases may require an extra driver to be installed. Please check the list below.
VTYSSupported DBMS | Client |
---|---|
PostGres | No extra installation is required. |
Microsoft SQL Server | No extra installation is required. |
SqLite | No extra installation is required. |
Shape File | No extra installation is required. |
CSV File | No extra installation is required. |
KML File | No extra installation is required. |
SQLCE, SQL express | No extra installation is required. |
Kafka | No extra installation is required. |
Oracle (OleDB) | Oracle ODAC driver must be installed (12.1.0.2.1 and up). https://www.oracle.com/database/technologies/odac-downloads.html |
Excel | Access Database Engine 2010 must be installed. https://www.microsoft.com/en-us/download/details.aspx?id=13255 |
MS Access | Access Database Engine 2010 must be installed. https://www.microsoft.com/en-us/download/details.aspx?id=13255 |
DB2 | Oledb Driver must be installed. |
Oracle BigData | Microsoft Hive ODBC Driver must be installed. https://www.microsoft.com/en-us/download/details.aspx?id=40886 |
Cassandra | OLEDB or ODBC driver is required |
MongoDB | OLEDB or ODBC driver is required |
...
The default behavior is to crawl all tables and rows.
Tables must have primaryKey by default. You may choose to index tables w/o a primary key also.
You may choose a sampling mode, as only the selected number of rows is indexed in each table.
You may choose a subset of tables.
You may limit columns by their names.
You may define SQLs to change content to be indexed
Embedded files are indexed with proper definitions
File paths are processed with proper definitions
If rows have some permission information you may utilize it with proper definitions. (There are also different ways to define applications like CRM and ERP as sources.)
When you search in GEODI, Each row is content. You may define the name and appearance of a record database or table-wise.
...
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
...
Expand | ||
---|---|---|
| ||
|
...