Connect ODBC PCFILES for Hadoop Hortonworks

[yadiacho1]

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

[SASKiwi]

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. 

[Anand_V]

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.