SAS datasource is not honoring the JDBC Connection parameter called librefs

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