Hello, I am trying to connect Vertica using SAS university edition. Build date: Apr 14, 2014, 3:08:43 PM SAS Mid-tier release: Apr 14, 2014, 3:07:54 PM SAS release: 9.04.01M2P07232014 SAS platform: Linux LIN X64 2.6.32-431.23.3.el6.x86_64 Site name: SAS University Edition Site number: 70068118 As this is 9.04 release, I believe it should be able to connect to Vertica instance. But when I am trying to create a connection I am getting the below error. Code: libname sample VERTICA server="192.168.xx.xxx" port=5433 user=dbadmin password='XXXXXXXX' database='vmart'; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 42 ; 43 libname sample VERTICA server="192.168.72.128" port=5433 user=dbadmin password=XXXXXXXXXXX 44 database='vmart'; ERROR: The VERTICA engine cannot be found. ERROR: Error in the LIBNAME statement. 45 46 47 48 49 50 ; 51 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 ; Can someone guide me with this connectivity? Can I use ODBC DSN for this connectivity? If yes can someone share me the steps.
... View more