SAS connection to Databricks

[MaliShariat]

Hi

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

[SASKiwi]

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?

[MaliShariat]

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.

[LinusH]

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)?

[MaliShariat]

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'
}
'''

[SASKiwi]

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.

[sastpw]

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-spawne...

[sastpw]

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