...
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. |
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 |
MongoDB | OLEDB or ODBC driver is required |
...