Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

https://www.microsoft.com/en-us/download/details.aspx?id=100917#:~:text=Microsoft%20OLE%20DB%20Provider%20for%20DB2%20works%20with%20Microsoft%20SQL,tools%20to%20IBM%20Db2%20databases.

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

https://www.cdata.com/drivers/cassandra/download/

MongoDB

OLEDB or ODBC driver is required

https://www.devart.com/odbc/mongodb/

...

  1. The default behavior is to crawl all tables and rows.

  2. Tables must have primaryKey by default. You may choose to index tables w/o a primary key also.

  3. You may choose a sampling mode, as only the selected number of rows is indexed in each table.

  4. You may choose a subset of tables.

  5. You may limit columns by their names.

  6. You may define SQLs to change content to be indexed

  7. Embedded files are indexed with proper definitions

  8. File paths are processed with proper definitions

  9. 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.)

  10. When you search in GEODI, Each row is content. You may define the name and appearance of a record database or table-wise.

...

Expand
titleNo result from the DB sources
Info
  1. Connection string may not be correct. You should test before saving the project. You can do it now.

  2. Check the permissions

  3. Index error logs should be checked. You can examine the errors received in the scan with the developer report via GEODI.

  4. DBmetas may not be correct

  5. Jsettings files should be syntax validated, you can use https://jsonformatter.curiousconcept.com/ site for this validation.

  6. Check the correctness of the column, table and GEODI project names and their names on the Table/Column/Project database.

Expand
titleI have no DB connection but results shows many rows
Info

GEODI, by default, crawls file based databases like SQlite or Access. These files are processed like office or PDF files. You may set to ignore them.

...

Expand
titleDB row version are increasing
Info

Every reindex After the initial index, each subsequent indexing (scheduled or manually) after the first index may generate version for tables w/o manual) can create versions for tables without a primary key. This does not affect the discovery results , or reports bu but only impacts the GEODI Index index size.

GEODI indexing generates logs errors for such tables in the error logs. Please check . Check the error log to see wihih which tables are affected.

GEODI, by By default, GEODI requires a primary key (PK) column to exist. So unless you set otherwise this be present. This situation does not occur . You may also unless otherwise specified. Additionally, you can choose to put add a PK to your tables (a best practice). A For GEODI, a PK column for GEODI is a column with is one that has a unique value in each row.

If your table has a PK but you are still get the errorencountering errors, then the primary key column name should must be registered to recorded in GEODI by defining a DB meta.

...