Amazon Redshift tables are not visible during introspection in TIBCO Data Virtualization
Article ID: KB0071781
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.
Issue/Introduction
This article illustrates introspection and adding Amazon Redshift datasource tables in TDV Server.
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.
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.
Additional Information
Feedback
Yes
No
Powered by
