Automatic Database Discovery

Automatic Database Discovery enables you to quickly and easily add many Data Objects and Joins from a single Data Source. Discovery can only be performed on the following database types: mssql, oracle, mysql, postgresql, db2, and Informix.

To start using Database Discovery, select a Data Source and click the Discovery button (). This will open a discovery tab for the Data Source.

In the discovery tab you can do the following:

Customizing Data Discovery SQL

(v2016.3.6+) The SQL used for Automatic Database Discovery can be customized if necessary, in order to accommodate non-standard key names.

To customize the discovery SQL, locate the file dbconfigs.json in the Config/Other folder in the host application's install directory, and open it in a text editor.

Locate the property for your data source type and edit the SQL for either or both primary and foreign keys. Save the file, then run Database Discovery to see your changes.

data_discovery_sql.png

Note. Data discovery is not currently supported for ODBC data sources.