Amazon Redshift tables are not visible during introspection in TIBCO Data Virtualization
book
Article ID: KB0071781
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All supported versions
Description
The datasource connection in TIBCO Data Virtualization (TDV) Server to the Redshift server is successful. However, tables could not be viewed during introspection.
Environment
All supported environments
Resolution
1. Download the latest Redshift adapter from the CDATA site referenced below. 2. Place the tdv.redshift.jar in the <TDV Install Dir>\packages\autodeploy_ds_adapters folder. 3. Add the below properties in the redshift.capabilities file, located at [TDV_Install_Dir]apps\dlm\cis_ds_redshift\conf: ***** introspect.relational.table_types: TABLE,VIEW,ALIAS,SYNONYM,SYSTEM TABLE,SYSTEM VIEW,SYSTEM INDEX,EXTERNAL TABLE ***** 4. Restart the TDV server so the adapter is deployed and the capability set is picked up by the TDV server.
Issue/Introduction
This article illustrates introspection and adding Amazon Redshift datasource tables in TDV Server.