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.
Siddarthk, I apologize for not seeing this earlier.
This is an old thread, but it deserves an answer. Hopefully, it will help Google find the answer for others.
The University Edition does not include ACCESS engines.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.