topic SAS connection to Databricks in Developers

SAS connection to Databricks

MaliShariat — Fri, 08 Sep 2023 04:41:12 GMT

We are using SAS(9.4) in remote linux server and we need to connect the SAS app to the databricks. I've installed saspy in the cluster.

the config setting is here

config = '''
SAS_config_names=['l****ty']
loyalty = {'java' : '/usr/bin/java',
'iomhost' : 'lnzlwl*****.lnzl.co.nz',
'iomport' : 18**2,
'authkey' : 'l****ty',
'encoding' : 'latin1'
}
'''

I got this error:

The application could not log on to the server "lnzl********.lnzl.co.nz:18**2". The machine name is not valid.

I am sure about the host and port since I copied from SAS app

Please advise

Thanks

Re: SAS connection to Databricks

SASKiwi — Fri, 08 Sep 2023 22:38:53 GMT

What SAS/ACCESS product are you using to connect to Databricks? SAS/ACCESS to Databricks / ODBC / JDBC? Have you configured the ACCESS product to work with Databricks?

Re: SAS connection to Databricks

MaliShariat — Sat, 09 Sep 2023 10:39:55 GMT

I am using saspy package to do this connection and do this setting, set the config as above and then run this command:

sas = saspy.SASsession()

got this error:

Using SAS Config named: loyalty
We failed in getConnection
The application could not log on to the server "lnzlwlgs****01.lnzl.co.nz:18592". The machine name is not valid.

SAS process has terminated unexpectedly. Pid State= (1780, 64000)
SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

Re: SAS connection to Databricks

LinusH — Sun, 10 Sep 2023 11:49:49 GMT

The only trouble shooting advice I can give is try to ping the server from the instance this configuration file is being used.

Other than that, try SAS tech support.

It feels like a SAS/ACCESS to ODBC would be easier to setup. But maybe you prefer working with notebooks, even if it's SAS code (or I may misunderstood how this is working)?

Re: SAS connection to Databricks

MaliShariat — Sun, 10 Sep 2023 21:09:03 GMT

Yes, we need to connect to SAS by notebook.
I've tried to change my configuration and used IP address of server, the type of error is changed, before it said the machine name is incorrect now it said the port is incorrect, could you help me to find how I can find SAS is using which port?

config = '''
SAS_config_names=['loyalty']
loyalty = {'java' : '/usr/bin/java',
'autoexec'  : 'options filesystem=hfs;',
'iomhost'   : '192.168.**.176',
'iomport'   : 8591,
'authkey'   : 'loyalty',
'appserver' : 'lnzlwlgs****01.lnzl.co.nz'
}
'''

Re: SAS connection to Databricks

SASKiwi — Mon, 11 Sep 2023 00:09:18 GMT

AFAIK, SASPy provides an interface between Python and SAS. When you run Python code in SASPy it is converted into SAS code that runs in your SAS installation. I don't see how this could possibly work with Databricks unless you had a SAS product (like SAS/ACCESS) able to do this, unless I'm completely misunderstanding what's possible.

Re: SAS connection to Databricks

sastpw — Mon, 11 Sep 2023 18:41:24 GMT

hosts and ports are defined in metadata. You can see what they are using SMC, or via proc iomoperate:
https://sassoftware.github.io/saspy/advanced-topics.html#using-proc-iomoperate-to-find-object-spawner-hosts-and-workspace-server-ports

Re: SAS connection to Databricks

sastpw — Wed, 20 Sep 2023 14:10:05 GMT

Did you figure out your host and port? Also, you had the `appserver` key in your posted config, with an invalid value. It's not clear you need that, but specifying it with an invalid value will cause a problem. Not seeing the actual errors or output from what you're trying doesn't help. Can you show the code you're submitting and all of the output? Do you still need help with this? Or did you get it working?

Tom