Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

SAS Connection error

Hi All, How can I access the SAS connectivity as source using JDBC query consumer/JDBC multitable consumer?

We have been trying to connect to SAS Enterprise Guide 8.3 application having source staging component as JDBC query consumer & JDBC multitable consumer. We have also updated the DC libs with all the necessary drivers and still we were not able to connect to the SAS server. Below is the validation error we get during the preview. Could someone please help me with this connection. We were struggling hard with this from the last few weeks. Let me know if anything is required from my end.

JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Commit/Rollback not supported. : hikariConfigBean.connectionString