How to ignore procedures during introspection of a PostgreSQL data-source in TIBCO Data Virtualization?

How to ignore procedures during introspection of a PostgreSQL data-source in TIBCO Data Virtualization?

book

Article ID: KB0075884

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

The article describes the process to bypass procedures during introspection of a PostgreSQL data-source in TDV.

Issue/Introduction

How to ignore procedures during introspection of a PostgreSQL data-source in TIBCO Data Virtualization?

Resolution

You will be able to introspect everything except procedures on PostgreSQL data-source  by making the following changes to the files located in <TDV_INSTALL_DIR>\apps\dlm\cis_ds_postgresql\conf\ directory.

  • Changing the parameter introspect.relational.include_procedure to "false" in the postgres_<version>.capabilities file.
    User-added image

  •  Changing the configuration "introspect.relational.include_procedure" to "false" in postgresql_<version_config.defs.xml file.
    User-added image


 

Powered by Wolken Software