topic Re: Connect ODBC PCFILES for Hadoop Hortonworks in New SAS User

Connect ODBC PCFILES for Hadoop Hortonworks

yadiacho1 — Thu, 05 Sep 2019 03:19:28 GMT

Hi,

I have BIG DATA and BIG Problem connecting it to SAS.

I was setting up ODBC driver Hortonwork ODBC and successfully connected

I got error Look like this :

libname hadeh PCFILES CONNECT_STRING="
Driver=Hortonworks Hive ODBC Driver;Host=prodxxxxxxxxxxx;
Port=10000;HiveServerType=2;AuthMech=1;ThriftTransport=SASL;
Schema=bm_bda_dana_pst;KrbRealm=SUPPxxxxxx;
KrbHostFQDN=prodxxxxxxxx;
KrbServiceName=hive" ;

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
ERROR: Error in the LIBNAME statement.

Where is my fault, is there something i missed ???need help and advice

Re: Connect ODBC PCFILES for Hadoop Hortonworks

SASKiwi — Thu, 05 Sep 2019 03:56:41 GMT

If you are trying to create an ODBC connection from SAS to Hortonworks then the engine to use is ODBC, not PCFILES. PCFILES is a special engine for connecting to Microsoft products like Excel and Access.

Re: Connect ODBC PCFILES for Hadoop Hortonworks

AnandVyas — Thu, 05 Sep 2019 04:51:28 GMT

Hi @yadiacho1 ,

You will have to use ODBC engine instead of PCFiles. If your site has SAS/Access to ODBC licensed and installed, you can find the libname reference for ODBC here

There are other considerations to be taken care if you are connecting to kerberized hadoop. This Paper provides with detailed information on that.