cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Selvaraj
‎11-22-2018
  • 9 Posts
  • 0 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: SAS connecting to Microsoft SQL Server using DataDirect

by Fluorite | Level 6 in Administration and Deployment
‎03-16-2018 10:52 AM
‎03-16-2018 10:52 AM
Did you mean restarting the services? That won't be necessary. A new session would suffice. ... View more

Re: SAS connecting to Microsoft SQL Server using DataDirect

by Fluorite | Level 6 in Administration and Deployment
‎03-16-2018 10:36 AM
‎03-16-2018 10:36 AM
Ensure LD_LIBRARY_PATH is correctly setup in the sasenv_local file under SAS Foundation directory. ... View more

Re: How to Setup Google Big Query via ODBC on Linux?

by Fluorite | Level 6 in SAS Data Management
‎03-13-2018 01:01 PM
2 Likes
‎03-13-2018 01:01 PM
2 Likes
All,   We have managed to resolve this. The issue was with the Proxy server authentication. Out final odbc.ini file looks as below. Thanks.   Driver=</simba/googlebigqueryodbc/lib/64/libgooglebigqueryodbc_sb64.so> Catalog=<Project ID" OAuthMechanism=0 Email=<service account email id> KeyFilePath=<full path to the /xxxxx.p12> SQLDialect=1 ProxyHost=<proxy server url> ProxyPort=8080 TrustedCerts=/simba/googlebigqueryodbc/lib/64/cacerts.pem ProxyUid=<UID> ProxyPwd=<pwd>     Note: While setting up the library in SMC, ensure to provide the schema details to be able to register the tables.   ... View more

Re: How to Setup Google Big Query via ODBC on Linux?

by Fluorite | Level 6 in SAS Data Management
‎02-20-2018 07:35 AM
‎02-20-2018 07:35 AM
Hi Jeff,   The install we have chosen is the free simba driver provided by Google. We may not be able to get their support unless we have a commercial support contract.   Regards, Selva ... View more

Re: Running a Loop in Query Builder

by Fluorite | Level 6 in SAS Enterprise Guide
‎02-20-2018 07:22 AM
‎02-20-2018 07:22 AM
Hi Paul,   Original solution to pad zeros to a character variable is here https://communities.sas.com/t5/SAS-Procedures/how-to-pad-character-variable-with-leading-zeroes/td-p/40486   In EG query builder follow below steps >> Query Builder >> Add your input variables >> Add a new computed column >> Advanced Expression >> (repeat('0',8-length(COLUMNTOPAD0)-1)||COLUMNTOPAD0) and follow through to run the query   Hope this helps. Selva   ... View more

Re: How to Setup Google Big Query via ODBC on Linux?

by Fluorite | Level 6 in SAS Data Management
‎02-13-2018 01:13 PM
‎02-13-2018 01:13 PM
Hi Jeff, No, the linux servers may not get internet enabled. Alternatively, I am trying to use a proxy server by adding ProxyHost etc to the odbc.ini. Still getting the same error. Regards, Selva ... View more

Re: How to Setup Google Big Query via ODBC on Linux?

by Fluorite | Level 6 in SAS Data Management
‎02-13-2018 10:16 AM
‎02-13-2018 10:16 AM
Thanks Jeff. I am trying to get a proxy server to be added to the odbc.ini. Are there steps I am missing or are there any other pre-requisites I am missing? Thanks.   Selva ... View more

Re: How to Setup Google Big Query via ODBC on Linux?

by Fluorite | Level 6 in SAS Data Management
‎02-12-2018 09:18 AM
‎02-12-2018 09:18 AM
True. I am trying to understand if anyone has done this already and am I missing anything basic. Thanks.   Regards, Selva ... View more

How to Setup Google Big Query via ODBC on Linux?

by Fluorite | Level 6 in SAS Data Management
‎02-12-2018 08:44 AM
‎02-12-2018 08:44 AM
Hello All,   I am attempting to setup a connection to Google BigQuery via ODBC on a linux platform. Steps completed: 1) Install ODBC driver provided by Simba 2) Configure LD_LIBRARY_PATH on sas env 3) DSN entry on the odbc.ini file 4) placed a .p12 file on the same directory.   when I isql - <DSN> I get a error that "unable to decode the .p12 file.   Please could you let me know the correct steps to setup Google BigQuery via odbc on linux platforms. Are there any pre-requisites on linux I need to check?  Other points: O/S - RHEL 6.9 SAS - 9.4M2 This is a Grid architecture and the linux servers do not have internet enabled.    Advance thanks for your responses.   Regards, Selva ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-22-2018 09:49 AM
Likes from
View All
Quick links