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/

...

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.

...