Thank you for your response @sastpw !! I'm however not able to establish connection following the code which you provided. I replaced the userid and password with my userid and password of SAS ODA and while running the below connection step, I get the error, could you please provide your inputs. I'm getting error in below step: # this will use ‘default’ in the example config, but you overrode everything (i overrode already) so it will use IOM remote sas = saspy.SASsession(**oda, display='databricks') sas This is the error which i get: Using SAS Config named: default We failed in getConnection The application could not log on to the server "odaws04-usw2.oda.sas.com:8591". The load balancing object spawner timed out. SAS process has terminated unexpectedly. Pid State= (6908, 64000) SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file. Attempted to run program /usr/bin/java with the following parameters:['/usr/bin/java', '-classpath', '/databricks/python/lib/python3.8/site-packages/saspy/java/saspyiom.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/log4j-1.2-api-2.12.4.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/log4j-api-2.12.4.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/log4j-core-2.12.4.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/sas.security.sspi.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/sas.core.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/sas.svc.connection.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/sas.rutil.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/sas.rutil.nls.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/iomclient/sastpj.rutil.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/thirdparty/glassfish-corba-internal-api.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/thirdparty/glassfish-corba-omgapi.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/thirdparty/glassfish-corba-orb.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/thirdparty/pfl-basic.jar:/databricks/python/lib/python3.8/site-packages/saspy/java/thirdparty/pfl-tf.jar', 'pyiom.saspy2j', '-host', 'localhost', '-stdinport', '46581', '-stdoutport', '46951', '-stderrport', '55619', '-iomhost', 'odaws01-usw2.oda.sas.com;odaws02-usw2.oda.sas.com;odaws03-usw2.oda.sas.com;odaws04-usw2.oda.sas.com', '-iomport', '8591', '-user', 'pdwivedi08@gmail.com', '-lrecl', '1048576', ''] No SAS process attached. SAS process has terminated unexpectedly. Invalid response from SAS on inital submission. printing the SASLOG as diagnostic SASIOConnectionError: Failure establishing SASsession. Do I've to do anything in sascfg_personal.py ? And as of now, this file is stored in my PC but if I've to connect to Azure Databricks do I've to store it some other place or the one in my PC will work ? I have sascfg_personal.py in 'C:\\Program Files (x86)\\Java\\jre1.8.0_221\\bin\\java.exe' and I tried changing java location to this as well but getting same error. Also, I had changed 'iomhost' : ['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'] to run but it's not working. Kindly advise anything else which I can try.
... View more