SAS datasource is not honoring the JDBC Connection parameter called librefs
book
Article ID: KB0083048
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
-
Description
SAS datasource is built using a custom adapter(parent adapter is: Composite). DataSource connection to SAS system is not pulling data as expected. TDV is looking up the default WORK schema instead of the WC_Claim schema defined on the Advanced section in the datasource with the ‘librefs’ parameter.
ERROR: File WORK.TPD_DISC.DATA does not exist
Issue/Introduction
SAS datasource is not honoring the JDBC Connection parameter called librefs
Resolution
1. After creating the SAS datasource, capabilities file needs to be updated and the SAS_Values.xml file needs to be generated 2. SAS_Values.xml file should be placed under CIS_HOME/conf/adapters/custom/sas directory 3. Attached is the XML file provided by the Advanced Services Team
Disclaimer: We provide this sas_values.xml free, but without any warranty or free support. Any support or modifications to this values XML file will be delivered through a billable Advanced Services engagement