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.

...

titleDBMS Driver Requirement List

...

Supported 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

...

Alternative Connection Methods

...

  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 . Check the error logs. Please check 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 one that has a column with 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.

...

Expand
titleHow can I open CRM application through GEODI search?
Info

It is possible. You index the CRM database and with a simple DB meta and set a link that opens the original CRM apps. CRM app should have a simple URL(query string) that can be build using the attributes.

...

DB Meta Definitions

Child pages (Children Display)