Versions Compared

Key

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

...

Tip

Conditions for connection

  1. Connection parameters (connection string) to the DB for readonly read-only access

  2. Find the DB name on the table below if an additional driver is required (like ODAC for Oracle)

  3. Sampled data discovery decision (N record per table)

  4. Decision The decision for Indexing and discovery of Embedded or linked files ya da linkli dosyalar

...

Use “New Connection” to choose the database and define the connection string.

...

Supported DBMS

Client

PostGres

No extra installation is required.

Microsoft SQL Server

No extra installation is required.

SqLiteSybase

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 DB2

Oledb Driver must be installed.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

MS Access

Access Database Engine 2010 =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=13255

DB2

Oledb Driver 40886

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.

Excel

Access Database Engine 2010 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 13255

MS Access

Access Database Engine 2010 must be installed.

https://www.microsoft.com/en-us/download/details.aspx?id=4088613255

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/

...

Expand
titleNo result from the DB sources
Info
  1. Connection The connection string may not be correct. You should test it before saving the project. You , which 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 rowstables(*.geodi_table) and rows(*.geodi_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 themSQLite or Access by name in default settings. You may install a module from DECE-STORE to override this setting and discover rows.

Expand
titleEmbedded or linked files does not shown
Info
  1. You should define DB meta to do that. This page explains ho to create DB metas.

Expand
titleIndexing is slow
Info
  1. By default, GEODI crawls all table tables and all rows. You may use sampled discovery , or narrow the target.

  2. Your DB might also be serving another application.

  3. GEODI indexing speed options might be at low, increase it.

  4. The GEODI Server might be running on a low-capacity machine , with insufficient memory or a slow disk. Please check the system requirements page.

Expand
titleDB row version are increasing
Info

After the initial index, each subsequent indexing (scheduled or manual) can create versions for tables without a primary key. This does not affect discovery results or reports but only impacts the GEODI index size.

GEODI indexing logs errors for such tables. Check the error log to see which tables are affected.

By default, GEODI requires a primary key (PK) column to be present. This situation does not occur unless otherwise specified. Additionally, you can choose to add a PK to your tables (best practice). For GEODI, a PK column is one that has a unique value in each row.

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

Expand
titlePermissions are not affective
Info

GEODI, by By default, GEODI reads all rows with the same persmissionspermissions. To set a row-based permission, please use DB meta.

FAQ

Expand
titleCan i discover permissons on rows or files?

Yes. Using DBmeta, you can read rows or embedded file permissions from a database.

Expand
titleCan I index embedded files in the tables?
Info

Yes. with With a few simple DBmeta definitions, you may index those files. In this case, GEODI will show the row and file separately. You will be able to query the file using DB attributes.

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. The CRM app should have a simple URL(query string) that can be build built using the attributes.

...

DB Meta Definitions

...