Versions Compared

Version Old Version 14 New Version 15
Changes made by

Utkucan Saraç (Unlicensed)

serdar ak

Saved on

Key

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

...

Tip

Conditions for connection

  1. A user with minimum readonly access to the database

  2. Connection for the database port, database name , Connection String

  3. If a separate driver is required for the connection, it must be installed (list and requirements are in the table below)Connection parameters (connection string) to the DB for readonly access

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

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

  6. 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. ( (info) This dialog only opens if you are logged into the server)

DBMS Driver Requirement List

Some databases may require an extra driver to be installed. Please check the list below.

Expand
titleDBMS Driver Requirement List

VTYS

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/

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.

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

Trouble Shooting

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

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 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. GEODI Server might be running on a low capacity machine, with insufficient memory or slow disk. Please check the system requirements page.

Expand
titleDB row version are increasing
Info

Every reindex (scheduled or manually) after the first index may generate version for tables w/o a primary key. This does not affect the discovery results, or reports bu only the GEODI Index size.

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

GEODI, by default, requires a primary key (PK) column to exist. So unless you set otherwise this situation does not occur. You may also choose to put a PK to your tables(a best practice). A PK column for GEODI is a column with a unique value in each row.

If table has PK but you still get the error, then primary key column name should be registered to GEODI by defining a DB meta.

Expand
titlePermissions are not affective
Info

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

FAQ

DB Meta

DBmeta is a way to change all behavior here by database and/or tablewise. This page contains necessary information about how DBmetas are defined.

...

Limit indexing by table or column.

Key

Description

WorkspaceName

WorkSpace(s) to which the settings will apply.

TableFilter

Tables to which the settings will apply.

ColumnFilter

Tables that contain the given columns (if - is given, tables that do not contain the relevant columns are considered). If more than one is given, the relationship is AND.

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBView, Geodi.Database",
         "WorkspaceName":"0000-Promotional and Educational Videos",
         "TableFilter":"*",
         "ColumnFilter":"*",         
         "Columns":"-FILEPATH,-ID,DATE,GEODIFILELINK"
      },
   ]
}

...

  • File1 column shows file names File2 column shows blob files. In the created database, the BLOB file column is selected as "bytea" data type.

  • You can use it in Access,Postgres,Mssql,Oracle,Sqlıte,MySql databases.

  • (warning) FileMemoColumn in VT must have a file extension in the given column.

    • If there is no extension in the column value and all files are of the same type, an extension can be added to the macro value.

Key

Description

FileMemoColumn

BLOB/MEMO field containing the file content. GEODI will automatically determine the file content

IDColumnMacro

Macro for the unique number of the file. The rules for macros are at the end of the document.

FileNameColumnMacro

Macro for the name of the file to appear in searches and viewers. Rules for macros are at the end of the document.

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
         "TableFilter":"TEST",
         "IDColumnMacro":"[OBJECTID]",
         "FileNameColumnMacro":"[FILE1]",
         "FileMemoColumn":"file2"
      }
   ]
}

...

  •  You can also index files specified by file links in a record. (CSV files are not supported).

Key

Description

FileFullPathColumnMacro

A macro that calculates the directories where files are located. This macro can be the value directly in a field (e.g. PATH), or it can be a path calculated in combination with other fields of the record.( Example: column name PATH on VT)

FileFullPathColumnSplitter

If there is more than one file in the file path, you can give the bracket character this way.

Code Block
languagejson
{
   "Defines":[
      {
         "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
         "FileFullPathColumnMacro":"[PATH]",
         "FileFullPathColumnSplitter":"|"
      }
   ]
}

...